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.
Building a Webhook Queue on PostgreSQL: Why We Ditched Redis for Shopify Webhook Processing

Building a Webhook Queue on PostgreSQL: Why We Ditched Redis for Shopify Webhook Processing

Comments
12 min read
Just use Postgres, until it actually hurts

Just use Postgres, until it actually hurts

Comments
6 min read
RAG is a search problem wearing a costume

RAG is a search problem wearing a costume

Comments
8 min read
UUIDv7 and the end of the random primary key

UUIDv7 and the end of the random primary key

Comments
9 min read
The outbox pattern without a relay

The outbox pattern without a relay

Comments
10 min read
Your Backups Don't Exist Until You've Restored One: A Monthly Drill for a Solo SaaS

Your Backups Don't Exist Until You've Restored One: A Monthly Drill for a Solo SaaS

Comments
5 min read
Your data should outlive my company

Your data should outlive my company

Comments
7 min read
Amazon Aurora's analytics is DuckDB: a reproducible side-by-side with pg_duckdb

Amazon Aurora's analytics is DuckDB: a reproducible side-by-side with pg_duckdb

Comments
5 min read
Migration says applied, but production says column does not exist

Migration says applied, but production says column does not exist

Comments
8 min read
Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Comments
8 min read
Building an Agentic System in .NET, Part 5: Designing an Agent Bus in ASP.NET Core

Building an Agentic System in .NET, Part 5: Designing an Agent Bus in ASP.NET Core

Comments
6 min read
How long does a Patroni failover take? We measured it

How long does a Patroni failover take? We measured it

Comments
4 min read
Your Database Will Leak Someday: Field-Level Encryption and Blind Indexes for PII with Python and PostgreSQL

Your Database Will Leak Someday: Field-Level Encryption and Blind Indexes for PII with Python and PostgreSQL

Comments
7 min read
Why PostgreSQL MVCC Scales Better Than Lock-Based Reads for Read-Heavy Workloads

Why PostgreSQL MVCC Scales Better Than Lock-Based Reads for Read-Heavy Workloads

Comments
7 min read
My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.