Oracle SQL Developer: The Next Generation

Overview of our Oracle Database Tools, their history, and where we're going in the near future.

Includes quick overview of SQL Developer Web and SQLcl.

Video replay available here -
https://youtu.be/FePk0GNE4f4

Transcript

1. Copyright © 2021, Oracle and/or its affiliates 1 SQL Developer: The Next Generation Number One & Number Two J eff Smith & Brian Spendolini Copyright © 2021, Oracle and/or its affiliates 1 @thatjeffsmith www.thatjeffsmith.com jeff.d.smith@oracle.com @btspendo github.com/Mmm-Biscuits brian.Spendolini@oracle.com
2. Copyright © 2021, Oracle and/or its affiliates 2 Our 16 year Mission... Explore strange new databases Seek out new platforms and applications To boldly go where SQL*Plus never went before Copyright © 2021, Oracle and/or its affiliates 2
3. Copyright © 2021, Oracle and/or its affiliates 3 SQL Developer launches in 2005 • SQL scratchpad • PL/SQL IDE • Schema browsing • Database Administration • Data modeling • REST • 3rd party DBMS migration to ORCL • TimesTen, Data Miner, OLAP, ... https://www.oracle.com/sqldeveloper Used by over 5 million database pros
4. Copyright © 2021, Oracle and/or its affiliates 4 From Raptor to SQLDev • ~ 3 weeks experiment yielded Project Raptor • Launches publicly in December of 2005 • Officially released as Oracle SQL Developer • J ava Desktop (Swing) Application • Based off Fusion Client Platform (FCP) • SQLDev contributes back to J Dev for Database Features • $Billions$ saved for customers on 3rd party licensing
5. Copyright © 2021, Oracle and/or its affiliates 5 SQL Developer Data Modeler • Industry leading design tool • Logical and Relational • ERDs • SVN & Git integration • Reporting • DDL Generation • Compare and Synch https://www.oracle.com/database/technologies/appdev/sql-developer.html
6. Copyright © 2021, Oracle and/or its affiliates 6 Brought into SQLDev family in 2009 • Initially sold per user, made FREE by LJ E • Separate standalone application • Also avail as a SQL Developer extension • CLI Support added in 2020
7. Copyright © 2021, Oracle and/or its affiliates 7 Oracle REST Data Services • Microservices for your Oracle Database • Declaratively defined using SQL, PL/SQL • Define via PL/SQL API, SQL Dev or APEX • Auto REST enable tables and views • Create custom REST services • Document Store (SODA for REST) • Database Management REST APIs • REST Enabled SQL https://www.oracle.com/rest HTTPS Results JSON SQL Meta Data Repo
8. Copyright © 2021, Oracle and/or its affiliates 8 APEX Listener to all things REST • Could MOD_PLSQL be modernized, updated via J ava? • 2 weeks to get a working PoC • Rebranded as Oracle REST Data Services • Responsible for top internal and Cloud applications @ Oracle
9. Copyright © 2021, Oracle and/or its affiliates 9 SQLcl • Modern command-line interface • Auto complete SQL syntax • Command history • J SON, CSV, INSERT, X ML, etc output • Liquibase schema lifecycle integration • Scripting friendly • No Oracle Home required • OCI & OSS Integration https://www.oracle.com/database/technologies/appdev/sqlcl.html SQL Command Line
10. Copyright © 2021, Oracle and/or its affiliates 10 Want: better platform for Scripting • Launches in 2016 • Desire for better control flow led to support for J avaScript • No SSO/Click-through for downloads as of MAY 2021 • Makes CI/CD for Oracle, REST, APEX possible • Coming later in 2021 • vi/EMACS editor support • Improved insight/code completion • GraalVM native image
11. Copyright © 2021, Oracle and/or its affiliates 11 Database Actions • Your favorite tool, in the browser • Load Data (csv, json, xml) • Run SQL statements & scripts • Monitor and manage your DB • Schema diagramming • REST development interface • J SON Document Store (SODA) https://www.oracle.com/rest
12. Copyright © 2021, Oracle and/or its affiliates 12 Formerly SQL Developer Web • Build for 1st gen Oracle Cloud in 2018 • Made available for all customers in 2019 • Primary interface for Autonomous Database • Our new flagship platform
13. Copyright © 2021, Oracle and/or its affiliates 13 Commons Library is our Dilithium • SQLcl, SQLDev, ORDS, Modeler - common code base • Parser, code formatting, statement execution, data exporting, connection logic, data importing, etc - written ONCE, used multiple times • Could come in handy to port Database Actions to Desktop app (Electron) or • SQLcl as a extension to VS Code??
14. Copyright © 2021, Oracle and/or its affiliates 14 SQLcl: a CLI for the 21st Century DEMO TIME!
15. Copyright © 2021, Oracle and/or its affiliates 15 SQLcl: a CLI for the 21st Century • GraalVM , faster startups • Vi & Emacs support! • Status Bars • Highlighting
16. Copyright © 2021, Oracle and/or its affiliates 16 Worksheet for any DB in OCI! • Define and reuse connections to any DB in OCI • Launch SQL worksheet, change db as you wish • Much more to come!
17. Copyright © 2021, Oracle and/or its affiliates 17 Charting and Visualizations • SQL to charts, easy! • Shareable • Next step, combine charts for dashboards
18. Copyright © 2021, Oracle and/or its affiliates 18 Later this Century... • Transwarp capabilities • SQL Developer Web adds - • File based PL/SQL Dev / Source Control / CI & CD • Data Pump • Automatic Indexing • ASH / AWR / ADDM • You tell us!