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.
Stop Benchmarking Embedding Models. 90% of Your Search Quality Lives Upstream.

Stop Benchmarking Embedding Models. 90% of Your Search Quality Lives Upstream.

Comments
4 min read
The race condition a stress test found in my double-entry ledger — and how I fixed it

The race condition a stress test found in my double-entry ledger — and how I fixed it

2
Comments 1
7 min read
PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes

PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes

Comments
4 min read
Scaling Databases: PostgreSQL Table Partitioning in Laravel 🐘

Scaling Databases: PostgreSQL Table Partitioning in Laravel 🐘

Comments
3 min read
How I indexed 18,141 polynomial fan curves in Postgres and matched a duty point in 4 ms

How I indexed 18,141 polynomial fan curves in Postgres and matched a duty point in 4 ms

Comments
6 min read
Generating Realistic Seed Data That Respects Foreign Keys, in 20 Seconds

Generating Realistic Seed Data That Respects Foreign Keys, in 20 Seconds

1
Comments 1
6 min read
5 Supabase patterns I learned building an open-source WhatsApp platform

5 Supabase patterns I learned building an open-source WhatsApp platform

1
Comments
7 min read
Logical Replication for Migrations: Zero-Downtime Postgres Upgrades in 2026

Logical Replication for Migrations: Zero-Downtime Postgres Upgrades in 2026

Comments
9 min read
JSONB vs Relational in 2026: 5 Query Shapes, 5 Verdicts

JSONB vs Relational in 2026: 5 Query Shapes, 5 Verdicts

Comments
8 min read
SQLAlchemy Bulk Operations for AI Feature Analytics: Writing 10K Events/Second Without Database Meltdown

SQLAlchemy Bulk Operations for AI Feature Analytics: Writing 10K Events/Second Without Database Meltdown

Comments
4 min read
The Gamification Data Model: How to Structure Streaks, Achievements, Points & Leaderboards

The Gamification Data Model: How to Structure Streaks, Achievements, Points & Leaderboards

Comments
11 min read
Postgres VACUUM Tuning: 4 Settings That Decide Whether Autovacuum Keeps Up

Postgres VACUUM Tuning: 4 Settings That Decide Whether Autovacuum Keeps Up

Comments
8 min read
Read Replicas Lie About Consistency. 4 Sync Modes Behind the Lie.

Read Replicas Lie About Consistency. 4 Sync Modes Behind the Lie.

Comments
8 min read
6 Supabase RLS Patterns for Solo SaaS — auth.uid() and Beyond

6 Supabase RLS Patterns for Solo SaaS — auth.uid() and Beyond

Comments
3 min read
Migrating from Neon to Supabase (Postgres + Drizzle, in production)

Migrating from Neon to Supabase (Postgres + Drizzle, in production)

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