- Powered by
- WordPress
-
Creating a GraphQL endpoint … within the database
GraphQL is protocol agnostic. Most GraphQL is served via HTTP, but there is nothing wrong with a different format. Why not put a GraphQL endpoint into the database? This post shows you how to do that.
-
Fetch()-ing GraphQL data in MLE/JavaScript
This post demonstrates how to use the new GraphQL endpoint ORDS provides in MLE/JavaScript. The first part covers the basics, the second one details the use of the graphql.js module.
-
SQLcl: new lb generate-schema option to overwrite files
I have written a lot about SQLcl’s Liquibase integration because I’m a great fan of it. One of the things it allows me to do is to generate the changelog for an entire schema. I’m using that a fair bit as part of schema migrations. Liquibase follows the delta approach, where a change depends on…
-
SodaDocumentCursor is iterable in node-oracledb 6.4 👏
-
Ad-hoc MLE JavaScript in Oracle AI Database 26ai: Database Actions
A short post describing how to use Database Actions to run some ad-hoc JavaScript code
-
Ad-hoc MLE/ JavaScript execution in Oracle Database 23ai: DBMS_MLE
Occasionally it makes sense to run In-Database JavaScript code in an ad-hoc fashion. You typically do that to test something before wrapping the JavaScript code into a module. There are many ways to achieve this goal: using DBMS_MLE directly (this article) using APEX’s SQL Workshop using Database Actions This post demonstrates how to use DBMS_MLE…
-
Ad-hoc MLE JavaScript in Oracle Database 23c: APEX
-
Using server-side JavaScript in APEX processes
Before you can use the MLE module you have to create an MLE environment first. Still in the object browser, create a new MLE env and name it TIMEKEEPING_ENV. Assign timekeeping as the import name, pointing to the TIMEKEEPING_MODULE you just created. The final step is to assign the newly created environment to the APEX…
-
More fun while coding: local dev-environment for MLE, Oracle Database 23c Free
The recent release of the SQL-Developer extension for VSCode (Visual Studio Code) closes a gap for anyone developing server-side JavaScript code for Oracle Database 23c. And everyone else of course who always wanted to use VSCode for database development. And dark mode. The SQL Developer extension allows you to stay within a single IDE to…
-
Using MLE JavaScript modules for APEX validations
