An APEX app which demonstrates the power of server-side JavaScript via MLE & GraalVM

Download app.sql, and import it into an APEX 20.2 instance, on an Always Free 21c DB.

To be able to run the examples, navigate to the Modules page and create extermal modules for the following libraries. On save, the actual code will be downloaded automatically.

You will notice an application process called Setup MLE that runs After Page Submission. This process exposes 2 global helper functions: requireModule and loadScript. Based on a module name, these functions will fetch the CLOB code out of the MLE_MODULE table and execute it. We can then use these functions in After Submit computations, validations, processes etc.

• requireModule is meant to be used with CommonJS (Node JS-like) modules. Example var qrcode = requireModule('qrcode');
• loadScript simply loads the script as is (IIFE or Browser-like). Example loadScript('text-encoding');

Some libraries are bundled in such a way that either way of loading will work. Some libraries on the other hand might need extra wrapping.

Some libraries can be used without a hitch (see validator). Some libraries need extra attention (see dompurify).

If a library is meant to be used in node-js, you might have to "browserify" it. If a library is meant to be used in the browser, it might just work (validator), you might have to fake things like setTimeout or window (jimp), or you might have to fake a browser environment altogether (dompurify)

I am confident however that this process will get better with time, as MLE progresses, and more developers come up with better ways to bundle and ship libraries.