Tag feed

#sqlcl-projects

14 posts3 followers

Explore Hashnode

Alternatives

Trending tags this week

BTBoyd Timmermanbtimmerman.hashnode.devMay 4 · 6 min read

Managing Soft Objects in Oracle SQLcl Projects: Understanding stage.softObjectIsolation

When working with Oracle SQLcl's project-based deployment framework, one of the critical configuration decisions you'll face is how to manage "soft objects" — database objects like packages, views, fu

0

DMDan McGhandanmcghan.hashnode.devApr 3 · 6 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}).

0

JLJuan López Garcíajuanl.hashnode.devAug 14, 2025 · 21 min read

SQLcl Projects: referencia práctica para CI/CD en Oracle APEX

Oracle APEX nos permite desarrollar aplicaciones de forma ágil, pero cuando el proyecto crece, o trabajamos en equipo, el control de versiones, la trazabilidad y la automatización del despliegue dejan de ser opcionales. En este contexto, implementar ...

0

NFNeil Fernandezblog.neilfernandez.comJun 4, 2025 · 3 min read

SQLcl Projects - Dynamic Property File Location Definition

Building on the previous topic of leveraging Liquibase properties to modify APEX installations, we will delve into a companion technique. This one enables users to define as many property files as they wish in the artifact to set it when deploying. T...

0

DMDan McGhandanmcghan.hashnode.devMay 31, 2025 · 4 min read

The Problems with Liquibase Rollback — and What to Do Instead

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...

0

RGRafal Grzegorczykrafal.hashnode.devMay 21, 2025 · 3 min read

Instant Maintenance Mode for Oracle APEX Apps

I needed to set maintenance mode for my 15 APEX applications in the production environment. Typically, the process is simple - just set Application Definition - Status to “Unavailable”: And your users will be logged out and will see this ugly, defau...

1

J

NFNeil Fernandezblog.neilfernandez.comMar 7, 2025 · 3 min read

SQLcl Projects - Using Liquibase properties to modify your APEX installation

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...

0

T

PRPatrizia Regenbergregenberg-tech.hashnode.devMar 6, 2025 · 4 min read

Why SQLcl Projects is a Great Fit for APEX Citizen Developers

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...

0

PRPatrizia Regenbergregenberg-tech.hashnode.devFeb 28, 2025 · 6 min read

SQLcl Projects vs. Liquibase: A Comparison

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...

1

D

DMDan McGhandanmcghan.hashnode.devFeb 17, 2025 · 3 min read

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...

0

#sqlcl-projects

Search Hashnode

#sqlcl-projects

Explore Hashnode

Trending tags this week

Managing Soft Objects in Oracle SQLcl Projects: Understanding stage.softObjectIsolation

Schema-agnostic Staged Changesets with stage.substituteSchemas

SQLcl Projects: referencia práctica para CI/CD en Oracle APEX

SQLcl Projects - Dynamic Property File Location Definition

The Problems with Liquibase Rollback — and What to Do Instead

Instant Maintenance Mode for Oracle APEX Apps

SQLcl Projects - Using Liquibase properties to modify your APEX installation

Why SQLcl Projects is a Great Fit for APEX Citizen Developers

SQLcl Projects vs. Liquibase: A Comparison

Feature Branches vs. End-of-Release Branches: Which Approach Works Best?