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 Real-Time Log Streaming with PostgreSQL LISTEN/NOTIFY

Building Real-Time Log Streaming with PostgreSQL LISTEN/NOTIFY

20
Comments 2
8 min read
Making Redis Optional: Why I’m pivoting to a 'Postgres-First' Architecture and why chose Valkey as alternative

Making Redis Optional: Why I’m pivoting to a 'Postgres-First' Architecture and why chose Valkey as alternative

19
Comments 4
5 min read
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

31
Comments
3 min read
🚀 Scaling to 93K RPM: Moving Quota Management from SQL to Redis

🚀 Scaling to 93K RPM: Moving Quota Management from SQL to Redis

Comments 1
3 min read
The hidden costs of additions to a system

The hidden costs of additions to a system

3
Comments 1
3 min read
Go Concurrency with Database Transactions

Go Concurrency with Database Transactions

2
Comments
3 min read
PgBench on MongoDB via Foreign Data Wrapper

PgBench on MongoDB via Foreign Data Wrapper

3
Comments
8 min read
Speeding Up PostgreSQL in Containers

Speeding Up PostgreSQL in Containers

2
Comments
5 min read
How SQL JOINs Finally Clicked for Me (and How They Can for You Too)

How SQL JOINs Finally Clicked for Me (and How They Can for You Too)

28
Comments
4 min read
SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

30
Comments
3 min read
Patching the Gaps: A Production-Ready Guide to Google’s ADK with TypeScript

Patching the Gaps: A Production-Ready Guide to Google’s ADK with TypeScript

Comments
10 min read
PostgreSQL on Arch Linux: From Zero to Running in 5 Minutes

PostgreSQL on Arch Linux: From Zero to Running in 5 Minutes

2
Comments 1
4 min read
ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

14
Comments
3 min read
TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)

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

8
Comments
12 min read
SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

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

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