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 sent a PR to postgres.js that implements neon's flavor of sql-over-ws: https://github.com/porsager/postgres/pull/955

[nicksrandall]

FWIW, we are now using this in production: https://github.com/brevitybuilder/postgres