Dan McGhan's Blog

Dan McGhan's Blog

Apr 3, 20266 min read

Schema-agnostic Staged Changesets with stage.substituteSchemas

TL;DR SQLcl Projects 26.1.0 supports a stage.substituteSchemas flag that makes staged artifacts schema-agnostic by replacing schema references with Liquibase property substitution (e.g., hr → ${hr}).

The Problems with Liquibase Rollback — and What to Do Instead
May 31, 20254 min read
Feature Branches vs. End-of-Release Branches: Which Approach Works Best?
Feb 17, 20253 min read
Upgrading SQLcl When Using SQLcl Projects
Feb 14, 20253 min read
Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments
Jan 4, 20255 min read

An Overview of the Oracle SQLcl Projects Development Process
SQLcl 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, 20248 min read

Dan McGhan's Blog