Lightnews — Scholar-powered news

Dan McGhan @dmcghan.bsky.social · Sep 13

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!

Reposted by Dan McGhan

Martin Bach @martindba.bsky.social · Jun 25

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.

www.ittage.informatik-aktuell.de

1 3

Reposted by Dan McGhan

SQLDaily @sqldaily.bsky.social · Jun 18

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

1 2

Dan McGhan @dmcghan.bsky.social · May 31

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

3 7

Reposted by Dan McGhan

Toon Koppelaars @toonkoppelaars.bsky.social · May 16

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

PL/SQL & SQL Coding Guidelines

trivadis.github.io

2 3

Dan McGhan @dmcghan.bsky.social · May 7

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

1 1

Dan McGhan @dmcghan.bsky.social · May 6

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 · May 6

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!

livelabs.oracle.com

3

Reposted by Dan McGhan

Connor McDonald on Database and SQL @connormcd.bsky.social · Apr 30

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

3 3 7

Reposted by Dan McGhan

Roel @apexconsulting.nl · Apr 15

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

4 12

Reposted by Dan McGhan

Alex Zaballa @alexzaballa.bsky.social · Apr 16

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

2 5

Reposted by Dan McGhan

Scott Spendolini 🍊 @spendolini.blog · Apr 15

Soon.

#orclapex

1 2 7

Reposted by Dan McGhan

Plamen Mushkov @apexapplab.dev · Apr 12

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 💡

3 8

Reposted by Dan McGhan

Kris Rice @krisrice.io · Mar 20

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

12 29

Reposted by Dan McGhan

Chris Saxon @chrisrsaxon.bsky.social · Mar 20

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

2 15 35

Dan McGhan @dmcghan.bsky.social · Mar 12

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

#sqlcl #orclapex

2 8

Reposted by Dan McGhan

Connor McDonald on Database and SQL @connormcd.bsky.social · Mar 10

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

2 8 17

Dan McGhan @dmcghan.bsky.social · Mar 5

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

1

Dan McGhan @dmcghan.bsky.social · Mar 5

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! 😉

1

Dan McGhan @dmcghan.bsky.social · Mar 4

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

1 3

Reposted by Dan McGhan

Patrizia Regenberg @p-regenberg.bsky.social · Feb 25

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.

4 9

Dan McGhan @dmcghan.bsky.social · Feb 25

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.

1 3

Dan McGhan @dmcghan.bsky.social · Feb 25

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.

2 1 5

Dan McGhan @dmcghan.bsky.social · Feb 25

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.

1 1

Dan McGhan @dmcghan.bsky.social · Feb 25

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.

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

1 3

Dan McGhan @dmcghan.bsky.social · Feb 17

🚀 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

1 2