BlogEngineering insights
Deep dives on database migrations, Oracle to PostgreSQL, CDC, and data infrastructure.
Guide18 min read
Oracle to PostgreSQL Migration: A Complete Step-by-Step Guide
Everything you need to migrate from Oracle to PostgreSQL — schema conversion, PL/SQL transpilation, data migration, CDC cutover, and post-migration validation.
Rakesh Mamidala
Founder & Lead Engineer
Engineering14 min read
PL/SQL to PL/pgSQL: What Changes and What Stays the Same
A hands-on guide covering every PL/SQL construct that needs manual or automatic conversion to PL/pgSQL — packages, sequences, cursors, exceptions, and more.
Rakesh Mamidala
Founder & Lead Engineer
Engineering12 min read
Zero-Downtime Database Migrations Using CDC
How Change Data Capture (CDC) enables near-zero-downtime cutover: run Oracle and PostgreSQL in sync for weeks, then flip the switch with seconds of downtime.
Rakesh Mamidala
Founder & Lead Engineer
Best Practices10 min read
The 40-Point Oracle Migration Checklist (Before You Start)
Skip the painful surprises. This pre-migration checklist covers supplemental logging, XMLTYPE, partitioned tables, sequences, circular FKs, and 34 more gotchas.
Rakesh Mamidala
Founder & Lead Engineer
Architecture8 min read
ETL vs ELT in 2026: Which Should You Choose?
The rise of cloud data warehouses changed the ETL vs ELT debate. We break down when each approach makes sense and how to pick the right pattern for your stack.
Rakesh Mamidala
Founder & Lead Engineer
Best Practices10 min read
Why Data Validation Is the Most Underrated Migration Step
Most migration failures aren't schema problems — they're data quality problems discovered too late. Here's how to build a validation layer that catches issues before production.
Rakesh Mamidala
Founder & Lead Engineer