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.
Snapshotting a DigitalOcean Droplet while it's running

Snapshotting a DigitalOcean Droplet while it's running

5
Comments
6 min read
Finding and Killing N+1 Queries in a Rails API Before Your Users Notice

Finding and Killing N+1 Queries in a Rails API Before Your Users Notice

Comments
4 min read
Extension Tables, Expo Configs, and Static MCP Scanners in supabase-rls-check 0.6.3

Extension Tables, Expo Configs, and Static MCP Scanners in supabase-rls-check 0.6.3

Comments
5 min read
Three-Way Invoice Matching: Automating AP in Custom ERP

Three-Way Invoice Matching: Automating AP in Custom ERP

Comments
7 min read
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
Designing multi-tenant Supabase Row Level Security for an AI PRD generator

Designing multi-tenant Supabase Row Level Security for an AI PRD generator

Comments 1
3 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 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
The two-account test: one check to run on your Supabase app before launch

The two-account test: one check to run on your Supabase app before launch

Comments
2 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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.