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.
Moving a desktop app from PostgreSQL to SQLite without losing a cent

Moving a desktop app from PostgreSQL to SQLite without losing a cent

Comments
5 min read
Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

Comments
12 min read
Getting PostgreSQL ready for Black Friday: a SQL-first checklist

Getting PostgreSQL ready for Black Friday: a SQL-first checklist

Comments
25 min read
Postgres not using your index? It's counting pages, not rows

Postgres not using your index? It's counting pages, not rows

Comments
10 min read
Send purchase events from the server, not only from the thank-you page

Send purchase events from the server, not only from the thank-you page

Comments
4 min read
Webhook Retries: Deduplicate the Event Without Losing the Work

Webhook Retries: Deduplicate the Event Without Losing the Work

Comments 1
3 min read
Two queries too many: removing each_batch from GitLab's Maven snapshot cleanup

Two queries too many: removing each_batch from GitLab's Maven snapshot cleanup

Comments
7 min read
5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

Comments
4 min read
Supabase Free Has No Backups — Here's the Free Way to Add Them

Supabase Free Has No Backups — Here's the Free Way to Add Them

Comments
5 min read
52 CVEs fixed, but apt still serves the old build

52 CVEs fixed, but apt still serves the old build

Comments
4 min read
Crunchy Bridge vs ClickHouse Managed Postgres for AI Agents

Crunchy Bridge vs ClickHouse Managed Postgres for AI Agents

4
Comments
18 min read
How to Diagnose and Fix N+1 Query Problems in PostgreSQL and Node.js

How to Diagnose and Fix N+1 Query Problems in PostgreSQL and Node.js

1
Comments
5 min read
How to Prevent Equipment Double-Booking with PostgreSQL (A Race Condition Fix)

How to Prevent Equipment Double-Booking with PostgreSQL (A Race Condition Fix)

Comments
6 min read
Your moneyline parser can reverse the odds ranking

Your moneyline parser can reverse the odds ranking

Comments
7 min read
PostgreSQL errors in your first month, and what they actually mean

PostgreSQL errors in your first month, and what they actually mean

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