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.
Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Comments
4 min read
Modeling identity and access hierarchy in Postgres with ltree

Modeling identity and access hierarchy in Postgres with ltree

Comments
7 min read
Why to choose PostgreSQL over MongoDB in 2026

Why to choose PostgreSQL over MongoDB in 2026

1
Comments
3 min read
I Built a Postgres Proxy That Masks PII for AI Agents

I Built a Postgres Proxy That Masks PII for AI Agents

Comments
1 min read
PostgreSQL backup compression — Techniques for reducing PostgreSQL backup size

PostgreSQL backup compression — Techniques for reducing PostgreSQL backup size

Comments
7 min read
Why PostgreSQL RLS Is Hard in Spring Boot and How I Simplified It

Why PostgreSQL RLS Is Hard in Spring Boot and How I Simplified It

Comments
2 min read
Data Engineering ZoomCamp Module 1 Notes Part 2

Data Engineering ZoomCamp Module 1 Notes Part 2

Comments
4 min read
Many people confuse rank() with dense_rank().

Many people confuse rank() with dense_rank().

Comments
1 min read
When A Landing Page Almost Took Down Production

When A Landing Page Almost Took Down Production

Comments
4 min read
MySQL, PostgreSQL e SQLite: quando usar cada um (sem dogma)

MySQL, PostgreSQL e SQLite: quando usar cada um (sem dogma)

Comments
2 min read
Do You Really Need Kafka? A Practical Alternative with Postgres

Do You Really Need Kafka? A Practical Alternative with Postgres

Comments
6 min read
Spring Boot 4 入門教學 - Part 6 (JDBC 資料庫連接)

Spring Boot 4 入門教學 - Part 6 (JDBC 資料庫連接)

Comments
6 min read
Spring Boot 4 入門教學 - Part 8 (常見問題與排錯)

Spring Boot 4 入門教學 - Part 8 (常見問題與排錯)

Comments
1 min read
Simplifying PostgreSQL RLS in JPA with JPA Postgres RLS

Simplifying PostgreSQL RLS in JPA with JPA Postgres RLS

Comments
1 min read
OpenAI Is Running PostgreSQL at Millions of QPS (Here’s How It Didn’t Explode)

OpenAI Is Running PostgreSQL at Millions of QPS (Here’s How It Didn’t Explode)

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