- 3,715,704 Users
- 2,242,836 Discussions
- 7,845,502 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 467 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 3 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 416 SQLcl
- 42 SQL Developer Data Modeler
- 184.9K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 8 DevOps
- 3K QA/Testing
- 248 Java
- 5 Java Learning Subscription
- 10 Database Connectivity
- 66 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 10 Español
- 1.9K Japanese
- 2 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