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.
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
Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency

Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency

Comments
3 min read
Postgres 16 18: Why You Can't Just Swap the Image

Postgres 16 18: Why You Can't Just Swap the Image

Comments
5 min read
Postgres Cron Worker Errors: Cohort-Aware Capture Across Background Job Retries

Postgres Cron Worker Errors: Cohort-Aware Capture Across Background Job Retries

Comments
6 min read
Multi-Tenant Database Isolation: RLS, Schema-per-Tenant, and the Migration Wall

Multi-Tenant Database Isolation: RLS, Schema-per-Tenant, and the Migration Wall

Comments
5 min read
How I Built a Self-Improving AI Reply System for E-commerce Sellers with pgvector

How I Built a Self-Improving AI Reply System for E-commerce Sellers with pgvector

Comments
3 min read
Kafka Just Learned to Be a Queue. Postgres Has Been One All Along.

Kafka Just Learned to Be a Queue. Postgres Has Been One All Along.

Comments
20 min read
n8n's Postgres Node Doesn't Send Parameters. My Dry-Run Did.

n8n's Postgres Node Doesn't Send Parameters. My Dry-Run Did.

Comments 1
6 min read
Neon vs Supabase vs PlanetScale vs AWS: what Postgres costs in 2026

Neon vs Supabase vs PlanetScale vs AWS: what Postgres costs in 2026

13
Comments 1
6 min read
Postgres Local Dev in 2026: The Numbers, and Lighter Alternatives to Docker Supabase

Postgres Local Dev in 2026: The Numbers, and Lighter Alternatives to Docker Supabase

Comments
4 min read
How to Sync Billing Data to Supabase (Stripe, QuickBooks, Xero & Paddle)

How to Sync Billing Data to Supabase (Stripe, QuickBooks, Xero & Paddle)

Comments
10 min read
PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

Comments
9 min read
Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

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