what about pg-promise?

[vitaly-t]

Have you seen pg-promise? It can do all that already, and much more ;)

[summer4096]

pg-promise is very comprehensive, but I wanted something simpler. simple-postgres doesn't require any configuration, supports common use cases, and is ~200 lines of code.

pg-postgres has all kinds of amazing features: ORM, Transaction modes, nested transactions, custom type handling, SQL minification, a templating system, etc.

simple-postgres has a function that runs a query, a function that runs a transaction, and a function that escapes a value.

For most cases, that's enough.

[vitaly-t]

pg-promise does not have ORM features, it's just a query executioner 😸

simple-postgres has a function that runs a query, a function that runs a transaction, and a function that escapes a value.

But pg-promise does all that as well, and in a very simple way 😕 :

• db.query
• db.func
• db.tx

See Database type 😉