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

Full-Text Search on a 2 GB PostgreSQL Instance

Comments
10 min read
PostgREST can't upsert against partial unique indexes

PostgREST can't upsert against partial unique indexes

2
Comments
5 min read
Cross-Row Validation Risk in PostgreSQL CHECK Constraints

Cross-Row Validation Risk in PostgreSQL CHECK Constraints

1
Comments
3 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
I turned the psql commands I keep forgetting into buttons

I turned the psql commands I keep forgetting into buttons

Comments
4 min read
Stop Running 5 Databases: PostgreSQL Does It All in 2026

Stop Running 5 Databases: PostgreSQL Does It All in 2026

Comments
9 min read
Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

2
Comments
7 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
Pooling contra una t3.micro, el día que se reventó...RDS Proxy es la salida?

Pooling contra una t3.micro, el día que se reventó...RDS Proxy es la salida?

Comments
9 min read
Vectorizing Real-Time Kafka Events

Vectorizing Real-Time Kafka Events

Comments
4 min read
🪄🐘 Postgres best practices I wish every app developer knew 🧑‍💻

🪄🐘 Postgres best practices I wish every app developer knew 🧑‍💻

1
Comments 1
7 min read
Deleting Millions of Rows in PostgreSQL Without Taking Down Production

Deleting Millions of Rows in PostgreSQL Without Taking Down Production

Comments
15 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
The Audit Trail Is a Data Structure, Not a Log Message

The Audit Trail Is a Data Structure, Not a Log Message

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