Peter O'Brien

A wanderer with a purpose

[Peter O'Brien @pobalopalous]

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

[Peter O'Brien @pobalopalous]

🚀 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 👉 https://t.co/BeE0ufGj5m

#Oracle #OracleRESTDataServices #OCI #Databases

[Peter O'Brien @pobalopalous]

🕵️‍♂️ 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 👉 https://t.co/ZChyVU91ec

#Oracle #ORDS #26ai #UnifiedAuditing

[Peter O'Brien @pobalopalous]

🚀 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 👉 https://t.co/XlRHyQgs61

#OracleRESTDataServices #23ai #Performance #AutonomousDatabase

[Peter O'Brien @pobalopalous]

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.

🔗 https://t.co/0AxpdXjtOH

#Oracle23ai #OracleRESTDataServices #JavaScript #MCP #Claude

[Peter O'Brien @pobalopalous]

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 AI Database @OracleDatabase]

"Oracle’s MCP Server revolutionizes AI-driven database interactions. It works with any supported Oracle Database—from 19c to 23ai—and can be used on-premises, in hyperscalers such as Azure, AWS, Google, and OCI—and even on the laptop. All Oracle Database users should give it a try to chat with their database, generate reports and perform operations such as Data Load and Data Transform." Read the HyperFRAME Research article: https://t.co/93szI0CHuF

[Oracle AI Database @OracleDatabase]

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. https://t.co/hRd1x4xq8O

[Peter O'Brien @pobalopalous]

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

🏗️ 🚀

https://t.co/DniQpmKkfg

[Peter O'Brien @pobalopalous]

Within minutes I had #ClaudeDesktop answering questions about the HR example data set.
https://t.co/wwi4yrTeDU

[that Jeff Smith @thatjeffsmith]

'using my fun database, can you tell me how many miles i have ran?'

With MCP Server for @OracleDatabase avail 4 Cline, the Claude LLM can try to figure that out.

I WILL be reviewing everything this Agent does on my behalf, but also my 'fun' connection is locked down.

[that Jeff Smith @thatjeffsmith]

Yesterday's video record for our MCP for @OracleDatabase introduction with @krisrice

https://t.co/Hy0TNV5Efh

[Peter O'Brien @pobalopalous]

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.
https://t.co/a1dJ63bu10

[Tara Van Cleave @TaraVCleave]

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 https://t.co/M7R9icpxw4

[Peter O'Brien @pobalopalous]

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

[Peter O'Brien @pobalopalous]

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.
https://t.co/a1dJ63c1Qy #ORDS #OracleREST

[Peter O'Brien @pobalopalous]

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.

https://t.co/WKiYp0GFxI

[Peter O'Brien @pobalopalous]

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.
https://t.co/a1dJ63bu10

[Peter O'Brien @pobalopalous]

Good, practical, tips on effective ci/cd pipelines

[Martin Bach @MartinDBA]

DevOps is widely adopted, yet developers still hesitate to apply its principles to their data stores. But there's no need for that—Database CI/CD is a reality. Take a look at this tech brief to learn how you can integrate your database into CI/CD pipelines https://t.co/gFiuqpnmI8

[Peter O'Brien @pobalopalous]

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

[Peter O'Brien @pobalopalous]

🚀 Bring AutoREST to #MySQL, #PostgreSQL, #SQLServer, #DB2 & more with a custom #OracleRESTDataServices plugin! No install needed—just a JDBC driver. 💡🔌

👉 Build it yourself: https://t.co/Jvm3v1K4u9

#NoInstallRequired #PluginExample #RESTAPI #Database

[Peter O'Brien @pobalopalous]

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

[Neil Fernandez @neilbfernandez]

SQLcl Projects has been taking off and hopefully this helps answer some questions on configurable APEX deployments!

SQLcl Projects - Using Liquibase properties to modify your APEX installation
https://t.co/5DScZLc3KH

#orclAPEX #sqlcl

[Peter O'Brien @pobalopalous]

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 https://t.co/a5OiG7soNl