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.
MySQL vs PostgreSQL in 2026 — 7 key differences you should know before choosing

MySQL vs PostgreSQL in 2026 — 7 key differences you should know before choosing

Comments
7 min read
How We Told a Stranger's Node Where Its Cache Should Be

How We Told a Stranger's Node Where Its Cache Should Be

3
Comments
6 min read
PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

3
Comments
15 min read
Digging into UUID, ULID, and implementing my own

Digging into UUID, ULID, and implementing my own

Comments
5 min read
pg_ducklake: Columnar Storage for PostgreSQL

pg_ducklake: Columnar Storage for PostgreSQL

2
Comments
2 min read
Database Connection Pooling with Claude Code: Prisma Singleton and PgBouncer

Database Connection Pooling with Claude Code: Prisma Singleton and PgBouncer

2
Comments
4 min read
Claude CodeでSoft Deleteパターンを設計する:論理削除・一括復元・削除後TTL

Claude CodeでSoft Deleteパターンを設計する:論理削除・一括復元・削除後TTL

2
Comments
2 min read
How to Turn Slow Queries into Actionable Reliability Metrics with OpenTelemetry

How to Turn Slow Queries into Actionable Reliability Metrics with OpenTelemetry

Comments
11 min read
GeoSQL-Eval: Finally, a PostGIS Benchmark That Doesn’t Make Me Scream

GeoSQL-Eval: Finally, a PostGIS Benchmark That Doesn’t Make Me Scream

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

CP Systems Explained: The Hidden Cost of Strong Consistency

Comments
16 min read
How to Build a REST API in Zig (Using Spider Web Framework)

How to Build a REST API in Zig (Using Spider Web Framework)

1
Comments
6 min read
SaaS Multi-Tenant en Go: Guia Practica de Row-Level Security en PostgreSQL

SaaS Multi-Tenant en Go: Guia Practica de Row-Level Security en PostgreSQL

3
Comments 1
10 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
How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

3
Comments
4 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.