news
PostgreSQL: LibreDB Studio introduced, poisoned Postgres connection pools
-
PostgreSQL ☛ LibreDB Studio: an open source, self-hosted SQL IDE for PostgreSQL in the browser
LibreDB Studio is an MIT-licensed, self-hosted SQL IDE for PostgreSQL that runs in the browser and deploys as a container or Helm chart.
It is deployed next to the database it manages, as a container, a Helm chart or an npm package, rather than installed on each developer's machine. PostgreSQL is its reference implementation: the provider is built on node-postgres, and the other supported engines follow the patterns established there.
-
PlanetScale ☛ Poisoned Postgres connection pools — PlanetScale
Did you know you can poison your Postgres connection pool?
Most people have no idea what this means, but it could take down your entire database if you're not careful managing your connection pooler. An engineer's worst nightmare is waking up to a seemingly read-only database with no clear issue in sight.
Unfortunately, this is exactly what one of our discord friends ran into on a Tuesday evening.