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.
The timestamp that broke a fresh evidence chain

The timestamp that broke a fresh evidence chain

Comments
6 min read
How a missing DEFAULT column locked my production DB for 20 minutes (and why your CI won't catch it)

How a missing DEFAULT column locked my production DB for 20 minutes (and why your CI won't catch it)

1
Comments
2 min read
Paginating hybrid search on Postgres, and why the obvious fix is worse

Paginating hybrid search on Postgres, and why the obvious fix is worse

Comments
4 min read
The TOAST Tax: How Unbounded JSONB Arrays Cost My Blockchain Indexer 5TB

The TOAST Tax: How Unbounded JSONB Arrays Cost My Blockchain Indexer 5TB

Comments
13 min read
How I Ran the Full Supabase Stack Locally in 100 MB of RAM (No Docker)

How I Ran the Full Supabase Stack Locally in 100 MB of RAM (No Docker)

Comments
4 min read
Supabase: permission denied for table (42501)

Supabase: permission denied for table (42501)

Comments
5 min read
Building an Agentic System in .NET, Part 3: Durable Memory with Postgres and pgvector

Building an Agentic System in .NET, Part 3: Durable Memory with Postgres and pgvector

Comments
6 min read
I Designed Multi-Tenancy Wrong. Then I Fixed It Before It Mattered.

I Designed Multi-Tenancy Wrong. Then I Fixed It Before It Mattered.

Comments
3 min read
Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph

Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph

Comments
3 min read
Read-Only Postgres MCP Servers Fail With 1 SQL Keyword

Read-Only Postgres MCP Servers Fail With 1 SQL Keyword

Comments
7 min read
Turn any SQL schema into an interactive ER diagram

Turn any SQL schema into an interactive ER diagram

Comments
2 min read
I broke my own database with an infinite loop, and here's what I learned about Row Level Security

I broke my own database with an infinite loop, and here's what I learned about Row Level Security

1
Comments
4 min read
Just Add More Database Connections Is a System Design Trap

Just Add More Database Connections Is a System Design Trap

6
Comments 4
3 min read
Go SQL Query Builder Without Dependencies: Relica, the ozzo-dbx Successor — What Broke on PostgreSQL and SQLite

Go SQL Query Builder Without Dependencies: Relica, the ozzo-dbx Successor — What Broke on PostgreSQL and SQLite

2
Comments 1
6 min read
A read-only SQL check for the 3 Supabase mistakes AI app builders leave behind

A read-only SQL check for the 3 Supabase mistakes AI app builders leave behind

1
Comments 1
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.