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.
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
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 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
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
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
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
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
Rebuild a CQRS Read Model With Zero Downtime

Rebuild a CQRS Read Model With Zero Downtime

1
Comments
7 min read
Migrating From a JSON Column to a Proper Schema in Postgres

Migrating From a JSON Column to a Proper Schema in Postgres

1
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.