PostgreSQL is an excellent database. I want to start there because database discussions have a tendency to become unnecessarily tribal. PostgreSQL has earned its position as one of the most widely adopted relational database technologies. It has a permissive open-source…
Data lake modernization is rarely as simple as copying files from one location to another. Before data can be migrated, teams need to discover it, understand its structure, profile its quality, transform it into useful formats, and validate that the…
Document databases are often selected because they make it easy to store and retrieve flexible JSON documents. That flexibility is valuable but storing documents is only one part of operating a production data platform. As a collection grows, teams also…
Modernization initiatives often begin with a simple objective: migrate existing workloads to a new platform with minimal disruption. While successful migration is an important milestone, it is rarely where organizations realize the greatest value. The real opportunity begins after migration,…
The Modernization Journey Continues In the first article of this series, The Migration, Optimization, and Innovation Journey I introduced a simple idea: Modernization is not a single event. It is a progression. Organizations first Migrate workloads to a modern platform.…
When organizations evaluate database modernization initiatives, discussions often focus on technical feasibility, migration complexity, and long-term operational savings. Yet one of the largest and most frequently underestimated factors in a migration business case is the cost of operating both the…
One of the most common questions organizations ask when evaluating modernization from MongoDB to Oracle Database API for MongoDB is: “What does the actual migration process look like?” Over the past several years working with database modernization initiatives, I’ve found…
Modernization programs often celebrate too early. The migration finishes.Applications reconnect successfully.Users log in.Dashboards turn green.The project is declared complete. But in reality, the organization has usually only completed the first phase of transformation. Migration establishes a new foundation. Optimization is…
Enterprise database modernization is no longer just about moving data from one platform to another. Organizations are increasingly evaluating how to consolidate operational complexity, reduce database sprawl, improve governance, and modernize application architectures without disrupting developer workflows. One area seeing…
This is Part 3 of a series on madsql.Part 1 covered split-statements. Part 2 covered infer-schema. This post covers convert — the main migration command. By the time you reach convert in a migration workflow, you’ve already done two things:…