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.
3 Supabase RLS mistakes I keep seeing in real projects (and the fix for each)

3 Supabase RLS mistakes I keep seeing in real projects (and the fix for each)

Comments
1 min read
SQL OPERATOR WEEK 2 21ST-22ND NOVEMBER

SQL OPERATOR WEEK 2 21ST-22ND NOVEMBER

Comments
2 min read
A campaign row with no owner, and the UPDATE that hands it over when somebody signs up

A campaign row with no owner, and the UPDATE that hands it over when somebody signs up

Comments
6 min read
Oracle to PostgreSQL Migration: The Residue Report I'd Price From

Oracle to PostgreSQL Migration: The Residue Report I'd Price From

Comments
7 min read
Supabase's 30 Oct change: check the tables you already have

Supabase's 30 Oct change: check the tables you already have

Comments
3 min read
One Supabase Project per Customer: Apply a Template, Catch Hand-Made Changes With a Schema Fingerprint, Hand Over, and Split the Costs

One Supabase Project per Customer: Apply a Template, Catch Hand-Made Changes With a Schema Fingerprint, Hand Over, and Split the Costs

Comments
7 min read
Read Your Supabase Bill: Compute, Usage, and What the Spend Cap Covers (and Doesn't), Plus a Small Cost Simulator

Read Your Supabase Bill: Compute, Usage, and What the Spend Cap Covers (and Doesn't), Plus a Small Cost Simulator

Comments
7 min read
Rollback Capability Makes pg_walex a Truth Regret Pill

Rollback Capability Makes pg_walex a Truth Regret Pill

Comments
6 min read
Organizations vs Projects in Supabase: Move a Project Between Orgs, Audit Dormant Ones, and Build a Small Inventory Board

Organizations vs Projects in Supabase: Move a Project Between Orgs, Audit Dormant Ones, and Build a Small Inventory Board

Comments
6 min read
Supabase RLS checklist for Lovable and Bolt apps: what we found in 38 codebases

Supabase RLS checklist for Lovable and Bolt apps: what we found in 38 codebases

Comments 2
9 min read
Supabase RLS policy examples: copy-paste policies for 7 common app patterns

Supabase RLS policy examples: copy-paste policies for 7 common app patterns

Comments
7 min read
Two requests, one rule, two rows: fixing the INSERT ... WHERE NOT EXISTS race in PostgreSQL

Two requests, one rule, two rows: fixing the INSERT ... WHERE NOT EXISTS race in PostgreSQL

1
Comments 2
6 min read
Deep Dive: GST Reconciliation Software in GSTBot

Deep Dive: GST Reconciliation Software in GSTBot

Comments
4 min read
How a read replica almost took down its primary database and other database tales

How a read replica almost took down its primary database and other database tales

Comments
8 min read
A backup you've never restored is just a rumour

A backup you've never restored is just a rumour

Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.