- Powered by
- WordPress
-
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
-
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 Database 23c: 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: This post demonstrates how to use DBMS_MLE for ad-hoc JavaScript execution. The package is documented in the JavaScript Developer’s…
-
Ad-hoc MLE JavaScript in Oracle Database 23c: APEX
Martins Blog 