- Powered by
- WordPress
-
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
-
Creating a GraphQL endpoint … within the database [redux]
$ sql emily@localhost/freepdb1SQLcl: Release 24.1 Production on Thu Jun 06 10:33:37 2024Copyright (c) 1982, 2024, Oracle. All rights reserved.Password? (**********?) Connected to:Oracle Database 23ai Free Release 23.0.0.0.0 – Develop, Learn, and Run for FreeVersion 23.4.0.24.05SQL> select 2 json_serialize( 3 graphql_query( 4 ‘query locById($id: Int) { getLocationById(id: $id) { city country_id } }’, 5 JSON(‘{id: 1000}’)…
-
Simplified TDE configuration in Oracle Database 23ai Free
The newly published Database 23ai RPM provide a new configuration option named CONFIGURE_TDE. Setting it to true creates a new database with TDE enabled in united mode.
-
Cloning PDBs with TDE enabled just got a lot easier with ORDS