chrishoina

We also provide folks with free access to a 26ai database as a "FreeSQL" user. We'll plug your connection details into VSC, or if you don't yet have the Oracle SQL Developer for VS Code extension, we'll prompt to download and then enter in your FreeSQL connection details. Thanks FreeSQL team 🙌

New update to our SQLcl MCP Server Intro Lab: updated prompts for your AI Agents and we cut down on the lab's overall word count.

Learn more here: livelabs.oracle.com/ords/r/dbpm/...

#ai #oracle #26ai #cline #sqldeveloper #oracledatabase

A reminder that k6 is still out there, and people are using it for their ORDS APIs too. Nice write-up: btimmerman.hashnode.dev/load-testing...

At one point Grafana Labs had a .har -> k6 scenario script (.js) convertor browser extension. Making it much easier to create test scenarios.
#api #testing

ICYMI, ORDS 25.4 is available for download and being updated across the Autonomous fleet. Link: www.oracle.com/database/sql...

We've updated our image in the Oracle Container Registry, made doc improvements, and added fixes too. Release Notes: www.oracle.com/tools/ords/o... #newrelease #ords #apis

Want to just read/follow along? Check out these three companion blogs:

blogs.oracle.com/database/pro...

blogs.oracle.com/database/bui...

blogs.oracle.com/database/pro...

Video series is up next. See in real time how AI Agent + the SQLcl MCP Server and prompts work for the Oracle database.

a cartoon of a chef with a needle in his mouth is playing at 4:32 ALT: a cartoon of a chef with a needle in his mouth is playing at 4:32

I keep reviewing this SQLcl MCP Server LiveLab as new Tools are added and as LLM models mature. Today, the prompts in the LL are (see GIF). Review the lab and test the prompts with your favorite LLM API provider before I change them up again! livelabs.oracle.com/ords/r/dbpm/...
#LLMs #AI #MCP #SQLcl

AI agents can help you build schemas and create test data

@chrishoina.bsky.social shares an example prompt to store data about cars, trucks, motorcycles and their manufacturers

Then shows you how to use it with SQLcl MCP Server and Cline to make the tables

While you are at it, might as well try out our new LiveLab too :)

livelabs.oracle.com/pls/apex/dbp...

API doc for these new ORDS DB-API endpoints: docs.oracle.com/en/database/...

More on Session-less transactions in the ORDS Dev Guide: docs.oracle.com/en/database/...

#Friday #updates #api #ORDS #oracleREST

Friday Announcement: ORDS 25.3 is now available for download (with ORDS in ADB dropping soon). Download the latest here: www.oracle.com/database/sql...
Check out Sessionless Transactions. We'll have an upcoming demo provided by our TxEventQ team, so stay tuned for that. Links in the reply.

Since having placed some more focus on the ORDS image we've been getting lots of great feedback. Here is one example, Martin had some really great observations/thoughts on how we could improve the developer's debugging experience when working with our ORDS container. Thanks @martindba.bsky.social 😃

Quoting oneself: cool or cringe? "Eventually...we'll all need to become "prompt engineers." And as you'll see [there], you actually have to know what you are doing to be able to ask the right questions and to challenge an LLM's assumptions."

followthecoffee.com/from-one-api...

#apis #LLM #ords

Coming to you live from 35000ft, somewhere over the Atlantic Ocean. An ORDS and GraphQL tutorial: using Maven to build the polyglot and js dependencies for GraalVM 21: followthecoffee.com/ords-and-gra...

#graalvm #oracle #database #maven #jdk #ords #oraclerest

More on PARs and a note re: APEX RESTful Data Services ORDS version 25.2 is now available! Also a quick overview on the new PAR support in SQL Developer Web and a note regarding RESTful Services interface in APEX.

I should mention @thatjeffsmith.com beat me to it, but here is a great example showcasing the latest ORDS Pre-Authenticated Requests (PARs) updates www.thatjeffsmith.com/archive/2025...

ORDS 25.2 is now available for download! Download directly from www.oracle.com/database/tec...
And review the Release Notes too www.oracle.com/tools/ords/o...

I'm following up with a blog with some examples, so stay tuned! #newrelease #productupdate #ords #oracledatabase #newordswhodis #plsql #rest

We keep seeing these legacy ORDS installs/migrations popping up more… | Chris Hoina We keep seeing these legacy ORDS installs/migrations popping up more frequently. I can set up a podman 23ai container with a legacy ORDS install and show you how to migrate to the latest ORDS version....

I have a poll going for showing how to perform a legacy ORDS install/migration. I can set up a podman 23ai container with a legacy ORDS install and show you how to migrate to the latest ORDS version. Please read the details and vote. Would this be helpful? www.linkedin.com/posts/chrish...

Yeah, that’s really cool. It just looks so pretty too 😍

Astro Astro builds fast content sites, powerful web applications, dynamic server APIs, and everything in-between.

Yay or nay for astro.build so far? Should I take a look?

This united-codes site is really pretty, I am excited to see it grow :)

The more "building" type stuff I do, the more I appreciate the terminal. Especially in and around VMs and containers.

I'm going to ask we add in some more info in those docs though. For a beginner, it's a steep learning curve. Alternatively, we may create an official Oracle blog for walking through how to do this on/with Podman 😍

Philipp, I just got the containers to work using that compose file! Were you able to? Let us know if you have issues. I have to say, first time using that compose file, and it is so nice to start up/down both at the same time.

Oracle REST Data Services (ORDS) command line interface. - Repository Detail Copyright (c) 2017, 2018, Oracle Corporation. All Rights Reserved.

And yes, that direct URL is best: container-registry.oracle.com/ords/ocr/ba/...

Huh, somebody must have corrected it?? I see: DBSERVICENAME=FREEPDB1
- DBHOST=database
- DBPORT=1521
- ORACLE_PWD=oracle
In the compose file. That's weird. Looks good now, no?

FYI to all, the ORDS team just published a new patch, 25.1.1. Now available for download here: www.oracle.com/database/sql...

Two small bug fixes, and an update to our Jetty library. Happy Friday 😍
#oraclerest #oracledatabase #restapi #apidevelopment #jdk17 #jdk21 #graalvm #newupdate #bugfix

And two additional ORDS + JWT blogs that demonstrate using JWTs in OCI IAM or Microsoft Azure. You can check those out here: followthecoffee.com/configuring-... and here: followthecoffee.com/ords-apis-an...

Enjoy, and let me know what you want to see next! #blog #oracleblogs #learning #tutorial

Now, on to part two. Part two takes the previous configuration and uses it to showcase this JWT authorization/authentication in a simple single-page web application. We use JavaScript, basic HTML, Node.js, and Express.js too. You can follow along here: blogs.oracle.com/database/pos...

New Oracle blogs are live! With a two-part tutorial showing you how to create custom claims in your Identity Domain, include them in a JSON Web Token, and use it to access ORDS OAuth2.0 protected resources. Part One is here: blogs.oracle.com/database/pos... #wednesday #oracle #restapis #oraclerest

Sneak peek of an upcoming blog post. A super simple single page web app, exploring using JSON Web tokens with ORDS protected resources. This time using Roles-Based Access Control (RBAC). 😁😎

The ORDS team has a brand-spanking new customer reference. Note only did Sphere just launch their new site, but they JUST presented at CloudWorld Miami too, check out the press release here: www.oracle.com/news/announc...
If you are interested in attending as a speaker, drop me a DM, let's chat.