Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
A MLE v1 beta testing guideline

Thank you for taking the time to beta test the Oracle Database Multilingual Engine!
In this first beta test we offer the capability to write JavaScript stored functions which can be called from SQL queries. We would like testers to focus at this stage on the integration between writing JS functions and execute them in SQL statements as well as the capabilities of loading third party packages from npm and using those directly within your SQL. Some of the questions, but not exclusively, we want users to take a look at, are:
- Is it easy to write JS functions and use them in SELECT, WHERE clauses, sub selects, INSERTs, etc.
- Is it easy to write JS functions with more sophisticated parameters (more than one, different data types, etc)
- Is it easy to write SQL within JS functions to get and put data from and into the database
- Is it convenient to load npm packages, also when they require other npm packages
- How easy is it to load multiple npm packages in your JS function
- Do you think you would be allowed loading third party open source packages into a production database in the first place?
- Do you like the way how you have to declare your functions today, what can be done better, etc.
Please note that taking a close look at the performance comparison between PL/SQL and MLE is premature in this first beta. A lot of integration points for MLE haven't been provided yet in this beta version and hence give it in some cases a clear performance benefit and in others a clear downside. Although MLE can offer a lot of benefits going forward this beta version is yet to soon to draw conclusions on performance numbers.
We really appreciate all the testing efforts and what has been done already and certainly those are already very good insights!
Thanks everybody,
Gerald
Comments
-
Hi Gerald,
The download page provides both an ova file (Virtual Box) and a Docker Image. There are no instructions on how to make use of the Docker file - how to run it, how to access documentation in it, etc. Can you clarify how the Docker download can be used?
kind regards
Lucas
-
Hi Lucas,
I have created a separate thread where I wrote some guide based on my trial-and-error journey.
Maybe it helps you and others with more knowledge can also help me improve it.
Regards,
Moritz