PL/SQL vs. JavaScript in the Oracle Database 23c
Presentation on 18th November 2023 at POUG 2023, Warsaw
Since Oracle Database version 21c, you can execute JavaScript dynamically with the help of DBMS_MLE. Starting with version 23c, JavaScript modules can be used to process data with JavaScript according to the SmartDB paradigm in the database.
By adding JavaScript to the Oracle Database, we can use existing JavaScript libraries in the database, and we make it easier for those without PL/SQL knowledge to get started with database development.
Wasn't that already the argument for Java in the database? What is now easier and better with JavaScript? When is JavaScript a good alternative to PL/SQL and when rather not?
In this talk, I will answer these questions with the help of examples and position PL/SQL as well as JavaScript in database development.
00:16 PL/SQL vs. JavaScript in the Oracle Database 23c
00:52 Why Do We Need Code in the Database?
04:30 Programming Languages in the Oracle Database
04:34 - C (Version 8.0)
05:14 - PL/SQL (Version 7.0)
06:22 - PL/SQL - Without Data Processing (DML)?
07:39 - Java (Version 8.1)
08:26 - Java - Using 3rd Party Libraries
10:08 - Permissions (Network, Filesystem, ...)
10:30 - Dynamic JavaScript (Version 21)
12:18 - Static JavaScript (Version 23)
13:09 - SQL in JavaScript
14:41 - JavaScript - 3rd Party Libraries
16:53 - JavaScript - MLE Module Manager
17:59 - Validator Documentation for isEmail "options"
18:38 - JavaScript - Importing MLE Modules
19:46 - JavaScript - MLE Environments
20:31 - Overview of Languages in the Oracle Database 23c
21:01 How Many JVMs Are in the Oracle Database?
21:08 - Java - Full JVM as Part of the DB (Option)
21:25 - MLE - Native Image as Part of the DB
22:07 Comparing Performance & Resource Usage
22:41 - Runtime of First Call After DB Restart
23:19 - Runtime of First Call in New DB Session
23:53 - Max. Memory Usage after Single Call
25:21 - Runtime of 100'000 Calls of to_epoch
27:14 - Runtime of 100'000 Calls of salary_increase
28:46 Good Security Practices & Default Exceptions
28:58 - Binds & Assertions
30:25 - Assert in JavaScript
31:33 - Get Missing Error Stack
32:32 Development & Tooling
32:45 - Development Tools
34:00 - IntelliSense in VS Code
34:47 - Debugging in VS Code
35:37 - MLE Post Execution Debugging
36:33 - Debugging in Database Actions
37:31 Key Messages
37:37 - Pros & Cons
40:24 - Is Tom Kyte's Mantra Still Valid?
42:24 - Welcome JavaScript in the Oracle Database
Auf dieser Seite können Sie das Online-Video PL/SQL vs. JavaScript in the Oracle Database 23c mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Philipp Salvisberg 24 November 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 130 Mal angesehen und es wurde von 4 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
