Martins Blog

Powered by
WordPress

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

  • Your local development environment: Oracle Database 23ai Free on WSL2

    Recently I posted a few tweets about my experience developing on windows. That’s something new to me, typically I’d use either Linux or MacOS. Some of you wanted to know how that went, so … here’s the story. In preparation for my talk about Continuous Integration/Delivery (CI/CD) and the pending update of my “DevOps with…

  • Avoiding MLE/JavaScript pitfalls: the requested module does not provide an export named ‘default’

    Oracle Database 23ai saw the introduction of JavaScript as an additional language for writing server-side code. As with PL/SQL, it is possible to separate JavaScript code into separate units. This concept is similar to PL/SQL where you group code logic into packages. In JavaScript, these code units are called modules. Just as with PL/SQL, you…

  • Troubleshooting the Oracle Cloud Infrastructure API

    Sometimes, it can be interesting to learn how the Oracle Cloud Infrastructure (OCI) API works, particularly if your favourite Internet search engine fails to locate the exact syntax of an API call. This is typically due to unspecific search terms because the OCI CLI is really well documented, but those things happen. I would like…

  • Enable the MongoDB API on Always-Free Autonomous Database

    Oracle Database API for MongoDB translates the MongoDB wire protocol into SQL statements that are executed by Oracle Database. It lets developers who have MongoDB skill sets write JSON document-store applications for Oracle Database that use drivers and tools that understand the MongoDB protocol – which is way cool! If you would like to get…

  • What’s new in Multilingual Engine 23.5: Operator Overloading

    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 introduces improvements to the…

  • Starting Oracle Database 23ai Free at boot time

    This question has come up in the forums recently and it’s a good reminder to post a short article how to ensure that your Oracle Database 23ai Free instance starts automatically with your Linux virtual machine. This post is relevant to you if you: In that case, please read on! This post is not applicable to Oracle Database Enterprise…