Archives

A practical look at Aurora PostgreSQL Zero-ETL into Redshift — how NOT NULL really behaves, why your PostgreSQL indexes don't translate, and how retries stay idempotent without enforced uniqueness.

A deep dive into why PostgreSQL major version upgrades take longer than expected — what actually happens under the hood, why parallelism won't save you, and how to diagnose the bottleneck. Applies to Aurora PostgreSQL, RDS PostgreSQL, and self-hosted.

A practical, cloud-agnostic look at adding columns to large tables without downtime — what MySQL 8+ and Postgres 14+ actually let you do, the expand-contract pattern that beats native DDL alone, the OSS tools, and the managed-service caveats.

A practical guide to understanding, diagnosing, and resolving MySQL Data Dictionary inconsistencies on RDS MySQL and Aurora MySQL — before they become emergencies.

A short introduction to who I am and what this blog is going to be about — a mix of tech, travel, cooking, cricket, DIY, and gardening.