Prereqs Latest SQLcl Existing SQLcl Project with an APEX app Note On average, I prefer to keep the same Schema name, APEX Application ID, Workspace Name, and Workspace ID across environments and have separate databases. I understand that this isn...
Oracle APEX has always been a tool for both professional development teams and citizen developers. The key advantage of citizen developers is that they have a deep understanding of their department's processes and the specific needs of their colleagu...
For the past two years, I’ve been using Liquibase (open-source version) to manage database objects in my Oracle APEX projects. Since I work exclusively with the Oracle database, I never had to explore Liquibase’s support for other databases. But in O...
This is a Quick Reference / Cheat Sheet take your pick. SQLcl Projects is a feature in Oracle's SQLcl tool that helps manage and automate database changes and deployments for Oracle Database and APEX applications. It provides a structured approach to...
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...
Keeping 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...
Choosing 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...
Every Database/APEX developer faces challenges when implementing a CI/CD pipeline for their projects due to the stateful nature of databases. The state, which is represented by the data, is crucial and cannot be lost. This presents unique considerati...
