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.
How Postgres 19 checks foreign keys without running SQL

How Postgres 19 checks foreign keys without running SQL

1
Comments
6 min read
3 Production Security Pitfalls in Next.js App Router (And How to Fix Them)

3 Production Security Pitfalls in Next.js App Router (And How to Fix Them)

Comments 3
4 min read
A failed payment still gets Premium, and the column that stops a retried Stripe event from undoing a cancellation

A failed payment still gets Premium, and the column that stops a retried Stripe event from undoing a cancellation

1
Comments 2
5 min read
Automate Postgres-to-Blob with durable workflow (pg_durable + pg_duckdb) in Azure Database for PostgreSQL

Automate Postgres-to-Blob with durable workflow (pg_durable + pg_duckdb) in Azure Database for PostgreSQL

Comments
7 min read
Why I Ended Up Running Python Inside PostgreSQL to Validate XML

Why I Ended Up Running Python Inside PostgreSQL to Validate XML

Comments 2
10 min read
The Company Behind Cursor's Vector Search Just Killed the Vector-First Database

The Company Behind Cursor's Vector Search Just Killed the Vector-First Database

1
Comments
7 min read
How to monitor PostgreSQL connections, cache hit ratio and replication lag (and get paged before it hurts)

How to monitor PostgreSQL connections, cache hit ratio and replication lag (and get paged before it hurts)

Comments
4 min read
The Lease Loop Is Not a Chat Completion

The Lease Loop Is Not a Chat Completion

1
Comments
7 min read
The Redelivery Trap: Building a Safe Transactional Inbox for Google Pub/Sub

The Redelivery Trap: Building a Safe Transactional Inbox for Google Pub/Sub

Comments 2
4 min read
Enabling FIPS on UAT Postgres servers meant moving off MD5 passwords

Enabling FIPS on UAT Postgres servers meant moving off MD5 passwords

Comments 1
1 min read
How Does a Database Let Everyone Read and Write at Once?

How Does a Database Let Everyone Read and Write at Once?

Comments
19 min read
Online enabling checksums in PG ̶1̶9̶ 20 (was 19 beta but reverted)

Online enabling checksums in PG ̶1̶9̶ 20 (was 19 beta but reverted)

Comments
4 min read
The Postgres job-claim query that silently claims the same job twice

The Postgres job-claim query that silently claims the same job twice

Comments
9 min read
Your Next.js build should not need your database

Your Next.js build should not need your database

Comments
5 min read
Nineteen migrations, seventeen RLS statements, and not one policy in the whole history

Nineteen migrations, seventeen RLS statements, and not one policy in the whole history

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