Add pg-mem

[oguimbal]

Hi !

Would you consider adding pg-mem to this list ?

It's a pure js in-memory postgres database emulator easing unit/integration testing.

It also implements adapters which allow to wrap an in-memory db to some awesome nodejs db libs.

👉 Play with it here

Why is it worth it ?

When testing code that use a db, you usually have to choose between those options :

• Mock all your requests... this is quite painful, doesnt work for end-to-end tests, and locks-down implementation details.
• Run a real clean instance of your db by running your tests in docker... this has a really high overhead, and is hard to setup.
• Fallback to in-memory sqlite if supported by your ORM... this wont work if you use db-specific features (like @> operator with postgres)
• Use a real database ... that's a bad idea, for various obvious reasons. You're gonna hate yourself.

pg-mem is another option, which:

• Is easier to setup
• Is faster: since it's pure JS, you dont have any network or booting overhead.
• Allows you to introspect your queries
• You can even inspect the parsed syntax trees of executed SQL, since its parser is also open source

See FAQ for details.