Martins Blog

Powered by
WordPress

  • JSON strict and lax syntax in Oracle Database | Pt 3: Type Conversions (SQL functions)

    A recent forum post prompted me to look into JSON syntax rules and their implications more closely. The way I read the JSON Developer’s Guide, there are two aspects to the topic of lax and strict JSON: Let’s look at the second aspect: type conversion. This post concerns Oracle Database 23ai and JSON SQL functions. Here…

  • Oracle Cloud Infrastructure: establish a console connection to a Windows compute VM

    You may occasionally run into issues with a Windows 2022 (or later) compute VM in Oracle Cloud Infrastructure (OCI) that require you to access the VM via the graphical recovery console. This article describes how to connect to a graphical recovery console, based on VNC using MacOS 15.3 Sequoia. The latest MacOS 15.3 ships with OpenSSH_9.8p1/LibreSSL 3.3.6. It…

  • SQLcl introduces support for Rollup.js to load MLE modules

    Thanks to the awesome team developing new features for Oracle SQL Developer Command Line creating modules for Multilingual Engine (MLE) just got a lot easier. SQLcl 24.3.2 introduces the mle create-module command allowing you to create a MLE module from a file in the directory. I blogged about the feature in the past. SQLcl 24.4.1 raises the bar even further. Background A…

  • JSON strict and lax syntax in Oracle Database | Pt 2: Type Conversions (dot notation)

    A recent forum post prompted me to look into JSON syntax rules and their implications more closely. The way I read the JSON Developer’s Guide, there are two aspects to the topic of lax and strict JSON: Let’s look at the second aspect: type conversion. This post concerns Oracle Database 23ai and the simple dot access…

  • Less-well-known features of Multilingual Engine: Document API

    Many developers like the simplicity and flexibility provided by specialised document databases. These systems offer a lot of freedom when it comes to writing applications. If you don’t like SQL, a document API provides another way to persist data. There is no better or worse approach. Developers should be empowered to use the technology they are most comfortable with…

  • What’s new in Multilingual Engine 23.7: Fetch Type Handler Support

    The availability of Oracle Database 23ai Release Update 7 marks the introduction of several new features for Multilingual Engine (MLE) and JavaScript. As always, you can find the details in Oracle’s JavaScript Developers Guide and the MLE Module API documentation on GitHub. This post demonstrates the use of Fetch Type Handlers. Fetch Type Handlers have been part of node-oracledb since…

  • JSON strict and lax syntax in Oracle Database | Pt 1: Storing JSON

    A recent forum post prompted me to look into JSON syntax rules and their implications more closely. The way I read the JSON Developer’s Guide there are two aspects to the topic of lax and strict JSON syntax: Let’s look at the first of these – storing JSON – before diving into type conversions in a future…

  • Use Flashback Time Travel with Autonomous Database

    This is a very short post, mainly for my own benefit, to summarise how to use Flashback Time Travel (previously named Flashback Data Archive or Total Recall) in Autonomous Database 23ai – Serverless (ADB-S from now on). At the time of writing the database was patched to Release Update 7: SQL> select 2 version_full 3…

  • What’s new in Multilingual Engine 23.7: Foreign Function Interface

    The availability of Oracle Database 23ai Release Update 7 marks the introduction of a number of new features for Multilingual Engine (MLE) and JavaScript. As always you find the details in Oracle’s JavaScript Developers Guide and the MLE Module API documentation on GitHub. This post demonstrates one of the most exciting features: the Foreign Function Interface, or FFI…

  • Node-express MLE/JavaScript example

    A short post demonstrating how to use node-express and Oracle’s Multilingual Engine (MLE) in Release 23ai