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.
TableCraft: From 5 Hours to 5 Minutes for Production-Ready Table APIs

TableCraft: From 5 Hours to 5 Minutes for Production-Ready Table APIs

1
Comments
4 min read
Reducing row count estimation errors in PostgreSQL

Reducing row count estimation errors in PostgreSQL

1
Comments
5 min read
Open Source and the agentic wave

Open Source and the agentic wave

1
Comments
4 min read
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
PostgreSQL Sharding: Scaling Relational Databases

PostgreSQL Sharding: Scaling Relational Databases

Comments
3 min read
PostgreSQL для веб-разработчика: миграция с MySQL, JSON, оптимизация

PostgreSQL для веб-разработчика: миграция с MySQL, JSON, оптимизация

Comments
4 min read
10 PostgreSQL performance tuning tips that actually work in production

10 PostgreSQL performance tuning tips that actually work in production

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