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