postgres

rm -rf on the wrong server: how GitLab lost its production database

GitLab's production DB loss underscores need for solid backup and SRE practices with PostgreSQL. · for SREs, devops engineers

Postgres Guide

Database guide released · for db admins

PostgreSQL 19 beta's parallel autovacuum launches workers but leaves vacuum time unchanged

PostgreSQL 19 beta adds parallel autovacuum workers, improving maintenance efficiency. · for database admins, backend engineers

We Replaced 3 Microservices With One Postgres Table

Merging three microservices into one Postgres table streamlines backend architecture. · for backend engineers

New things for regular expressions in PostgreSQL (pg_tre and pg_re2)

PostgreSQL adds new regex extensions pg_tre and pg_re2 for richer pattern matching. · for db admins, backend devs

A Straightforward Guide for MVCC in Postgres

Guide clarifies PostgreSQL MVCC behavior, helping backend engineers avoid concurrency bugs. · for backend engineers, db admins

Installing FreeRADIUS with PostgreSQL

FreeRADIUS with PostgreSQL adds relational DB-backed authentication for network services. · for network engineers, devops

Your idempotency test probably cannot fail

Typical idempotency tests may miss failure cases in PostgreSQL-Node integrations. · for backend engineers

Inline vs. Separate Tables for Vectors in Postgres: Measuring the Join Overhead

Benchmarks inline vs separate vector tables in Postgres to assess join overhead. · for data engineers

The AI demo failed, but the database remembered half of it

AI demo failure reveals partial data persistence, stressing robust DB design. · for backend engineers

The 1.4 milliseconds that separate managed Postgres from a local one

Managed Postgres adds ~1.4 ms latency versus local, impacting performance-sensitive services. · for devops engineers

We Deleted Our Vector Database. Postgres Was Faster.

Postgres outperforms a vector DB for RAG workloads, impacting AI retrieval pipelines. · for backend engineers, AI engineers

Row-level security in Symfony: the role that ran your migrations bypasses every policy you wrote

Symfony migration role can bypass row-level security policies, risking data exposure. · for backend engineers

The No-Backend Backend: Neon Data API, RLS and 27 Attacks

Analyzes 27 attacks on Neon Data API and row-level security weaknesses. · for security engineers

CI Passed 6 of 6 Migrations. A Neon Branch of Production Passed 1

CI confirms all six migrations succeeded on Neon's production branch. · for backend engineers, devops

I'm 12. I ran a global Code Jam on a $150 phone. Here’s the Supabase architecture that held it together. 🐯

Shows how Supabase and Postgres can power large-scale events on cheap hardware. · for backend engineers, startup founders

PostgreSQL for Everything

PostgreSQL is promoted as a universal backend, useful for building diverse services. · for backend engineers

Your Audit Log Agrees With Itself. That's the Problem.

Postgres audit logs can become self-contradictory, risking data integrity checks. · for backend engineers, fintech devs

Postgres 19's REPACK rewrites a bloated table without locking out your writers

Postgres 19 REPACK can compact tables without writer downtime, improving DB maintenance. · for db admins, devops

PostgreSQL INCLUDE indexes: what problem are they trying to solve?

Explains INCLUDE indexes to cover non-key columns and boost query performance. · for database admins, backend engineers