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

Rebuild a CQRS Read Model With Zero Downtime

1
Comments
7 min read
My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator

My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator

2
Comments
4 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
Redis vs Read Replica vs Materialised View: Pick the Right One

Redis vs Read Replica vs Materialised View: Pick the Right One

Comments
7 min read
Idempotency Keys: Where to Put Them, How Long to Keep Them

Idempotency Keys: Where to Put Them, How Long to Keep Them

Comments
6 min read
Hybrid Search in 100 Lines: BM25 + pgvector with RRF Merge

Hybrid Search in 100 Lines: BM25 + pgvector with RRF Merge

Comments
6 min read
Outbox Pattern in Postgres, End to End: Producer, Relayer, Consumer

Outbox Pattern in Postgres, End to End: Producer, Relayer, Consumer

1
Comments
7 min read
MongoDB vs Postgres: A Decision Table That Actually Picks For You

MongoDB vs Postgres: A Decision Table That Actually Picks For You

Comments
6 min read
How to Anonymize PII in PostgreSQL for Development

How to Anonymize PII in PostgreSQL for Development

Comments
8 min read
Idempotency Situation

Idempotency Situation

2
Comments
3 min read
Connecting Power BI to SQL Databases

Connecting Power BI to SQL Databases

Comments
10 min read
Durability

Durability

1
Comments
3 min read
Prisma Migrations in Production: Zero-Downtime Strategies and Rollback Patterns

Prisma Migrations in Production: Zero-Downtime Strategies and Rollback Patterns

Comments
3 min read
How I caught a silent NaN bug in production RAG, by asking the system to debug itself

How I caught a silent NaN bug in production RAG, by asking the system to debug itself

Comments
6 min read
Un agente borró mi base de datos en producción: lo que mis logs dicen que el post viral de HN omite

Un agente borró mi base de datos en producción: lo que mis logs dicen que el post viral de HN omite

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