Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
PostgreSQL 18, released in September 2025, brings transformative improvements that database administrators and developers need to understand. With the next major release (PostgreSQL 19) already on the roadmap for September 2026, now is the perfect time to explore what PostgreSQL 18 offers and why it matters for your production systems. Virtual Generated Columns: A Storage […]
Metropolitan Statistical Areas (MSAs) are critical geographic designations used by the U.S. Census Bureau to define urban regions for economic and demographic analysis. If you’re working with location-based data in PostgreSQL, PostGIS provides powerful tools for storing, querying, and analyzing MSA boundaries and associated data. In this guide, I’ll show you how to effectively work […]
If you’re a MySQL developer looking to expand your database skills, PostgreSQL is a natural next step. While both are powerful relational database management systems (RDBMS), PostgreSQL offers advanced features that can take your database expertise to the next level. In this guide, I’ll help you leverage your MySQL knowledge to quickly get up to […]
When you’re deep in the trenches of database work—optimizing queries, debugging replication lag, or untangling JSON transforms—the quality of your tools matters. PostgreSQL has always been powerful, but the community has been laser-focused on something equally important: making that power accessible. Developer ergonomics—how smoothly you can understand, debug, and deploy database logic—is front and center […]
PostgreSQL heads into 2026 with more momentum than it has had in years, driven by PostgreSQL 18’s async I/O, a rapidly maturing AI/vector story, and continued pressure to make Postgres cheaper to run in the cloud. For teams already standardized on Postgres, the next 12–18 months look less like “incremental tuning” and more like a […]
