Blog
Categories
Projects
Archive of posts with
category 'PostgreSQL'
Scaling Rails with PostgreSQL Read Replicas: Part 3 - Production Excellence
Master production deployment strategies, monitoring, performance optimization, and failure handling for Rails applications using PostgreSQL read replicas.
Scaling Rails with PostgreSQL Read Replicas: Part 2 - Advanced Patterns and Gotchas
Deep dive into handling replication lag, implementing automatic connection switching, and solving real-world challenges with read replicas in Rails applications.
Scaling Rails with PostgreSQL Read Replicas: Part 1 - Understanding the Basics
Learn when and why to use read replicas in Rails applications, understand the architecture, and implement basic read/write splitting with real-world examples.
PostgreSQL 17's MERGE with RETURNING: The Game-Changer Rails Developers Have Been Waiting For
PostgreSQL 17 introduces RETURNING support to the MERGE statement, solving a long-standing limitation that forced developers to choose between atomic upserts and knowing what actually happened to their data.