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.
TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)

TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)

7
Comments
12 min read
CP Systems Explained: The Hidden Cost of Strong Consistency

CP Systems Explained: The Hidden Cost of Strong Consistency

Comments
16 min read
From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis — Part 2: The Data Layer

From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis — Part 2: The Data Layer

Comments
21 min read
PostgreSQL automated backups — How to set up automated PostgreSQL backup schedules

PostgreSQL automated backups — How to set up automated PostgreSQL backup schedules

Comments
7 min read
Publishing Pipeline - LinkedIn Support

Publishing Pipeline - LinkedIn Support

Comments
4 min read
A look at SurrealQL and how it differs from PostgreSQL

A look at SurrealQL and how it differs from PostgreSQL

18
Comments
13 min read
Module 2 Summary - Workflow Orchestration with Kestra Part 2

Module 2 Summary - Workflow Orchestration with Kestra Part 2

Comments
1 min read
NeuronDB Vector vs pgvector: Technical Comparison

NeuronDB Vector vs pgvector: Technical Comparison

Comments
11 min read
8 RAG Patterns You Should Stop Ignoring

8 RAG Patterns You Should Stop Ignoring

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
SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

7
Comments
3 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
My FOSDEM 2026 watchlist

My FOSDEM 2026 watchlist

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