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.
Supabase RLS in production: four traps that silence your queries

Supabase RLS in production: four traps that silence your queries

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

Rebuild a CQRS Read Model With Zero Downtime

1
Comments
7 min read
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Comments 1
8 min read
The Outbox Pattern in PHP from Scratch (No Library, 80 Lines)

The Outbox Pattern in PHP from Scratch (No Library, 80 Lines)

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