Postgres.js variant

[uncomplexity]

Postgres.js as alternative to pg?

• https://github.com/porsager/postgres
• https://github.com/porsager/postgres-benchmarks
• https://porsager.github.io/imdbench/sql.html
• https://github.com/kysely-org/kysely-postgres-js
• https://orm.drizzle.team/docs/get-started-postgresql

[jawj]

Thanks for the suggestion. Is there a particular platform that has WebSockets but no TCP you want to use this on?

[nicksrandall]

IMHO, Postgres.js is faster and lighter than pg and it's API is more similar to the http api so this could be a way to "unify" the api's in this library.

[uncomplexity]

Thanks for the suggestion. Is there a particular platform that has WebSockets but no TCP you want to use this on?

well i thought of using vercel for a project, then i dug deeper i realized they're using this as a dependency, which uses pg.

seconding what @nicksrandall said, i think other users will also benefit from the perf gains.

[nicksrandall]

I started to play around with implementing a Postgres.js version of this library... right now it only supports the sql-over-http protocol (which is the use-case I have) but we could add support for sql-over-websockets in the future.

https://github.com/nicksrandall/neon-sql

Warning: This is still very experimental and I may never finish it but it's a start!

[nicksrandall]

I sent a PR to postgres.js that implements neon's flavor of sql-over-ws: porsager/postgres#955