Martin Bach

@connor_mc_d Safe travels! Especially this time you’re coming to Europe 🤞

Heading to Europe for... big inhale... Swiss meetup, Voxxed Zurich, APEX World, AOUG event, RoOUG event, OWL event. The flight line from Perth to Europe ... is not really a great one :-)

Shipped a major pass on the Oracle DB Skills repo. github.com/krisrice/oracl… Updated examples and guidance across performance, monitoring, security, migrations, ORDS, AI/vector features, frameworks, and agent-safe DB workflows. #OracleDatabase #AI #SQL #PLSQL #DBA #VectorSearch

Do you use @oraclesqlcl in GitHub Actions? If so, you might like the latest update to gvenzl/setup-oracle-sqlcl. Release 1.3.0 allows you to pin a specific release to your pipeline. This is particularly useful for anyone using SQLcl Projects. Details 👇 martincarstenbach.com/2026/03/17/upd…

🇳🇱 Excited to share that I'll be speaking at APEX World 2026 (26-27 March)! 🔹 Supercharging Oracle APEX with Server-Side JavaScript 🔹 Workshop: Flows for APEX (with Richard Allen) nloug.nl/en/events/apex… #orclAPEX #AW26 #apexworld2026 #nlOUG #MLE #OracleDB #flows4apex

Watch @connor_mc_d cover APEX and 26ai, materialized virtual columns, benefits of LOB_VALUE, and more. social.ora.cl/6019hUekH

Watch this session to learn what 4NF is, the problems 4NF violations bring, and practical tips for implementing 4NF. social.ora.cl/6016hUdLO (w/@ChrisRSaxon)

A debt of gratitude owed by many connor-mcdonald.com/2026/03/12/tha…

AI is only as good as what it knows. For Oracle Database, that's been a problem. Built a library of 100+ practical guides to fix that — covering everything from PL/SQL to ORDS to migrations. Open source, MIT license. github.com/krisrice/oracl…

🚨 New Virtual Classroom Seminar coming up! Join the next session: “Patch Smarter, Not Harder” and learn more about Oracle Database patching (with demos), including environments with RAC and Data Guard. 📅 March 12 go.oracle.com/LP=151086?elqC…

It might be 2000 times worse than you thought connor-mcdonald.com/2026/03/09/bin…

@0xlelouch_ By using a database engine that doesn’t lock the table for this kind of operation 🤷

Your database has a users table with 50M rows. You add a new column is_verified BOOLEAN DEFAULT FALSE. The migration takes 6 hours and locks the table. How do you add this column without downtime?

@brankopetric00 One piece of advice I offer to everyone: test your backups regularly. Or else they are just a prayer on tape (or wherever else you store them). There have been too many occasions of “we didn’t notice the backups failed 2 weeks ago” I went through

Honest question: Has anyone ever successfully restored from a database backup on the first try? Or is that just a DevOps urban legend?

Using Codex to generate unit tests for @OracleREST gave me a real productivity boost 🤖 Curious 🤔? I recorded a short video 📹 showing my approach, with running commentary 🎙️: martincarstenbach.com/2026/03/05/rea… Do you have an internal platform? Use CI/CD? Let me know in the comments 🙏

Here's a short "life hack", allowing you to use utPLSQL in your CI pipeline. OK, right, you could do that before, but this time, if there are failed unit tests your pipeline run will abort. No need for any other software, just SQLcl to run the tests. martincarstenbach.com/2026/03/04/lif…

I started an experiment and let AI write my unit tests. What used to take me 1 hour now takes 10 minutes. Here’s how I used Codex with Oracle AI Database 26ai to generate tests for my @OracleREST endpoints 👇 martincarstenbach.com/2026/03/04/rea…

🎙️ DOAG #DevTalk | 05.03. | 17:00 Uhr Upgrade auf Oracle AI Database 26ai! Wie gelingt der Umstieg & welche Features sollte man testen? @MikeDietrichDE gibt Einblicke & Best Practices, moderiert von @oraesque. 💻 Online-Session: tinyurl.com/4cjnj37n #DOAGDevs #AIDatabase

Finally finding some time to dig deeper into the DORA 2025 Report. The recording of this webinar is very insightful in my opinion. Just throwing in AI without having thought about a platform might not provide the productivity gains you hoped for. thoughtworks.com/insights/repor…

📚 New Reading List is out! This week, we go deep into new ⭕ #Oracle AI #Database #SQL features. 📖 Happy reading! geraldonit.com/reading-list-m…

Use enum domains in Oracle AI Database to create lists of name-value pairs: CREATE DOMAIN ... AS ENUM ( n1, n2, ... ) With these you can Use the enum as a column's data type to constrain it to the enum's values Reference the values by name in #SQL Query the enum like a table