Blog

Engineering 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

Read →
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

Read →
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

Read →
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

Read →
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

Read →
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

Read →