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.
PostgreSQL UPSERT with History: From 90 Seconds to 5 with CTE

PostgreSQL UPSERT with History: From 90 Seconds to 5 with CTE

Comments
4 min read
The budget that actually blocks: the concurrency bug an AI agent's spend guardrail can't afford

The budget that actually blocks: the concurrency bug an AI agent's spend guardrail can't afford

Comments
5 min read
What happens when a PostgreSQL backend crashes?

What happens when a PostgreSQL backend crashes?

Comments
7 min read
FOR UPDATE SKIP LOCKED: the Postgres feature that saved my digital cloakroom

FOR UPDATE SKIP LOCKED: the Postgres feature that saved my digital cloakroom

Comments
3 min read
PostgreSQL Benchmark: AWS RDS vs Hostim vs Self-Hosted on Hetzner (2026)

PostgreSQL Benchmark: AWS RDS vs Hostim vs Self-Hosted on Hetzner (2026)

Comments
6 min read
60 jours sous Live/Snapshot/Cache : trois sauvetages, une trahison, et ce que j'ai changé

60 jours sous Live/Snapshot/Cache : trois sauvetages, une trahison, et ce que j'ai changé

Comments
7 min read
Live, Snapshot, Cache: revisiting the 3-way decision after 60 days of running it

Live, Snapshot, Cache: revisiting the 3-way decision after 60 days of running it

1
Comments
6 min read
Installing GDOM with PostgreSQL as the Backend Database

Installing GDOM with PostgreSQL as the Backend Database

Comments
3 min read
My public view leaked every user's email. The AI called it "partial user data."

My public view leaked every user's email. The AI called it "partial user data."

Comments
3 min read
Auth Email Outbox Checks in PostgreSQL

Auth Email Outbox Checks in PostgreSQL

Comments
4 min read
Why your Supabase bill is actually $110/mo — and what to do about it

Why your Supabase bill is actually $110/mo — and what to do about it

Comments
2 min read
Como servir os 68 milhões de CNPJs da Receita com ~10ms de latência em Go

Como servir os 68 milhões de CNPJs da Receita com ~10ms de latência em Go

Comments
4 min read
Building Vidiflow: A Production-Grade Video Downloader Backend in TypeScript

Building Vidiflow: A Production-Grade Video Downloader Backend in TypeScript

Comments
5 min read
3 Supabase security incidents, one shared root cause: SECURITY DEFINER inherits EXECUTE TO PUBLIC

3 Supabase security incidents, one shared root cause: SECURITY DEFINER inherits EXECUTE TO PUBLIC

Comments
6 min read
Node.js Email Verification Tests with PostgreSQL

Node.js Email Verification Tests with PostgreSQL

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