Topic - Edition
Compare Amazon RDS Proxy and PgBouncer for PostgreSQL connection pooling on AWS. This post explains how each pooler handles pooling modes, authentication, failover, and session-state pinning, and gives you a framework…
After upgrading Amazon RDS for SQL Server to 2017 or later, CLR strict security leaves user-defined CLR assemblies unusable. This post shows how to migrate CLR logic with no native T-SQL equivalent to an AWS Lambda…
Learn how to build automated email alerts for blocking chains and long-running queries on Amazon RDS for SQL Server. This serverless solution uses AWS Lambda, Amazon CloudWatch, and Amazon SES to detect blocking,…
Introduction Between the 9th and the 10th of October, I had the privilege of participating to the second edition of the Game of Codes conference in Niš, Serbia. Since I couldn’t attend the first edition, I decided to…
Row-level security for a multi-tenant SaaS on PostgreSQL 17, result by result: what leaks, what it costs, how to set the tenant, and where each test is.
Setting the tenant for PostgreSQL row-level security in Go with pgx 5.11, measured: pgxpool, PrepareConn hooks, transactions, batches and PgBouncer.
On August 25, Robert Haas opened a pgsql-hackers thread like this: I asked Claude to evaluate which v19 patches were the scariest based on the number and type of bugs fixed post-freeze. Results below, with a few…
pg_statviz can now ask Claude, a local Ollama model, OpenAI or Gemini to explain your PostgreSQL statistics on every distro we ship it for. Getting there took three days and a few dozen new Python packages pg_statviz is…
pg_statviz can now ask Claude, a local Ollama model, OpenAI or Gemini to explain your PostgreSQL statistics on every distro we ship it for. Getting there took three days and a few dozen new Python packages pg_statviz is…
On 7 October, the London PostgreSQL Meetup group met. Organizers: Valeria Kaplan Chris Ellis Alastair Turner Speakers: Elizabeth Christensen Alex Kasko Jimmy Angelakos On 8 October the PostgreSQL England North Meetup…
Choosing a headless CMS is a five-year decision dressed up as a weekend one. Once your content, your editors' habits and your front end are built around it, switching is expensive. So it's worth understanding how the…
Override PostgreSQL's prepared statement plan choice when its cost estimates go wrong on skewed data. (I consult on PostgreSQL through PGX Inc..)
Hacker News discussion (162 points, 175 comments)
