A 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...
Why Developers Struggle Between ORMs and Raw SQL As developers, we often find ourselves torn between using Object-Relational Mappers (ORMs) and writing raw SQL queries. Each approach has its advantages and trade-offs. sqlc, however, offers a unique s...
When working with applications based on Oracle Database (like APEX), ensuring the quality of your PL/SQL code is essential. But how can you quickly check for issues? The answer is the SQLcl CODESCAN. A FREE tool that scans your database objects for c...
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...
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...
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...
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...
If you’re reading this, you were just as excited as I was to see SQLcl release 24.3 and its Database Application CI/CD tooling from Oracle. After the announcements, the posts on getting started by Dan McGhan [An Overview of the Oracle SQLcl Projects ...
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...
