Welcome to AndrusOne
Sharing tools, insights, and resilient engineering ideas.
Untangling Oracle Views with Python: A Dependency Crawler for Modern Migrations
The Problem We Had to Solve I was leading a migration off a legacy Oracle reporting system—one that had quietly grown for over two decades. The infrastructure was beyond support: the hardware, the OS, and the reporting tools were all aging out. But the real risk wasn’t just technical—it was operational. This system was still powering production decisions. We couldn’t afford to break it. We chose Snowflake as the modern target. But before we could move anything, we had to understand what we were moving. That meant dissecting hundreds of Oracle views—some built years ago by engineers long gone, many undocumented, and most more complex than expected. ...