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.
PostgreSQL jsonb with EF Core 10: Mapping, Indexing and Querying Document Columns

PostgreSQL jsonb with EF Core 10: Mapping, Indexing and Querying Document Columns

Comments
6 min read
What I learned building a short-video pipeline that posts on a schedule

What I learned building a short-video pipeline that posts on a schedule

Comments
2 min read
The Bug Behind Double Bookings

The Bug Behind Double Bookings

Comments
8 min read
Why We Dropped the ORM: Building a Bulletproof, High-Concurrency Financial Ledger with Raw AsyncPG and FastAPI

Why We Dropped the ORM: Building a Bulletproof, High-Concurrency Financial Ledger with Raw AsyncPG and FastAPI

Comments
8 min read
Your Postgres Get-or-Create Has a Race. Postgres 19's ON CONFLICT DO SELECT Closes It

Your Postgres Get-or-Create Has a Race. Postgres 19's ON CONFLICT DO SELECT Closes It

5
Comments
8 min read
I audited my own Supabase project and found it wide open — with RLS on

I audited my own Supabase project and found it wide open — with RLS on

Comments 1
3 min read
Supabase's Oct 30 grants change: what it closes, what it leaves open, and the two kinds of 42501

Supabase's Oct 30 grants change: what it closes, what it leaves open, and the two kinds of 42501

Comments
10 min read
One function defines not-found for our scanner, our capture gate and our reward check, because three copies of it drifted

One function defines not-found for our scanner, our capture gate and our reward check, because three copies of it drifted

Comments
7 min read
How I Used PostgreSQL Row-Level Security to Isolate 15+ SaaS Tenants

How I Used PostgreSQL Row-Level Security to Isolate 15+ SaaS Tenants

1
Comments 2
5 min read
Supabase's 30 Oct 2026 change: 'permission denied for table' and the one-line fix that leaks your data

Supabase's 30 Oct 2026 change: 'permission denied for table' and the one-line fix that leaks your data

Comments
3 min read
Your enrichment toggle changed the price baseline

Your enrichment toggle changed the price baseline

Comments
7 min read
Our search endpoint returns three fields, and its WHERE clause is copied out of an index definition on purpose

Our search endpoint returns three fields, and its WHERE clause is copied out of an index definition on purpose

Comments 2
8 min read
Scaling Multilingual Search: Our FastAPI + PostgreSQL Architecture for Translating Books

Scaling Multilingual Search: Our FastAPI + PostgreSQL Architecture for Translating Books

Comments
6 min read
UUIDv7 Is a Great Database Key and a Bad Clock: 4 Tests Before You Migrate

UUIDv7 Is a Great Database Key and a Bad Clock: 4 Tests Before You Migrate

Comments
5 min read
How to Connect Claude Desktop & Cursor to PostgreSQL Safely (Read-Only AST Validation & PII Masking with MCP)

How to Connect Claude Desktop & Cursor to PostgreSQL Safely (Read-Only AST Validation & PII Masking with MCP)

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