Lightnews — Scholar-powered news

chrishoina @chrishoina.bsky.social · 13d

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

Oracle REST Data Services API

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

docs.oracle.com

chrishoina @chrishoina.bsky.social · 13d

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.

1

chrishoina @chrishoina.bsky.social · Sep 10

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 · Sep 10

🚀 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

New DEBUG flag simplifies troubleshooting ORDS container image issues

I 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…

martincarstenbach.com

2

chrishoina @chrishoina.bsky.social · Jul 25

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

chrishoina @chrishoina.bsky.social · Jul 3

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

chrishoina @chrishoina.bsky.social · Jul 3

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

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.

www.thatjeffsmith.com

1

chrishoina @chrishoina.bsky.social · Jul 1

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

1 7 8

chrishoina @chrishoina.bsky.social · Jun 7

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

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

www.linkedin.com

chrishoina @chrishoina.bsky.social · Jun 5

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

1

chrishoina @chrishoina.bsky.social · Jun 5

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

Astro

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

astro.build

1 1

chrishoina @chrishoina.bsky.social · Jun 5

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

Philipp Hartenfeller @hartenfeller.dev · Jun 5

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

Init podman on MacOS

Getting started with Podman on macOS for Oracle 23ai development

www.united-codes.com

1 1

chrishoina @chrishoina.bsky.social · Jun 5

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

1

chrishoina @chrishoina.bsky.social · Jun 5

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 😍

1 1

chrishoina @chrishoina.bsky.social · Jun 5

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.

1 1

chrishoina @chrishoina.bsky.social · Jun 3

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

Oracle REST Data Services (ORDS) command line interface. - Repository Detail

container-registry.oracle.com

chrishoina @chrishoina.bsky.social · Jun 3

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?

3

chrishoina @chrishoina.bsky.social · May 30

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

1

chrishoina @chrishoina.bsky.social · May 21

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

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

followthecoffee.com

1

chrishoina @chrishoina.bsky.social · May 21

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

1 1 1

chrishoina @chrishoina.bsky.social · May 21

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

1 1 1

chrishoina @chrishoina.bsky.social · May 6

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

1

chrishoina @chrishoina.bsky.social · May 2

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.

www.oracle.com

1 3

chrishoina @chrishoina.bsky.social · Apr 16

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

chrishoina @chrishoina.bsky.social · Apr 14

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 · Apr 14

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.

SQL 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!)

www.thatjeffsmith.com

chrishoina @chrishoina.bsky.social · Apr 12

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.