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.
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
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
Stripe Webhook Idempotency in FastAPI: Handling Duplicate Events Without Double-Charging SaaS Customers

Stripe Webhook Idempotency in FastAPI: Handling Duplicate Events Without Double-Charging SaaS Customers

1
Comments 1
5 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
Three Ways to Set Up CDC from Postgres to ClickHouse

Three Ways to Set Up CDC from Postgres to ClickHouse

1
Comments
9 min read
Don’t Trust Backups You Haven’t Restored

Don’t Trust Backups You Haven’t Restored

Comments
8 min read
Releasing HeliosProxy, The programmable Postgres data-plane

Releasing HeliosProxy, The programmable Postgres data-plane

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