DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Comments
4 min read
28 migration files, two of which cancel each other out, and not one of them written by hand

28 migration files, two of which cancel each other out, and not one of them written by hand

1
Comments
6 min read
Supabase's Oct 30 grants change: what breaks, and the fix that leaks

Supabase's Oct 30 grants change: what breaks, and the fix that leaks

Comments 2
4 min read
PostgreSQL Point-in-Time Recovery in Kubernetes: WAL-G + Stolon Pattern

PostgreSQL Point-in-Time Recovery in Kubernetes: WAL-G + Stolon Pattern

Comments
3 min read
Why Dropping "await" is Broken: Building a Resilient Background Task Engine with Node.js, Redis Streams, and PostgreSQL

Why Dropping "await" is Broken: Building a Resilient Background Task Engine with Node.js, Redis Streams, and PostgreSQL

Comments
4 min read
Building an Agentic System in .NET, Part 3: Durable Memory with Postgres and pgvector

Building an Agentic System in .NET, Part 3: Durable Memory with Postgres and pgvector

Comments
6 min read
Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

1
Comments
7 min read
Drizzle vs Prisma in 2026: Benchmarks, Drizzle 1.0, Prisma 8 and Which to Choose

Drizzle vs Prisma in 2026: Benchmarks, Drizzle 1.0, Prisma 8 and Which to Choose

Comments
14 min read
UUIDv7 in PostgreSQL 18: uuidv7() vs UUIDv4 vs bigint Primary Keys, Benchmarked

UUIDv7 in PostgreSQL 18: uuidv7() vs UUIDv4 vs bigint Primary Keys, Benchmarked

Comments
11 min read
pgvector vs Pinecone vs Qdrant: Benchmarked for RAG in 2026

pgvector vs Pinecone vs Qdrant: Benchmarked for RAG in 2026

Comments
12 min read
After an API Key Leak in 2026 — Establish Actual Touches with Postgres Logs

After an API Key Leak in 2026 — Establish Actual Touches with Postgres Logs

Comments
6 min read
Postgres triggers invalidate our Redis cache at Oizom

Postgres triggers invalidate our Redis cache at Oizom

Comments
11 min read
When crt.sh's website is down, query its public database instead

When crt.sh's website is down, query its public database instead

1
Comments
4 min read
Migrating a Large Table Without Locking Production

Migrating a Large Table Without Locking Production

4
Comments 1
15 min read
Two campaigns in one city import the listing once, and the cache key is a half degree square

Two campaigns in one city import the listing once, and the cache key is a half degree square

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.