I had the privilege to present about CI/CD and relational databases during #Thementage25 (www.ittage.informatik-aktuell.de/thementage.h...) I promised I'd polish my demo and blog about it, and that's what I did today. Here's to SQLcl project and Oracle 23ai: martincarstenbach.com/2025/06/25/t...

Thementage

Die Thementage Remote 2025 bieten mit 6 Konferenztagen im Livestream und über 600 Stunden Session-Aufzeichnungen eine große Bandbreite an aktuellen Entwickler-, Architektur- und IT-Betriebsthemen.

ittage.informatik-aktuell.de

Rolling back #database changes is hard Why? Data! dmcghan.bsky.social covers how to recover this in Oracle Database: Flashback database Database restore Export/import And online ways to deploy safely: Edition-Based Redefinition DBMS_REDEFINITION buff.ly/r04arHd

Relying on Liquibase rollback? That might be your riskiest move. 💥 Find out why it fails—and how to do it right with Oracle Flashback, Data Pump, and EBR. 👉 danmcghan.hashnode.dev/the-problems... #orclAPEX #OracleDB #sqlcl #DevOps

Really like them! trivadis.github.io/plsql-and-sq...

Ready to simplify CI/CD with Oracle Database? Jeff shows you how to get started with SQLcl Projects. Powerful tools, but you have to be willing to pay nothing! :D

Jeff Smith@thatjeffsmith.com · last yr.

Published two new blog posts today, but first I want to show off a new Oracle LiveLab - livelabs.oracle.com/pls/apex/r/d... Complete end-to-end demo for using SQLcl projects to build and maintain a React Web app with an Oracle Database backend!

Whenever you see "Never" or "Always" or other absolutes in claims about tech, you just know its not really about the tech, its about the clickbait.... ... and yes, I'm the sucker that responds :-) connor-mcdonald.com/2025/04/30/c...

Calling out LinkedIn Clickbait

Yeah yeah I know. You don’t have to remind me. When someone posts a LinkedIn post with the following image:   then I know, you know, everyone knows, that it has been done to grab attenti…

connor-mcdonald.com

Best fix/feature in #Oracle SQLcl 25.1.0 : When you change the contents of a file (e.g. a package body), "project stage" will automatically reformat the code and update the hash. No need to export it from the database again! #sqlcl #cicd #orclapex

If you enjoy low-code development and have some free time, check out this free Oracle APEX certification—it's available at no cost until May 15. I tried it last night, and the exam is very well designed! blogs.oracle.com/apex/post/be...

Soon. #orclapex

We got a great overview of the capabilities of the new SQLcl Project feature. No better person to present it than @apexconsulting.nl - one of the first to use it for his CI/CD pipeline in production! In my opinion - the way APEX (and database) versioning and deployment will be done in the future 💡

Here's the video of APEXLang that Mike Hichwa showed in his talk this morning at #APEXWorld2025 The is massive potential here from easier ci/cd to code reviews to AI trained on the language to tooling as we'll publish the grammar behind when it launches

APEX Lang is a new domain specific language you will be able to use to define Oracle APEX apps This is a human readable language designed to help you build and manage apps faster #apexworld2025 #orclapex

New to database development? We've got a one-stop shop for your to get up to speed in just a few days asktom.oracle.com/databases-fo...

Finally got a chance to try #SQLcl projects! Initially struggled, expecting it to work like Liquibase, but once I realized Git is central to the workflow, everything clicked. I think it has huge potential—not just for big teams with CI/CD, but also for beginners and citizen developers.

🚀 Feature Branches vs. End-of-Release Branches: Which is the best approach for your team? Let's dive into the pros and cons of each strategy. danmcghan.hashnode.dev/feature-bran... #orclAPEX #cicd

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

danmcghan.hashnode.dev

Ready to upgrade your SQLcl while working on SQLcl Projects? Timing and a structured approach are key to a smooth transition. Here's how to do it right. danmcghan.hashnode.dev/upgrading-sq... #orclAPEX #cicd

Upgrading SQLcl When Using SQLcl Projects

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

danmcghan.hashnode.dev

🚀 SQLcl 24.4.1 released yesterday 🟢 Download: https://buff.ly/3ELLAAt 🔵 Release Notes:

We’ve added a new sample application to our Gallery, demonstrating the power of Vector Search in an APEX app. Huge shoutout to our intern Nicolas for making it happen! 👏🔥 #orclapex

It's easy to enter duplicate customer records with small variations in their name e.g. Smith vs Smyth @sandra.cloudnueva.com solved this with fuzzy matching calling UTL_MATCH.JARO_WINKLER_SIMILARITY in Oracle #SQL to find possible matches when making new customers

APEX Developer Blogs now allows you to perform a 23ai Vector/Semantic Search and/or ask questions on all 3,000+ APEX Developer blogs using RAG. Head over to the Chat & Search option at apps.cloudnueva.com/apexblogs #orclapex

Oracle APEX Developer Blogs and Videos

Aggregates blogs and videos related to Oracle APEX and Oracle APEX-related development tech.

apps.cloudnueva.com

Oracle APEX 24.2 is now generally available! This release unlocks new capabilities for AI-powered apps 🤖, configure RAG data for AI calls🧠, automate Fusion Applications integration🔁, work directly with JSON data ✨, and much more! apex.oracle.com/go/242-is-no... #orclAPEX #LowCode

New blog post: Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments danmcghan.hashnode.dev/admin-vs-app... #orclAPEX #cicd

Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments

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

danmcghan.hashnode.dev

SQL domains make data models easier to understand and reduce the logic regarding data consistency and visualisation. How easy is it to change domains and propagate those changes to the underlying tables? Season's greetings and a happy new year! www.salvis.com/blog/2024/12...

Evolution of a SQL Domain for Semantic Versioning - Philipp Salvisberg's Blog

SQL domains abstract column properties for use across multiple tables. I demonstrate the evolution of a domain for Semantic Versioning.

salvis.com

My first blog post in years: An Overview of the Oracle SQLcl Projects Development Process danmcghan.hashnode.dev/an-overview-... #orclAPEX

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 applications. This post provides a high level overview of what the develop...

danmcghan.hashnode.dev

The Quick Start guide for SQLcl Projects was recently overhauled by @martindsouza 😍: docs.oracle.com/en/database/... Use this guide to kick the tires and see how SQLcl Projects can help with CI/CD on your Oracle Database and #orclAPEX apps!

Big Data was yesterday. Today we've got Colossal Data! www.commitstrip.com/en/2014/06/0... Just because the comic is old doesn't mean it's wrong.

Mike Hitchwa just demoed the new version 2 of #oracle LiveSQL which is really cool Chrck it out at livesql.oracle.com

For the festive season, we are doing a @united-codes.bsky.social  advent calendar with a quick APEX tip video every day. Check out how you can create reusable item utility buttons with #orclAPEX Shortcuts: youtu.be/iaX9R6O37QM

APEX Shortcuts | UC Advent Calendar 1

YouTube video by United Codes

youtu.be

Even @clocwise.bsky.social (formerly known as @CLOC_WISE) has now moved to #BlueSky. You can get all the updates on Call for Papers following it on : bsky.app/profile/cloc... No need to stay behind in the dark and the cold world of X anymore…

In October 2024, Oracle ACEs from all around the world shared tips and tricks, insights, and knowledge in 300+ blog posts and articles. We have highlighted some of them for you to read and enjoy, focusing on 23ai. ♠️ 👉 blogs.oracle.com/ace/post/mus... @fsimondba.bsky.social @cafedatabase.com