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.
Sharding Strategies in 2026: Range, Hash, Geo, Directory — Which Wins When

Sharding Strategies in 2026: Range, Hash, Geo, Directory — Which Wins When

Comments
7 min read
The Replication Lag Question That Shows Up in Most Senior Interviews

The Replication Lag Question That Shows Up in Most Senior Interviews

Comments
7 min read
SQL Window Functions Explained: Stop Collapsing Your Data with GROUP BY

SQL Window Functions Explained: Stop Collapsing Your Data with GROUP BY

Comments
6 min read
Supabase RLS in production: four traps that silence your queries

Supabase RLS in production: four traps that silence your queries

Comments
6 min read
RLS Supabase en prod : quatre pièges qui silencent tes requêtes

RLS Supabase en prod : quatre pièges qui silencent tes requêtes

Comments
7 min read
The Heart of B3: Building the Matching Engine with RabbitMQ, Redis and Spring Boot

The Heart of B3: Building the Matching Engine with RabbitMQ, Redis and Spring Boot

Comments
5 min read
O Coração da B3: Construindo o Matching Engine com RabbitMQ, Redis e Spring Boot

O Coração da B3: Construindo o Matching Engine com RabbitMQ, Redis e Spring Boot

Comments
5 min read
The 4 Postgres Extensions That Stopped Being Optional in 2026

The 4 Postgres Extensions That Stopped Being Optional in 2026

Comments
8 min read
The 6-Line Postgres Migration That Halved a Team's LLM Bill

The 6-Line Postgres Migration That Halved a Team's LLM Bill

Comments
7 min read
Postgres 18 Just Made 80% of Your NoSQL Migration Plan Pointless

Postgres 18 Just Made 80% of Your NoSQL Migration Plan Pointless

Comments
7 min read
What I Got Wrong Building a RAG Pipeline from Scratch in TypeScript

What I Got Wrong Building a RAG Pipeline from Scratch in TypeScript

2
Comments
9 min read
The Cursor Pagination That Worked Until Five Rows Shared a Timestamp

The Cursor Pagination That Worked Until Five Rows Shared a Timestamp

Comments
6 min read
pg_ilib: Compact Typed Binary Serialization for PostgreSQL

pg_ilib: Compact Typed Binary Serialization for PostgreSQL

Comments
4 min read
Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison

Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison

Comments
8 min read
Choosing Postgres, MongoDB, or DynamoDB: The 4 Questions That Actually Decide It

Choosing Postgres, MongoDB, or DynamoDB: The 4 Questions That Actually Decide It

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