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.
Retrieval Augmented Generation: Architectures, Patterns, and Production Reality

Retrieval Augmented Generation: Architectures, Patterns, and Production Reality

Comments
15 min read
The hidden costs of additions to a system

The hidden costs of additions to a system

3
Comments 1
3 min read
How I built horizontally scalable chat server in Go

How I built horizontally scalable chat server in Go

2
Comments
2 min read
Pakistani Freelancers: How to Calculate & File Taxes in 2026 (FBR Rules, NTN, Withholding Tax Guide)

Pakistani Freelancers: How to Calculate & File Taxes in 2026 (FBR Rules, NTN, Withholding Tax Guide)

Comments 1
3 min read
Databases - Postgresql - Pilot

Databases - Postgresql - Pilot

Comments
5 min read
How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

2
Comments 1
11 min read
Why Soft Delete Can Backfire on Data Consistency

Why Soft Delete Can Backfire on Data Consistency

2
Comments 2
5 min read
I Built a Free PostgreSQL Internals Course — Here's What I Learned

I Built a Free PostgreSQL Internals Course — Here's What I Learned

Comments
3 min read
Solving the N+1 Query Problem: A Developer's Guide to Database Performance

Solving the N+1 Query Problem: A Developer's Guide to Database Performance

1
Comments
7 min read
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
PostgreSQL backup retention policies — How to set up backup retention policies

PostgreSQL backup retention policies — How to set up backup retention policies

Comments
7 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
loading...