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.
Postgres LISTEN/NOTIFY in Production: Safe Reconnects & SSE

Postgres LISTEN/NOTIFY in Production: Safe Reconnects & SSE

Comments
7 min read
Databricks buys Electric to embed local Postgres in AI agents

Databricks buys Electric to embed local Postgres in AI agents

Comments
5 min read
Backups That You Don't Restore Aren't Backups: A Weekly Restore Drill

Backups That You Don't Restore Aren't Backups: A Weekly Restore Drill

Comments 1
6 min read
Why AI-Generated Migrations Need a Different Gate Than Code Patches

Why AI-Generated Migrations Need a Different Gate Than Code Patches

Comments 1
4 min read
I built a Supabase RLS audit that's just SQL wrapped in a prompt

I built a Supabase RLS audit that's just SQL wrapped in a prompt

Comments
4 min read
We found a bug that let our test suite write to production. Here's what we did about it.

We found a bug that let our test suite write to production. Here's what we did about it.

Comments 2
2 min read
The Data Structure Behind Every Database Index: B+ Trees

The Data Structure Behind Every Database Index: B+ Trees

Comments
5 min read
I Finally Got pgAdmin 4 Working in FlyEnv on Windows — Here’s What Actually Went Wrong

I Finally Got pgAdmin 4 Working in FlyEnv on Windows — Here’s What Actually Went Wrong

Comments
2 min read
Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

Comments
4 min read
Composite Indexes Explained: Why Column Order Is the Whole Game

Composite Indexes Explained: Why Column Order Is the Whole Game

Comments
4 min read
PostgreSQL Internals: What Happens When You Run SELECT *

PostgreSQL Internals: What Happens When You Run SELECT *

1
Comments
2 min read
Why I Chose PDF RAG Chunking and Metadata for Catalog Semantic Search

Why I Chose PDF RAG Chunking and Metadata for Catalog Semantic Search

Comments
6 min read
Your AI agent writes migrations that look safe. Here's what they actually do to Postgres.

Your AI agent writes migrations that look safe. Here's what they actually do to Postgres.

Comments 2
5 min read
Benchmarkée el ORM Postgres nativo de mi lenguaje contra SQLAlchemy: ~8 más rápido en reads, 5.7 menos memoria — y dónde empata

Benchmarkée el ORM Postgres nativo de mi lenguaje contra SQLAlchemy: ~8 más rápido en reads, 5.7 menos memoria — y dónde empata

Comments
6 min read
I benchmarked my language's native Postgres ORM against SQLAlchemy: ~8 faster reads, 5.7 less memory — and where it ties

I benchmarked my language's native Postgres ORM against SQLAlchemy: ~8 faster reads, 5.7 less memory — and where it ties

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