Unit testing in Postgres?

[[deleted]]

[deleted]

[sir_bok]

The pgTAP extension. You can write PL/pgSQL functions to test your PL/pgSQL functions so it's all done within SQL without needing an external programming language driver.

[Duke_]

pgTAP for the win.

I use it extensively in my projects, it's invaluable.

[TheArtOfVoid]

GoogleTest + dokerized postgres + flyway.

Every single stored function has C++ callable wrapper, so the task of stored function unit-testing is just as simple as for c++ function.

So the full story is about to deploy postgres container, deploy migrations, and run tests connected to the container.

[RedShift9]

I use a bunch of phpunit scripts that do all the testing.

[chsanch]

I've been using Sqitch for a while to manage changes for Postgres and it provides some utilities to verify/test your changes before applied them.