Peter O'Brien

@thatjeffsmith A lot has been added to SQLcl since then! 👏

Previously on thatJeffSmith: Oracle SQLcl version 24.1 is now available! thatjeffsmith.com/archive/2024/0…

🚀 New post on ORDS connection types! I break down all 4 db.connectionType options — basic, tns, customurl & databaseToolsConnection — with comparisons and associated settings. Read here 👉 peterobrien.blog/2025/11/17/und… #Oracle #OracleRESTDataServices #OCI #Databases

🕵️‍♂️ Got inactive Oracle DB accounts lurking in your system? With Unified Audit Policy, you can identify users that haven’t logged in for X days — even REST-enabled schemas accessed via ORDS. Full guide 👉 peterobrien.blog/2025/10/15/fin… #Oracle #ORDS #26ai #UnifiedAuditing

🚀 Faster Database Authentication with Oracle 23ai + ORDS 25.3.0 Real-world tests show Basic Authentication response times cut by over 60% ⚡️ See the before/after data and what changed 👉 peterobrien.blog/2025/10/09/fas… #OracleRESTDataServices #23ai #Performance #AutonomousDatabase

Making concert event data from the ORDS Sample Application accessible to AI agents like Claude Desktop. Full handler code, OAuth2 security, and testing tips inside. 🔗 peterobrien.blog/2025/08/16/imp… #Oracle23ai #OracleRESTDataServices #JavaScript #MCP #Claude

Chat with your Oracle databases securely…key feature called out in the article: “The feature is architected for secure, context-aware communication between AI agents and enterprise data.”

Oracle’s MCP Server for Database is part of Oracle’s strategy to aggressively drive AI capabilities into its database products. It’s an approach that allows customers to leverage existing infrastructure while addressing enterprise security concerns and accelerating adoption. social.ora.cl/6018fueHk

Learn how to implement a JSON-RPC 2.0 API using ORDS + MLE JavaScript in Oracle Database 23ai. For Free! - No PL/SQL...Native JavaScript execution - Standards-compliant JSON-RPC request/response - Fully serverless on #OracleAutonomousDatabase 🏗️ 🚀 peterobrien.blog/2025/07/23/jso…

Within minutes I had #ClaudeDesktop answering questions about the HR example data set. docs.oracle.com/en/database/or…

Yesterday's video record for our MCP for @OracleDatabase introduction with @krisrice youtube.com/watch?v=Xnmty5…

ORDS 25.2.0 is out! One of the new CLI features is a subcommand to verify DB details AND display ORDS_METADATA version if installed in that DB. Use "ords config --help" for more info. Use "--db-pool my-pool" option to specify a pool other than default. oracle.com/rest

Join us on July 10 to learn how the Microsoft Copilot assistant for VS Code and the new Oracle Database MCP Server natural language interface are transforming how teams build, access, and collaborate around data. Register at social.ora.cl/601845UqQ

@marcel_jomasoft That will be up to the Java folks to provide a Java 17 or Java 21 distribution for Solaris SPARC.

@pobalopalous Any plans to make this work on Solaris SPARC where Java17 is missing currently?

Oracle REST Data Service 24.4 is out. See release notes for info on new features and bug fixes. Important to note that Java 17 is minimum required JRE version now. oracle.com/rest #ORDS #OracleREST

Beginning with ORDS version 25.1.0, the "ords-developer" image is deprecated. The "ords" image has changed substantially now. However, it is still the image that is supported for production use. Please read this document to learn the latest changes. container-registry.oracle.com/ords/ocr/ba/da…

ORDS 25.1.0 is out! Check out the role based access control with OAuth2 JWT Profile feature that makes integration with your existing identity provider even easier. oracle.com/rest

Good, practical, tips on effective ci/cd pipelines

@FriedholdMatz Excellent question. It should, but I have never tried it. Give it a go and report back! The code is all there in GitHub if you need to debug issues. 👍

@pobalopalous That is very interesting! Is there also a chance with SQLite?

🚀 Bring AutoREST to #MySQL, #PostgreSQL, #SQLServer, #DB2 & more with a custom #OracleRESTDataServices plugin! No install needed—just a JDBC driver. 💡🔌 👉 Build it yourself: peterobrien.blog/2025/03/09/uni… #NoInstallRequired #PluginExample #RESTAPI #Database

Import @OracleAPEX applications with your choice of workspace, alias, and even Application ID. All from SQLcl command line…

If you run @OracleREST on @OracleCloud then you'll find this "Building scalable Oracle ORDS Deployment with ETCD and OKE" post by our very own Hamid Idifi very interesting medium.com/p/building-sca…