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.
Building a Healthcare AI Assistant with RAG, .NET, PostgreSQL, and pgvector

Building a Healthcare AI Assistant with RAG, .NET, PostgreSQL, and pgvector

Comments
3 min read
1.3.2 How RLS Rewrites Queries (Mechanism)

1.3.2 How RLS Rewrites Queries (Mechanism)

Comments 1
11 min read
DuckDB, Postgres, and Parquet: when one SQL query becomes a workflow

DuckDB, Postgres, and Parquet: when one SQL query becomes a workflow

Comments
4 min read
Zero-Downtime Database Migrations in Production (2026)

Zero-Downtime Database Migrations in Production (2026)

1
Comments 2
2 min read
What is PostgreSQL? The Database That Powers Modern Web Applications

What is PostgreSQL? The Database That Powers Modern Web Applications

Comments
2 min read
Pourquoi tes mutations Supabase mentent sur leurs erreurs

Pourquoi tes mutations Supabase mentent sur leurs erreurs

Comments
3 min read
A Go outbox library that runs inside your own DB transaction

A Go outbox library that runs inside your own DB transaction

1
Comments
7 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
Full-Text Search on a 2 GB PostgreSQL Instance

Full-Text Search on a 2 GB PostgreSQL Instance

Comments
10 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
I built a local Postgres triage co-pilot because HIPAA says I can't paste plans into ChatGPT or Claude

Gemma 4 Challenge: Build With Gemma 4 Submission

I built a local Postgres triage co-pilot because HIPAA says I can't paste plans into ChatGPT or Claude

1
Comments 2
6 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
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.