This page contains all of my posts belonging to the Linux category in chronological order.
Self-Signed Certificates with ORDS 26.1 on rootless podman
Oracle REST Data Service (ORDS) has recently been updated to release 26.1.0. This is a great opportunity to write a short blog post covering how to use (self-signed) certificates with the container image on rootless podman. Create the certificate The first step is to create the self-signed certificate. You can ignore this step if you…
Avoiding precision loss with MLE/JavaScript in Oracle AI Database 26ai
Oracle AI Database 26ai introduced Multilingual Engine (MLE), allowing you to run JavaScript inside the database. This feature bumps the number of languages available to write server-side code to 3: PL/SQL, Java, and now JavaScript. JavaScript is a modern language with many interesting features and data types, but there are things worth knowing. Number arithmetic…
Using the operating system’s certificate store in Oracle Database 19c
I previously wrote about Using the Operating System’s certificate store instead of an Oracle wallet in Oracle AI Database 26ai. This is a great productivity boost, and it all comes down to this: if the operating system trusts a HTTPS certificate, so does the database. Before jumping into the examples, it’s worth highlighting an important aspect:…
Adding self-signed certificates to a wallet became a one-liner in SQLcl 26.1
Before Oracle AI Database 26ai, anyone wanting to make a REST call from the database to an external service needed the external service’s certificate chain to be present in a wallet. The same applied to any other network call. This situation has greatly improved: Oracle Database releases 19c and 26ai trust the operating system’s certificate…
Life hack: causing utPLSQL to raise an error in case of failed tests
The wonderful Symposium 42 community is always a source of inspiration, kindness and willingness to help. Many thanks to everyone for lending me an ear while ranting about utPLSQL (tongue in cheek of course). This post is for you. Unit Testing and PL/SQL utPLSQL is the most prominent unit test framework for PL/SQL as far…
Real productivity gains with AI: coding unit tests for your ORDS endpoints
Ever since I first heard about them, I have become a great fan of unit tests, Test-Driven-Development, and CI/CD in general. Whenever I can, I incorporate these into my demos. I wrote a fair bit about these topics in Implementing DevOps Principles with Oracle Database, if you’re curious to learn more, head over to the…
Using JSON Schema to validate data submitted to the database via REST Calls
The title’s a mouthful (sorry!), but here’s the core idea: your application exposes REST endpoints through Oracle REST Data Services (ORDS). When a client uses POST to insert new records, the input arrives as JSON since JSON is the data exchange format du jour. Every developer on the planet knows that you shouldn’t blindly accept…
Augmenting JSON Relational Duality Views with generated data
A recent forum post inspired this brief article on generating summary data in JSON Relational Duality Views. Typically you map a table’s columns to fields in the resulting JSON. If you can’t use a 1:1 mapping in your Duality View for any reason, it is possible to augment the Duality View with generated fields. Let’s…
Handling Query Parameters in JavaScript-based ORDS Endpoints
Oracle REST Data Services (ORDS) allows you to REST-enable your Oracle Database. REST is short for Representational State Transfer, and REST calls are typically used as your database API (Application Programming Interface). Instead of accessing the database directly via a driver SDK, you use HTTP calls instead. There is of course a lot more to…
What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 3
Oracle AI Database has been released! It ships with a whole raft of cool new features, including some the Multilingual Engine (MLE) team integrated for JavaScript. This article discusses one of them, support for PL/SQL Records and Collections. This is a rather wide topic, which is why you find the article broken into a small…
Something went wrong. Please refresh the page and/or try again.
Martins Blog 