Schema-agnostic Staged Changesets with stage.substituteSchemasMake SQLcl staged files schema-agnostic by substituting schema names with Liquibase variables for deploy-anywhere artifacts.6 min read·danmcghan.hashnode.dev1Apr 3
The Problems with Liquibase Rollback — and What to Do InsteadLiquibase rollback may seem reliable, but it often fails in real-world deployments—especially when data is involved. Learn why and explore safer alternative4 min read·danmcghan.hashnode.devMay 31, 2025
Feature Branches vs. End-of-Release Branches: Which Approach Works Best?The Question Someone recently asked me: What's the possibility/risk of just using one dev branch and multiple developers working in there, then just merge to main when a release/artifact is generated? Good Practice? Bad Practice? Thoughts? Risky Bu...3 min read·danmcghan.hashnode.devFeb 17, 2025
Upgrading SQLcl When Using SQLcl ProjectsKeeping your development tools up to date is essential for smooth collaboration and to take advantage of the latest features and fixes. When working with SQLcl Projects, upgrading SQLcl requires a structured approach to minimize disruption and ensure...3 min read·danmcghan.hashnode.dev1TFeb 14, 2025
Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient DeploymentsChoosing the right deployment approach is essential when deploying changes to Oracle Database and APEX applications. One key decision involves selecting between an admin (privileged) user installation and an app (object owner) user installation. Each...5 min read·danmcghan.hashnode.dev1SJan 4, 2025