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