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.
pgbrake: an undo button for Postgres when an AI agent is driving
zhangautomation profile

pgbrake: an undo button for Postgres when an AI agent is driving

#postgres #ai #mcp #opensource
Comments 1
2 min read
Postgres row locks in practice
camerondev profile

Postgres row locks in practice

#postgres #database #backend
Comments
1 min read
Read Your Supabase Bill: Compute, Usage, and What the Spend Cap Covers (and Doesn't), Plus a Small Cost Simulator
tomozilla profile
Tomo

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

#supabase #postgres #beginners #webdev
Comments
7 min read
One Supabase Project per Customer: Apply a Template, Catch Hand-Made Changes With a Schema Fingerprint, Hand Over, and Split the Costs
tomozilla profile
Tomo

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

#supabase #postgres #beginners #webdev
Comments
7 min read
Rollback Capability Makes pg_walex a Truth Regret Pill
hex_song_0412c3f3fb7836b6 profile

Rollback Capability Makes pg_walex a Truth Regret Pill

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

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

#supabase #postgres #beginners #webdev
Comments
6 min read
Supabase RLS policy examples: copy-paste policies for 7 common app patterns
sniffpup profile

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

#supabase #postgres #security #webdev
Comments
7 min read
Your database says "saved" before it touches the table. Here's why that's safe.
vladut02 profile
VLAD

Your database says "saved" before it touches the table. Here's why that's safe.

#database #postgres #sql #backend
Comments
5 min read
Deep Dive: GST Reconciliation Software in GSTBot
sumaninster profile

Deep Dive: GST Reconciliation Software in GSTBot

#python #fastapi #react #postgres
Comments
4 min read
How a read replica almost took down its primary database and other database tales
marekzp profile

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

#postgres #database #devops #backend
Comments
8 min read
A backup you've never restored is just a rumour
the_saint_dac63e343ee8704 profile

A backup you've never restored is just a rumour

#backups #postgres #devops #selfhosting
Comments
4 min read
The Silent CDC Bug: Data Loss With No Errors
pipelinewhiteboard profile

The Silent CDC Bug: Data Loss With No Errors

#dataengineering #postgres #kafka #database
Comments
7 min read
Two Duplicate Rows in 48 Hours: My Unique Index Treats NULL as a New Value
codepy_1473 profile

Two Duplicate Rows in 48 Hours: My Unique Index Treats NULL as a New Value

#postgres #database #debugging #sql
Comments
5 min read
Postgres vs MySQL: Picking the Right Database for a New Service
mubashirtaj profile

Postgres vs MySQL: Picking the Right Database for a New Service

#webdev #database #postgres #programming
1
Comments 1
5 min read
What SKIP LOCKED Solves, and What It Leaves to You
mrviduus profile

What SKIP LOCKED Solves, and What It Leaves to You

#postgres #database #distributedsystems #dotnet
8
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.