And the summary. Use #utPLSQL 👍

Just uploaded my three slide decks for Oracle Developer & Technology User Group (ODTUG) #Kscope23. I like my brand new presentation about the right API for #pinkdb apps. If you care about performance, security or maintainability, this session is for you.

I'm kinda tired of people attacking "agile" by bringing up the flaws in agile companies. All organizations of any size have flaws. Agility ≠ perfection. The question is whether the company is doing anything about those problems, not whether they exist. Ofc flaws exist.

Uncle Bob Martin @davidspearritt Milan Jovanović SQL has 4 flavors - "humans sitting at a terminal" is #direct invocation - "#embedded" was precompiled in C or COBOL In modern languages, use SQL to declare a stored #procedure or #prepared statement, with parameters, and call this API as any service. What's wrong with that?

Calling PL/SQL functions in #SQL queries leads to slow statements Right? No more! The Automatic SQL Transpiler in Oracle Database 23c can convert function calls to pure SQL, removing the context switch Tim Hall ∞🐵+∞⌨️ demos oracle-base.com/articles/23c/a…

Oracle Database 23c adds #JSON schema validation to check the properties of data you're storing e.g. ensure a column stores a JSON array with CREATE TABLE ... ( json_array JSON VALIDATE '{ "type" : "array" }' ) Tim Hall ∞🐵+∞⌨️ demos oracle-base.com/articles/23c/j…

Talk about utPLSQL by Philipp Salvisberg at #kscope23 Surprising but satisfying result of the question "who has worked with utplsql before?" : half the room 😮 \o/

A hot weekend is ahead and I plan to work on the enhancement of the Java API, CLI, and Maven plugin of utPLSQL to support expressions to run tests. OSS will cool me down ;-) #utPLSQL #OSS

A quick question to users of #utPLSQL What platform are you using to run the utplsql-cli? (github.com/utPLSQL/utPLSQ…) Simon Martinelli is thinking of making it available in some package managers.

If you want to get to grips with SQL table macros you ought to book mark this URL on Stew Ashton blog: stewashton.wordpress.com/category/sql-t… There are 13 articles (so far), and they'll probably appear in reverse order, the current most recent has a catalog of the individual URLs.

Martin Bach I think Test Driven Development by Kent Beck 🌻 was a good starting point for me. Then Working Effectively with Legacy Code by Michael Feathers for some nuance and considerations when working with existing code bases. utPLSQL as framework had biggest impact on testing with main language.

Thanks, DOAG e.V. for accepting two talks for #doag2023. I'm speaking about JavaScript in the #OracleDatabase and #utPLSQL. 🥳 See you in Nuremberg.

ORAdiff is live - compare two Oracle Database and Patch releases This is the tool many of you have waited for a long time. Quickly find out about new parameters? Any privileges taken away? Or: Is this fix included in a given RU? ORAdiff is THE tool. mikedietrichde.com/2023/08/08/ora…

ORAdiff is live! 🪩🪩🪩 dbarj.com.br/en/2023/08/ora… Oracle Database Oracle Oracle ACE Program

new version of utPLSQL framework has just been released. v 3.1.14 includes new feature for invoking unit test run with tags. It also includes some enhancements and fixes. You may download the latest version from here: github.com/utPLSQL/utPLSQ…

The newest version of dbFlux is out and now supports utPLSQL Code Coverage! #dbFlux #utPLSQL #orclAPEX marketplace.visualstudio.com/items?itemName…

If you missed our #AskTomOfficeHours session about #SQL Version Control, you can now rewatch it on Youtube ⬇️ 📹 youtu.be/ZmmyquWkhno?si… Oracle ACE Program

The dbLinter Rule Repository is live. Thanks Philipp Hartenfeller! So what's next? A VS Code extension implementing those rules with quick fixes. I will demo it at #apexconn25. Want a sneak peek? salvis.com/blog/2025/03/1…