[rubenv]

Or in Go, with full databases: https://github.com/rubenv/pgtest/

[rad_gruchalski]

And the same but with Docker: https://gruchalski.com/posts/2021-04-24-on-software-testing-....

[numlock86]

I use the same approach but with other languages and runtimes like Java, .NETcore/C# or NodeJS, as this is basically just a CLI wrapper for pg anyway. Works very well and doesn't come with all the overhead.