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.
Let Claude Code read your production database — even a write disguised as SELECT gets refused

Let Claude Code read your production database — even a write disguised as SELECT gets refused

Comments
4 min read
4,300 tests, written by an AI: how they were planned, run and enforced

4,300 tests, written by an AI: how they were planned, run and enforced

Comments
3 min read
PostgreSQL's recovery_prefetch prefetches pages the WAL already holds

PostgreSQL's recovery_prefetch prefetches pages the WAL already holds

Comments
6 min read
Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

Comments
7 min read
Changing one number from 32 to 34 made a Postgres query 6,000 faster. Here's exactly why.

Changing one number from 32 to 34 made a Postgres query 6,000 faster. Here's exactly why.

Comments
12 min read
Context Rot: Why Your RAG Pipeline Degrades Without Anyone Deploying Anything

Context Rot: Why Your RAG Pipeline Degrades Without Anyone Deploying Anything

Comments 1
5 min read
Three checks that look like they passed, but validated nothing

Three checks that look like they passed, but validated nothing

1
Comments 2
5 min read
Cutting LLM Calls in Incident Triage: Sliding Windows, Log Reduction, and a pgvector Cache

Cutting LLM Calls in Incident Triage: Sliding Windows, Log Reduction, and a pgvector Cache

Comments
6 min read
Supabase Storage upload fails with "new row violates row-level security policy"? Here's the fix

Supabase Storage upload fails with "new row violates row-level security policy"? Here's the fix

Comments
3 min read
Konut projesinde ünite stok haritasını kodla kurmak: Durum makinesi, süreli opsiyon, eşzamanlı rezervasyon ve canlı güncelleme

Konut projesinde ünite stok haritasını kodla kurmak: Durum makinesi, süreli opsiyon, eşzamanlı rezervasyon ve canlı güncelleme

Comments
10 min read
GORM counted 11 rows. PostgreSQL found 7 distinct pairs.

GORM counted 11 rows. PostgreSQL found 7 distinct pairs.

Comments
3 min read
How to deploy a FastAPI app on Ownkube

How to deploy a FastAPI app on Ownkube

1
Comments
6 min read
Postgres full-text search is enough for most side projects

Postgres full-text search is enough for most side projects

Comments
1 min read
Postgres full-text search is enough for most side projects

Postgres full-text search is enough for most side projects

Comments
1 min read
How to deploy a Django app on Ownkube

How to deploy a Django app on Ownkube

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