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.
Pourquoi tes mutations Supabase mentent sur leurs erreurs

Pourquoi tes mutations Supabase mentent sur leurs erreurs

Comments
3 min read
Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

Comments
5 min read
NGB Reports: Canonical + Composable Reporting on .NET and PostgreSQL

NGB Reports: Canonical + Composable Reporting on .NET and PostgreSQL

Comments
3 min read
Full-Text Search on a 2 GB PostgreSQL Instance

Full-Text Search on a 2 GB PostgreSQL Instance

Comments
10 min read
Why your Supabase mutations lie about their errors

Why your Supabase mutations lie about their errors

Comments 1
2 min read
I keep writing the same Pydantic-asyncpg wrapper. So I published it.

I keep writing the same Pydantic-asyncpg wrapper. So I published it.

Comments
6 min read
Multi-Tenancy, Layer by Layer: From Row-Level Security to Whole-Cluster Isolation

Multi-Tenancy, Layer by Layer: From Row-Level Security to Whole-Cluster Isolation

1
Comments 1
12 min read
Designing Conversational Infrastructure for AI Agents: Context Forking, Rate Limiting, and Identity Rotation

Designing Conversational Infrastructure for AI Agents: Context Forking, Rate Limiting, and Identity Rotation

Comments
19 min read
I found 3 silent revenue-leaking bugs in my SaaS in 45 minutes (and the meta-lesson)

I found 3 silent revenue-leaking bugs in my SaaS in 45 minutes (and the meta-lesson)

Comments
4 min read
Time Series Systems: Architecture, Storage Models, and Engineering Principles

Time Series Systems: Architecture, Storage Models, and Engineering Principles

1
Comments
27 min read
Vectorizing Real-Time Kafka Events

Vectorizing Real-Time Kafka Events

Comments
4 min read
Before you connect AI to PostgreSQL through MCP, run this checklist

Before you connect AI to PostgreSQL through MCP, run this checklist

Comments
2 min read
Multi-tenant files em Postgres + S3 com RLS FORCE: como o GarraIA fechou 9 slices REST sem deixar brecha de tenant isolation

Multi-tenant files em Postgres + S3 com RLS FORCE: como o GarraIA fechou 9 slices REST sem deixar brecha de tenant isolation

Comments
5 min read
Row-Level Multitenancy in Rails: Building a Bulletproof Tenant Isolation Layer from Scratch

Row-Level Multitenancy in Rails: Building a Bulletproof Tenant Isolation Layer from Scratch

Comments
10 min read
I added a grid_size column. Two months later I dropped it. What I learned about derived state in Postgres.

I added a grid_size column. Two months later I dropped it. What I learned about derived state in Postgres.

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