Our great sponsors
-
postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
Hi everyone. Just released Postgres.js v3 today.https://github.com/porsager/postgres / npm install postgresA bit more than two years ago I released the first version of Postgres.js. A fully functional PostgreSQL driver for Node.js written as a learning experience out of curiosity and annoyance with the current options. It greatly outperformed the alternatives[1] using pipelining and prepared statements, while providing a much better development experience safe from SQL injections. Since then I've been busy building things using it, now running in production, and although quite delayed I'm so happy to release v3 today with some really exciting new features:
I don't want this thread to become a promo of another library, but for the query part building, check out https://github.com/gajus/slonik.
The only real solution to this is to proxy your database connections through something like RDS Proxy or pgBouncer. There are databases that can natively handle managing a lot of connections, but Postgres isn't one of them.