Martins Blog

Powered by: WordPress

Jump-start developing APEX apps using MLE/JavaScript: Autonomous Database
What’s new in Multilingual Engine 23.5: support for sql-template-tag

New features are introduced to JavaScript/Multilingual Engine (MLE) in Oracle Database 23ai constantly, even though they might not always be end-user visible. With the availability of Release Update 5 (Oracle Database 23.5.0) and later, a few important changes worth reporting have made it, and you can use them, too :) This blog post demonstrates how to…
Create MLE/JavaScript modules using Liquibase

Multilingual Engine, or MLE for short, allows developers to use the hugely popular JavaScript language to write server-side code with Oracle Database 23ai. With the introduction of MLE in Oracle Database 23ai you have 3 languages available to store business logic alongside the data: Background and Motivation Backend developers frequently use tools to deploy their…
Configuring a custom location for biomejs in VSCode

Biome is one of my favourite JavaScript development tools. It comes with an extension that integrates nicely with Visual Studio Code, currently my editor of choice. The VSCode extension assumes that Biome is present at the project’s root directory, which is fine most of the time. There are some occasions though when that’s not the…
How to check if Multilingual Engine is available in APEX 24 and later

This is a short post describing how you can check if your APEX installation supports Multilingual Engine (MLE)/JavaScript. APEX makes it very easy for developers to use MLE: when you create a new workspace you have the option to let APEX create a new schema for you, or use an existing one. Should you decide…
Enabling the MongoDB API for ORDS containers just got a lot easier

Oracle recently published a new container image for running Oracle REST Data Service (ORDS). The new image externalises the ords binary pretty much in the same way you’d use ORDS locally except you don’t need to install its dependencies. This sounds as cool as it is abstract, so let’s see how this works in action. NB: the…
Using sqlcl/Liquibase for administrative tasks
Advanced ORDS REST handlers written in JavaScript

There you go! In addition to using all the modules built into MLE you can also refer to your own. The new feature is documented in the ORDS Developer’s Guide, which contains a handy reference. Happy coding!
Installing Xfce on Oracle Linux 9

This post describes how to install
Matching the start-with value of an identity column with table data