Search Results for "pg"

pg-mem is an in-memory PostgreSQL emulator for Node.js and TypeScript that allows you to simulate a Postgres database without a real server. It’s perfect for unit testing and development scenarios where spinning up a full database would be too heavy. pg-mem supports many Postgres features and is compatible with various ORMs like TypeORM and Sequelize.

...Started by Theo Ephraim, now maintained by Salsita Software. Installing this module adds a runnable file into your node_modules/.bin directory. If installed globally (with the -g option), you can run node-pg-migrate and if not, you can run ./node_modules/.bin/node-pg-migrate. Add "migrate": "node-pg-migrate" to scripts section of package.json so you are able to quickly run commands. Run npm run migrate create my first migration. It will create file xxx_my-first-migration.js in migrations folder. Now you should put your DB connection string to DATABASE_URL environment variable and run npm run migrate up. ...

pg-listen is a Node.js library that simplifies listening to PostgreSQL notifications via the LISTEN/NOTIFY mechanism. It enables real-time event handling by subscribing to PostgreSQL channels and reacting to database changes. pg-listen is ideal for applications needing real-time updates or inter-process communication.