Martins Blog

Powered by
WordPress

  • 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: When storing JSON as a database column Performing type conversions as part of JSON functions like JSON_QUERY, etc. Let’s…

  • 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: When storing JSON as a database column Performing type conversions as part of JSON functions like JSON_QUERY, etc. Let’s…

  • 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

  • With-clause, values operator and a strange JSON_TABLE error

    A short tale of investigating a problem with JSON_TABLE, common table expressions and the value operator in Oracle Database 23ai

  • Containers are awesome, not only for stateless things

    This post describes why using containers, even for database driven applications, is very useful.

  • Loading MLE modules into the database got a lot easier with SQLcl 24.3.2

    Oracle AI Database 26ai running on Linux x86-64 and aarch64 allows you to write server-side JavaScript code, stored and executed directly within the database. Multilingual Engine (MLE), powered by GraalVM makes this possible. Developers can write their JavaScript modules in a way that is very similar to how PL/SQL developers write functions, procedures, and packages.…