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.
Postgres row locks in practice

Postgres row locks in practice

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

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

Comments
5 min read
Postgres vs MySQL: Picking the Right Database for a New Service

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

1
Comments 1
5 min read
PostgreSQL 19 - Monitoring Lock Contention and Fast-Path Overflow with pg_stat_lock

PostgreSQL 19 - Monitoring Lock Contention and Fast-Path Overflow with pg_stat_lock

2
Comments
7 min read
HIPAA compliance evidence for the database layer on Supabase: RLS, functions, triggers and audit logs

HIPAA compliance evidence for the database layer on Supabase: RLS, functions, triggers and audit logs

Comments 4
3 min read
Test the migration before it tests production: rehearsing AI-generated database changes

Test the migration before it tests production: rehearsing AI-generated database changes

Comments
4 min read
Debezium Postgres to Kafka: Every Setting Explained

Debezium Postgres to Kafka: Every Setting Explained

Comments
8 min read
I Put a Rust Proxy Between My App and PostgreSQL. Here's What Happens to Every Connection.

I Put a Rust Proxy Between My App and PostgreSQL. Here's What Happens to Every Connection.

Comments
2 min read
infinite recursion detected in policy for relation (42P17)

infinite recursion detected in policy for relation (42P17)

Comments
4 min read
my dashboard said a post from seconds ago would happen in 7 hours

my dashboard said a post from seconds ago would happen in 7 hours

Comments
1 min read
COD Isn't "Paid." It's a Receivable.

COD Isn't "Paid." It's a Receivable.

Comments 1
2 min read
How do you catch N+1 queries before production?

How do you catch N+1 queries before production?

Comments
1 min read
I Built an AI Expense Auditor: Vision LLM + Rule-Based Fraud Detection + Multi-Currency Payouts

I Built an AI Expense Auditor: Vision LLM + Rule-Based Fraud Detection + Multi-Currency Payouts

Comments
4 min read
I'm Building an Open-Source PostgreSQL Backup and Recovery Tool. Help Me Test It.

I'm Building an Open-Source PostgreSQL Backup and Recovery Tool. Help Me Test It.

Comments 1
4 min read
Building an evidence-based job application tracker with Rails 8, pgvector and Claude

Building an evidence-based job application tracker with Rails 8, pgvector and Claude

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