PostgresJs: PostgreSQL client for Node.js and Deno
1–10 of 148 posts
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#2The benchmarks linked to don't compare PostgresJs to Prisma. That would be useful.
Also the link text (Fastest full-featured node & deno client) should include the word benchmark, for those looking for one.
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#3Postgres.js is one of the best libraries I’ve ever used!
Its use of templating in JS is really intuitive.
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#4I was wondering how old this project is:
v1.0.1 - Jan 2020
v2.0.0 - Jun 2020 but never left beta.
v3.0.0 - Mar 2022, which appears to be when the project really got started.
I also wonder how solid it is, because it looks very interesting.
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#5I feel obliged to namedrop Zapatos here, another postgres JS client with a remarkably similar design (sql in template strings), but fully typesafe. If TypeScript is your thing, you might appreciate it: https://jawj.github.io/zapatos/
Personally I feel it’s one of the best designed (and documented) TS libraries out there and I’m sad it’s not very well known.
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#6The demo gif is fabulous.
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#7I feel obliged to namedrop Zapatos here, another postgres JS client with a remarkably similar design (sql in template strings), but fully typesafe. If TypeScript is your thing, you might appreciate it: https://jawj.github.io/zapatos/ Personally I feel it’s one of the best designed (and documented) TS libraries out there and I’m sad it’s not very well known.
Seconded. The lateral join features in combination with the shortcut functions make it exceptionally easy to build backends with actual SQL, without compromising on ease of use.
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#8For people who would like a more safe and structured approach (but almost as powerful and with the option to resort to SQL strings if needed) I highly recommend checking out Prisma https://www.prisma.io/
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#9>> Prepared statements will automatically be created for any queries where it can be inferred that the query is static
What does this mean in practice? Like, actual prepared statements are created against the DB session if there are no bound variables, even if that query is only made once?
If so, it's an interesting but highly opinionated approach...
Re: PostgresJs: PostgreSQL client for Node.js and Deno
#10Also see: https://github.com/gajus/slonik