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 19 beta's parallel autovacuum launches workers but leaves vacuum time unchanged

PostgreSQL 19 beta's parallel autovacuum launches workers but leaves vacuum time unchanged

12
Comments
7 min read
Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production

Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production

Comments
6 min read
Your Agent's RENAME COLUMN Breaks Every Old Pod. Expand-Contract in 4 Steps

Your Agent's RENAME COLUMN Breaks Every Old Pod. Expand-Contract in 4 Steps

Comments
9 min read
PostgreSQL EXPLAIN ANALYZE: What I Actually Look At in Query Plans

PostgreSQL EXPLAIN ANALYZE: What I Actually Look At in Query Plans

Comments 1
6 min read
Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

Comments
6 min read
The flaky test that was a tenant-isolation bug

The flaky test that was a tenant-isolation bug

Comments
3 min read
I took down my own search 🔥

I took down my own search 🔥

Comments
6 min read
I built an open-source RAG engine with org-level access control, because I couldn't find one

I built an open-source RAG engine with org-level access control, because I couldn't find one

Comments
2 min read
How I got PostgreSQL 18 running inside an Android app

How I got PostgreSQL 18 running inside an Android app

Comments
3 min read
Prisma Migrations Hanging on Supabase Connection Poolers: Root Cause & Fix

Prisma Migrations Hanging on Supabase Connection Poolers: Root Cause & Fix

Comments
8 min read
Test RLS Policies Safely with Neon Branching

Test RLS Policies Safely with Neon Branching

Comments
7 min read
Supabase RLS Security: Why AI-Generated Code Is Leaking Your Data (And How to Fix It)

Supabase RLS Security: Why AI-Generated Code Is Leaking Your Data (And How to Fix It)

Comments
7 min read
One Null in the Subquery and Your NOT IN Returned Nothing

One Null in the Subquery and Your NOT IN Returned Nothing

Comments
2 min read
# A Practical Guide to Advanced SQL: Window Functions, Joins, CTEs, and Subqueries Using a Hospital Database

# A Practical Guide to Advanced SQL: Window Functions, Joins, CTEs, and Subqueries Using a Hospital Database

Comments
21 min read
pg_vectorsearch vs pgvector HNSW: 42 Hours vs 49 Minutes. Here's the Catch

pg_vectorsearch vs pgvector HNSW: 42 Hours vs 49 Minutes. Here's the Catch

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