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
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
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
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
Cutting a 26-Minute Supabase Batch Job to Near Zero — The prev_fetched Flag Pattern

Cutting a 26-Minute Supabase Batch Job to Near Zero — The prev_fetched Flag Pattern

Comments
2 min read
PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

Comments
3 min read
Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation

Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation

Comments
2 min read
Testing FastAPI + SQLAlchemy with Real PostgreSQL Fixtures: No More Mocking Misery

Testing FastAPI + SQLAlchemy with Real PostgreSQL Fixtures: No More Mocking Misery

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