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.
Aborting a Fetch Doesn't Stop Your Node.js Server. Here's What Does.

Surprising pitfalls with Postgres and Node signals

Aborting a Fetch Doesn't Stop Your Node.js Server. Here's What Does.

22
Comments 11
8 min read
My First GitLab Open Source Contribution: From Issue to Merge Request

My First GitLab Open Source Contribution: From Issue to Merge Request

Comments
5 min read
I wanted Jepsen's Elle in CI without a JVM, so I wrote adya

I wanted Jepsen's Elle in CI without a JVM, so I wrote adya

Comments 2
7 min read
Zero-Downtime Database Migrations: Shadow Tables, Dual-Writing, and Schema Expansion

Zero-Downtime Database Migrations: Shadow Tables, Dual-Writing, and Schema Expansion

Comments
4 min read
Running Postgres-based event-driven systems in production — LISTEN/NOTIFY limits, outbox lag, and knowing when you've outgrown it

Running Postgres-based event-driven systems in production — LISTEN/NOTIFY limits, outbox lag, and knowing when you've outgrown it

Comments
8 min read
Moving a Live SaaS from Firebase to Supabase: 283 Functions, 139 Tables, Zero Password Resets

Moving a Live SaaS from Firebase to Supabase: 283 Functions, 139 Tables, Zero Password Resets

Comments
5 min read
Optimizing High-Volume Financial Ledger Queries in PostgreSQL

Optimizing High-Volume Financial Ledger Queries in PostgreSQL

Comments
2 min read
How a Zero-Downtime Table Swap Silently Dropped Orders From Postgres Logical Replication for 91 Hours

How a Zero-Downtime Table Swap Silently Dropped Orders From Postgres Logical Replication for 91 Hours

Comments
6 min read
Disaster Recovery: Restoring PostgreSQL on Amazon RDS

Disaster Recovery: Restoring PostgreSQL on Amazon RDS

Comments
3 min read
Database Schema Diagram Tool: 5 Ways to Visualize PostgreSQL

Database Schema Diagram Tool: 5 Ways to Visualize PostgreSQL

Comments
3 min read
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
RAG is a search problem wearing a costume

RAG is a search problem wearing a costume

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

Just use Postgres, until it actually hurts

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

UUIDv7 and the end of the random primary key

Comments
9 min read
How to Generate 500 Realistic Fake Users with PostgreSQL & MySQL Seed Scripts in Seconds

How to Generate 500 Realistic Fake Users with PostgreSQL & MySQL Seed Scripts in Seconds

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