Search

Top 60 Oracle Blogs

Recent comments

JavaScript

SQL, PL/SQL and JavaScript running in the Database Server (Oracle MLE)

In a previous post I measured the CPU usage when running a database transaction in the same engine (SQL), or two engines in the same process (PL/SQL + SQL or JavaScript + SQL) or two processes (Javascript client + server SQL):

ODC Appreciation Day : Reduce CPU usage by running the business logic in the Oracle Database

For the JavaScript + SQL running in the same process, I used the Oracle Multi-Lingual Engine in beta 0.2.7 but there is now a new beta 0.3.0 and this post runs the same (or similar) with this.

I’ve installed this MLE in a previous post:

Oracle Multi-Lingual Engine

PI-Day example

Here is a very quick and easy test of the Oracle MLE, the engine that let you run JavaScript or Python stored procedures in the Oracle Database (currently in beta).

The MLE beta is provided as a docker image containing the Oracle Database 12.2 with the additional MLE libraries. I have created a VM on the Oracle Cloud in order to test it and show an end-to-end demo on Oracle Linux 7.

Get software

Here is where to download the database server with MLE beta:

Oracle Database MLE Download

and the SQLcl client

SQLcl Downloads

ODC Appreciation Day: Reduce CPU usage by running the business logic in the Oracle Database

A new blog post on the Databases at CERN blog to think about:

Where to run business logic: in the database or another tier?

What language for coding business logic: SQL, PL/SQL, JavaScript?

Guess how to reduce licensing costs? https://db-blog.web.cern.ch/blog/franck-pachot/2018-10-odc-appreciation-day-reduce-cpu-usage-running-business-logic-oracle

ODC Appreciation Day : Reduce CPU usage by running the business logic in the Oracle Database

Oracle Database Multilingual Engine (MLE)

My ODC appreciation blog post was about Javascript in the database running in the beta of the Oracle Database Multilingual Engine (MLE). Here I’ll detail my first test which is a comparison, in performance, between a package written in Javascript, running in the MLE, and one written and running in PL/SQL.

Girls Develop It Weekend Adventures- Intro to Javascript

Even though I didn’t have the “official” prerequisite classes of HTML and CSS for the JavaScript class offered by sister Meetup group, Girls Develop it, I decided on Friday that I wanted to take the weekend class and signed up.