Posts about Knex
Connecting a Node.js app with a Postgres database
Node.js Apr 16, 2022
Learn how to connect a Node.js application both with a local Postgres database in docker-compose and with a production database.
Node.js
TypeScript
Knex
Postgres
Docker
Knex.js schema migrations with Postgres in Node.js
Node.js Apr 20, 2022
Learn how to use Knex.js schema migrations to create a first Postgres database table. Setup scripts to allow a local database reset.
Node.js
TypeScript
Knex
Postgres
Creating a Node.js DAO with Knex.js
Node.js Apr 24, 2022
Learn how to build a DAO in Node.js to execute SQL queries with Knex.js. Providing CRUD operations for a REST entity persisted in the PostgreSQL database.
Node.js
TypeScript
Knex
Postgres
Testing Knex SQL queries with Jest and testcontainers
Node.js May 20, 2022
Learn to test your Knex SQL queries with a single automatically spawned Docker Postgres database. Using testcontainers and Jest global setup and teardown.
Node.js
TypeScript
Knex
Postgres
Testcontainers
Single schema multi-tenancy in Node.js with Postgres
Node.js May 21, 2022
Learn to do multi-tenancy in a single Postgres schema in a TypeScript Node.js app. Avoid performance overhead while minimizing the risk of data exposure.
Node.js
TypeScript
Express.js
Knex
Postgres
JWT
Building an asynchronous batch job
Node.js Jun 3, 2022
Learn to structure an asynchronous batch job in a Node.js application and how to isolate the functionality from the endpoint controllers.
Node.js
TypeScript
Knex
Pino
Building an idempotent cron job with at-least-once delivery
Node.js Jun 9, 2022
Learn to build an idempotent at-least-once delivery of notifications in a scheduled Node.js batch job.
Node.js
TypeScript
Knex