voxpelli/pg-utils

This is a small toolkit that helps developers write tests for applications that use PostgreSQL databases. Instead of manually setting up and tearing down test databases, this library automates the repetitive work. Here's what it does in practice: you point it at a SQL file that defines your database schema and a folder of CSV files containing test data. The library will create fresh tables before each test, load your fixture data, run your test, and then clean everything up automatically. It handles the messy details, like acquiring database locks so multiple tests don't step on each other, managing connection pools, and respecting table dependencies (so it drops tables in the right order). You just call a setup function at the start of your test and focus on writing assertions. The library offers three main ways to use it, depending on your testing style. If you're using Node's built-in test framework, the easiest is pgTestSetupFor, which sets up the database and automatically registers cleanup in the test's teardown hook, no extra code needed. If you prefer JavaScript's await using syntax (which looks like a finally block), you can use pgTestSetup instead. For more control, you can instantiate PgTestHelpers directly and call methods like initTables(), insertFixtures(), and removeTables() in whatever order you need. The README doesn't go into detail, but the library also includes utility functions for exporting tables to CSV files and importing them back, useful if you want to snapshot your test data or share fixtures across projects. The code is written in modern JavaScript (ESM) and includes TypeScript-style type hints embedded in comments, so you get good editor support even if you're not using TypeScript. Who uses this? Backend developers writing integration tests for Node.js applications that need a real PostgreSQL database. Instead of mocking the database layer, they get a fast, clean database state for every test, which catches real bugs that unit tests miss.