chrishoina

youtu.beAn intro to the ORDS /vectorSearch and /vecdb/embed REST APIsYouTube video by Chris Hoina

24 Apr

A follow-up to this post, a new companion video: youtu.be/AcF1CP6P9z0?... Not meant to replace, but rather complement the article. Lessons learned working with Vectors as well as general ORDS wisdom. Like this sort of content? Let me know. We can do other videos on our database tools too.

chrishoina@chrishoina.bsky.social

ORDS 26.1 dropped 2 weeks ago. 26.1 has a TON of VECTOR-focused ORDS APIs; like the new /vectorSearch endpoint. Check out this article where I discuss a common use case and how I've solved for it with ORDS and VECTOR search. blogs.oracle.com/database/pai... #AI #LLMs #oracleREST #vectorsearch #api

youtube.comHow to Build Web and Mobile Apps with Oracle AI DatabaseYouTube video by Oracle Developers

Another plug for the Fusabase team too...check out their latest demo/intro (where ORDS servers act as the critical Middleware for this new developer toolkit): www.youtube.com/watch?v=QyFP...

chrishoina@chrishoina.bsky.social

A new ORDS quarterly release is out: with additions to our Deep Data Security, MCP Server capabilities, Oracle DB API for MongoDB. An Honorable Mention goes out to the Oracle Fusabase team too (where ORDS plays a supporting role). See the details here: www.oracle.com/tools/ords/o...

15 Sept

Oracle AI World is coming up. We'll be featuring a very special AI hackathon. Are you attending? If so, be sure to register for the hackathon too. Or, just come hangout and watch the fun. Details here: reg.rf.oracle.com/flow/oracle/... We can't wait to see you this year. #aiworld #oracledatabase

29 May

ORDS 26.1.2 is now available; some security bugs on this one. Our download page has a new 18-month "trailing" Change-log; displaying currently supported ORDS versions. www.oracle.com/database/sql... And on the way: demo of deploying ORDS w/ OCI Database API Gateway Configuration Service. Stay tuned.

17 Apr

8 Apr

ORDS 26.1.0 is out, available for download (rolling out in ADB now): www.oracle.com/database/sql... In the meantime, take a look at the release notes here: www.oracle.com/tools/ords/o... #vector #vectorsearch #huggingface #ords #rest #ONNX #apidevelopment #LLMs #LLM

8 Apr

I'm putting the finishing touches on a simple app, for demonstrating how to use the new /vectorSearch and db-api/vecdb/ endpoints. This demo should be on Oracle blogs soon. But in the meantime, here is a screen grab of what to expect (the UI might change a little, but here is the current state).

8 Apr

I'm using our built-in ORDS OAuth2.0 Server (using the Client Credentials grant type), a single Auto-REST enabled table (PARKS), and a lone /vecdb/embed endpoint to make this all work. This demo should help illustrate how Vector search works in real life. #vectorsearch #huggingface #ords #rest #ONNX

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.

View full thread

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

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

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.

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.

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?

19 Feb

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

19 Feb

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

7 Jan

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

7 Jan

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 🙌

btimmerman.hashnode.devbtimmerman.hashnode.dev

20 Dec 2025

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

17 Dec 2025

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

lnkd.inLinkedInThis link will take you to a page that’s not on LinkedIn

10 Dec 2025

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.

chrishoina@chrishoina.bsky.social

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

10 Dec 2025

chrishoina reposted

SQLDaily

@sqldaily.bsky.social

4 Dec 2025

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

buff.lybuff.ly

livelabs.oracle.comlivelabs.oracle.com

20 Nov 2025

While you are at it, might as well try out our new LiveLab too :) livelabs.oracle.com/pls/apex/dbp...

Jeff Smith@thatjeffsmith.com

video is now avail :) www.youtube.com/watch?v=wiO5...

youtube.comDeep Dive: Bringing the Agentic AI experience to your Oracle databases via our MCP ServerYouTube video by Jeff Smith

3 Oct 2025

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.

docs.oracle.comOracle REST Data Services APIProvides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API.

3 Oct 2025

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

martincarstenbach.comNew DEBUG flag simplifies troubleshooting ORDS container image issuesI previously wrote about troubleshooting the ORDS (Oracle REST Data Services) container’s entrypoint, e.g. the script that’s run whenever an ORDS container starts. This older article is…

10 Sept 2025

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 😃

Martin Bach@martindba.bsky.social

🚀 New DEBUG=TRUE flag makes ORDS container debugging way easier! 🐳 No more hacks—see exactly what’s happening during startup in ORDS 25.2.3. 💡 Here’s how it works (with live example): 👉 martincarstenbach.com/2025/09/10/n... #ORDS #DevOps #Oracle #containers

25 July 2025

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

3 July 2025

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

1 July 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

thatjeffsmith.comMore on PARs and a note re: APEX RESTful Data ServicesORDS 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.

3 July 2025

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

linkedin.comWe keep seeing these legacy ORDS installs/migrations popping up more… | Chris HoinaWe 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....

7 June 2025

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

united-codes.comInit podman on MacOSGetting started with Podman on macOS for Oracle 23ai development

5 June 2025

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

Philipp Hartenfeller@hartenfeller.dev

I was using the ords-developer and now migrated to the normal images. That worked out smooth. I also see a lot of things with Mac's and podman. I documented all the issues I cam across and how to fix them here: www.united-codes.com/products/uc-...

30 May 2025

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

21 May 2025

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

21 May 2025

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

followthecoffee.comConfiguring OCI IAM Domain JWTs to use with ORDS OAuth2.0 protected APIs – Follow the Coffee

21 May 2025

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

6 May 2025

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). 😁😎

2 May 2025

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.

oracle.comoracle.com

16 Apr 2025

ORDS 25.1 is now available for download: www.oracle.com/database/sql... And of course, you can check out the release highlights too: followthecoffee.com/ords-25-1-re... Give it a spin 😍 #newrelease #ords #oracledatabase #oraclerest #productupdate

thatjeffsmith.comSQL Developer for VS Code 25.1: Connection Folders are here!Oracle SQL Developer Extension for VS Code v25.1 is now available! This release includes the ability to organize your connections via folders (and subfolders!)

14 Apr 2025

I shouldn’t be this excited about flame-graphs. But I am. What does that say about me? I’m getting some rad retro vibes with this color palette 😍

Jeff Smith@thatjeffsmith.com

The latest update for our Oracle SQL Developer Extension for VS Code (25.1) is now available. Tons of new features and bug fixes included. www.thatjeffsmith.com/archive/2025... Next scheduled update will be June and 25.2.

rockauto.comRockAuto | All The Parts Your Car Will Ever NeedAuto Parts for Your Vehicle at Reliably Low Prices. Fast Online Catalog. DIY-Easy. Your Choice of Quality. Full Manufacturer Warranty.

12 Apr 2025

Oh, Rockauto.com is another of this “dated” feeling websites, but it feels super fast, and no nonsense! I will take a 2000’s-era looking site over a newer slow-ass “responsive” site any day.

chrishoina@chrishoina.bsky.social

Anybody who is doing front-end development would really appreciate this video youtu.be/-Ln-8QM8KhQ?... I like the idea of doing more server-side rendering too. I might have to dip my toes into the MLE/JS stuff.

youtu.beHow is this Website so fast!?YouTube video by Wes Bos

youtu.beHow is this Website so fast!?YouTube video by Wes Bos

12 Apr 2025

chrishoina.medium.comTroubleshooting: reviewing ORDS connections, your application server, and response timesSymptom/Issue

9 Apr 2025

Another quick heuristic for investigating connectivity, latency, and response times. Also, a good opportunity to learn more about ORDS and cURL 😍 Two options: 1: followthecoffee.com/troubleshoot... 2: chrishoina.medium.com/troubleshoot... #wednesday #learning #oraclerest #apis #troubleshooting

followthecoffee.com401 Unauthorized invalid_token – troubleshooting Oracle Cloud IAM JWTs with ORDS – Follow the Coffee

7 Apr 2025

Just a quick ORDS + JWTs PSA. This applies to Oracle's Identity and Access Management provided JWTs. Maybe you've experienced this "error=invalid_token" error too? Here is how to resolve it: followthecoffee.com/401-unauthor... #troubleshooting #oracle #restapis #oraclerest #apidevelopment #jwts

followthecoffee.comExample: an ORDS API that returns a user-configured JSON object – Follow the Coffee

3 Apr 2025

With this job, I learn and/or discover stuff on a daily basis. Seriously, it's insane. If you are bored with tech, it's surely your own doing! 🤪 My favorite times, however, are these "too-clever-for-our-own-good" solutions we come up with. Here is a fun one: followthecoffee.com/example-an-o...

31 Mar 2025

My girlfriend just asked me what I'm working on right now. And I responded with, "currently counducting an audit and subseqent culling of these inactive but open threads of this core application I'm using." Which is just a fancy way of saying, "closing out tabs in safari." #bethechange #hero #pm

followthecoffee.comA simple ORDS GET request using the Go language – Follow the Coffee

29 Mar 2025

I just added a go module to the directory, cleaned up some of the code, and added some comments too! Check it out :)

chrishoina@chrishoina.bsky.social

I think I might actually love Go 😍. @thatjeffsmith.com invited me along to an in-person customer presentation yesterday and while we were there one of the attendees asked if we had any ORDS + Go examples. Well, we didn't then...but WE DO NOW! #ords #oracle #go followthecoffee.com/a-simple-ord...