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
Nesta página do site você pode assistir ao vídeo on-line PL/SQL vs. JavaScript in the Oracle Database 23c duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Philipp Salvisberg 24 Novembro 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 130 vezes e gostou 4 espectadores. Boa visualização!
