chrishoina

..."okay I think I need to start looking at JVM and memory optimization, VM or container settings, web server memory and configuration, different garbage collection strategies..."

What does your process look like?
#ords #api #loadtesting #apm

Okay, here is something else...at what point do move from, "okay my SQL and PL/SQL is 100% optimized, as are the underlying tables, views, etc..." to...

Now...here is what I'd like to know: how are you, in your own way, correlating some of these failed HTTP requests with a specific endpoint? I'm leaning towards a custom Unified Audit Policy for this specific test. But what do you prefer?

Don't get me wrong, creating a scenario for a single user is tough; we haven't even started on multiple unique users yet! But once you have defined the scenario, and executed it, you'll then have your results.

onversation starter:

Hypothetically, you want to load test your ORDS (/ords/) endpoints or APEX (/r/) app; in this case the Brookstrut APEX app. It's almost like the easy part is the test itself.

And if you've taken this LiveLab, how did you like the prompts? How did they work out for you? Were the results what you were expecting? And how are you using prompts in your daily database admin/developer workflows today?
#ai #agents #sqlcl #cline #agentic #llms #mcp #mcpserver #sqldeveloper

Curious about MCP Servers? Well, now is a great time to learn. We've just updated our SQLcl MCP Server LiveLab, yet again. The setup labs are even more streamlined and we've added some helpful steps for macOS AND PC users too. Try it out or share with others: livelabs.oracle.com/ords/r/dbpm/...

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/...