iiinova — where your digital self keeps evolving

Dan McGhan @dmcghan.bsky.social · 13/09/2025

What if there were people behind you and they sprang out after you heard the count? Would it update you? No wait, there’s four of them!

000

Reposted by Dan McGhan

Martin Bach @martindba.bsky.social · 25/06/2025

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

ittage.informatik-aktuell.de

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.

031

Reposted by Dan McGhan

SQLDaily @sqldaily.bsky.social · 18/06/2025

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

021

Dan McGhan @dmcghan.bsky.social · 31/05/2025

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

danmcghan.hashnode.dev

073

Reposted by Dan McGhan

Toon Koppelaars @toonkoppelaars.bsky.social · 16/05/2025

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

trivadis.github.io

PL/SQL & SQL Coding Guidelines

032

Dan McGhan @dmcghan.bsky.social · 07/05/2025

I remember reporting this bug over a year ago. :) It was patched in 19.23 too.

110

Dan McGhan @dmcghan.bsky.social · 06/05/2025

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

030

Reposted by Dan McGhan

Connor McDonald on Database and SQL @connormcd.bsky.social · 30/04/2025

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

connor-mcdonald.com

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…

373

Reposted by Dan McGhan

Roel @apexconsulting.nl · 15/04/2025

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

0124

Reposted by Dan McGhan

Alex Zaballa @alexzaballa.bsky.social · 16/04/2025

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

052

Reposted by Dan McGhan

Plamen Mushkov @apexapplab.dev · 12/04/2025

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 💡

083

Reposted by Dan McGhan

Kris Rice @krisrice.io · 20/03/2025

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

03012

Reposted by Dan McGhan

Chris Saxon @chrisrsaxon.bsky.social · 20/03/2025

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

13415

Dan McGhan @dmcghan.bsky.social · 12/03/2025

SQLcl 24.4.3 was released today and fixes the APEX export bug. Thanks for the heads up, Roel. #sqlcl #orclapex

082

Reposted by Dan McGhan

Connor McDonald on Database and SQL @connormcd.bsky.social · 10/03/2025

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

2178

Dan McGhan @dmcghan.bsky.social · 05/03/2025

Though, Oracle did finally drop ‘from dual,’ so one never knows...

010

Dan McGhan @dmcghan.bsky.social · 05/03/2025

I agree with your logic, but I think it’s easy to see that some of SQL’s awkwardness is routed in English’s. Is it worth “fixing”? I don’t know. We need something apolitical to complain about these days. Something that unites us! 😉

100

Dan McGhan @dmcghan.bsky.social · 04/03/2025

“Get the milk and bread from Aldi” vs “From Aldi, get the milk and bread”… 🤪

130

Reposted by Dan McGhan

Patrizia Regenberg @p-regenberg.bsky.social · 25/02/2025

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.

094

Dan McGhan @dmcghan.bsky.social · 25/02/2025

Hi Patrizia, firstly, thanks for reporting the issues you found in the SQLcl Forum. Have you tried running: project config -list -verbose Perhaps there'll be an equivalent in the doc some day, but that command is your best bet for now.

130

Dan McGhan @dmcghan.bsky.social · 25/02/2025

In the beginning, SQLcl Projects can feel intimidating. Lot's of commands, processes, etc. But after a few weeks it should start to feel more natural. Once you get to that point, undoing things that commands like stage and release do should be simpler.

251

Dan McGhan @dmcghan.bsky.social · 25/02/2025

I'm unaware of any ties in SQLcl Projects to Git tags, so any strange behavior there should be revisited. Please let us know if you have a reproducible test case. I suspect the true issue was the one you mentioned later, the fact that the main changelog still had points to the deleted release.

110

Dan McGhan @dmcghan.bsky.social · 25/02/2025

Hi Plamen, did you happen to see this post? danmcghan.hashnode.dev/upgrading-sq... I recommend refreshing 'src/database'. That would have addressed the issue you ran into with the .pks/.pkb extensions changing to .sql. It would also fix other issues that can happen with updates to SQLcl Projects.

danmcghan.hashnode.dev

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

130

Reposted by Dan McGhan

Matt Mulvaney @bsky-matt.0code.io · 13/02/2025

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

buff.ly

031

Reposted by Dan McGhan

Patrick Wolf @patrick-wolf.bsky.social · 31/01/2025

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

0237

Dan McGhan @dmcghan.bsky.social · 31/01/2025

Of course, things aren’t so easy if you’re on a shared DB (recovery at the schema level isn’t as easy), and some projects can’t have any downtime. That’s where Edition Based Redefinition could come into play. I’m looking forward to exploring that more at some point. 🤓

030

Dan McGhan @dmcghan.bsky.social · 31/01/2025

SQLcl Protects includes an installer that can be modified to do that too! 😁 We’ve done similar things like disable/reenable apps, jobs, and other users with DML grants while deploying. The idea is to get to a steady state for easy recovery if something goes wrong during a deployment.

140

Reposted by Dan McGhan

SQLDaily @sqldaily.bsky.social · 29/01/2025

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

buff.ly

173

Reposted by Dan McGhan

Jon Dixon @jon.cloudnueva.com · 28/01/2025

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

apps.cloudnueva.com

Oracle APEX Developer Blogs and Videos

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

0131

Reposted by Dan McGhan

msewtz.bsky.social @msewtz.bsky.social · 15/01/2025

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

03217

Reposted by Dan McGhan

Philipp Salvisberg @salvis.com · 24/12/2024

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

salvis.com

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.

093

Dan McGhan @dmcghan.bsky.social · 12/12/2024

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!

docs.oracle.com

User's Guide

1168

Reposted by Dan McGhan

Markus Winand @winand.at · 11/12/2024

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.

3214

Reposted by Dan McGhan

Maria Colgan @sqlmaria.com · 10/12/2024

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

12112

Dan McGhan @dmcghan.bsky.social · 10/12/2024

One last note: SQLcl Projects requires a feature branch (short lived or otherwise) to diff with.

000

Dan McGhan @dmcghan.bsky.social · 10/12/2024

Thought to ponder: if you’re primarily an Oracle Database/#orclAPEX developer, does working in a shared development environment = instantaneous/automatic continuous integration? 😁 I think so.

100

Dan McGhan @dmcghan.bsky.social · 10/12/2024

Yeah, that title is very misleading. It’s completely fine to create short-lived feature branches. I’m not sure why it wasn’t just called “short-lived feature branching.”

210

Reposted by Dan McGhan

Philipp Hartenfeller @hartenfeller.dev · 01/12/2024

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

youtu.be

APEX Shortcuts | UC Advent Calendar 1

YouTube video by United Codes

22311

Reposted by Dan McGhan

Roel @apexconsulting.nl · 23/11/2024

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…

bsky.app

21913

Dan McGhan @dmcghan.bsky.social · 23/11/2024

But it still feels SO much better! 😁

040

Reposted by Dan McGhan

Oana Bonu @oanabonu.bsky.social · 22/11/2024

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

0187

Reposted by Dan McGhan

Scott Spendolini 🍊 @spendolini.blog · 22/11/2024

Bluesky doesn't do verifications like the other site does. It's much quicker and costs $0. To get verified, all you need to do is prove you own or control a domain. It took me 2 minutes to set this up with my own domain. Here's how it works: bsky.social/about/blog/4...

1142

Reposted by Dan McGhan

Connor McDonald on Database and SQL @connormcd.bsky.social · 21/11/2024

What can we learn about Javascript in the database in the time it takes to ride the escalator at #DOAG2024 with @martindba.bsky.social youtu.be/LmPa5dXx-aw

youtu.be

Javascript in the DATABASE? MLE in 90 seconds.

YouTube video by SQL and Database explained!

2308

Dan McGhan @dmcghan.bsky.social · 21/11/2024

Hello, Bluesky! Looking for a way to standardize and streamline your @OracleDatabase and #orclAPEX CI/CD processes? Don't miss the next APEX Office Hours, starting in under two hours. asktom.oracle.com/ords/r/tech/...

asktom.oracle.com

0177

Reposted by Dan McGhan

Scott Spendolini 🍊 @spendolini.blog · 20/11/2024

Made some updates to my APEX Starter Pack. Not on there and want to be? Just send me a DM or reply here and I'll happily add you to the list. #orclapex go.bsky.app/6kaBDaf

3126