Show HN: Postgres.js – Fastest Full-Featured PostgreSQL Client for Node and Deno

I’m curious, how does this project compare to slonik that is also a fast, lightweight, full featured, using SQL template literals etc ? Is there any reason to consider switching, for example?

> Any plans for Knex support?

That question doesn't really make sense. I'm not familiar with this library, but the developer interface is very similar to slonik. The whole point of this is that SQL tagged template literals replace the need for a query builder like Knex.

Here is a good blog post from the author of slonik explaining: https://gajus.medium.com/stop-using-knex-js-and-earn-30-bf41...

There is quite a big difference, but I'll highlight some of the main points here. Note I'm the author of Postgres.js so I'm obviously biased.

Slonik is a wrapper around another node driver (pg), so it's performance is the same as that, where Postgres.js is significantly faster (2-5x)[1].

Postgres.js is also a zero dependency module, whereas Slonik has quite the dependency graph meaning - compare https://npmgraph.js.org/?q=slonik with https://npmgraph.js.org/?q=postgres. That makes it more difficult to audit the code and preventing chain attacks etc.

Slonik also doesn't have the same lean straight forward developer experience as Postgres.js - again I'm biased saying that ;)

Postgres.js also does things that will make your queries perform better out of the box by implicitly creating prepared statements and using pipelining.

I suppose you could build Slonik on top of Postgres.js instead of pg as well, but that would probably only make sense if migrating to Postgres.js.

[1] http://github.com/porsager/postgres-benchmarks#results

I actually replaced WTFPL with Unlicense since someone at google couldn't use it, so I would think it's ok?

Yeah, I think it could make sense for performance reasons to make a version for Knex, but since I try to stay away from ORMs as much as possible I'm probably not the right one to make it ;)

I also wouldn't put it in the core library anyway, so it should be straight forward for someone else to make a knex-postgres package that does this?