Posts about Postgres

• 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