danmcghan.hashnode.devThe Problems with Liquibase Rollback — and What to Do InsteadA common question we get: why doesn’t SQLcl Projects support Liquibase rollback? At first glance, Liquibase’s rollback feature seems like a great safety net. Not only can it evolve your schema forward, it promises to take you backward if something go...May 31, 2025·4 min read
danmcghan.hashnode.devFeature 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...Feb 17, 2025·3 min read
danmcghan.hashnode.devUpgrading 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...Feb 14, 2025·3 min read
danmcghan.hashnode.devAdmin 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...Jan 4, 2025·5 min read
danmcghan.hashnode.devAn Overview of the Oracle SQLcl Projects Development ProcessSQLcl Projects is a new feature of SQLcl that aims to standardize and streamline the development lifecycle of Oracle Database and APEX applications. This post provides a high level overview of what the development process looks like. Here are a coupl...Dec 20, 2024·8 min read