Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Oracle SQL Developer: The Next Generation

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

thatjeffsmith

May 19, 2021
Tweet

More Decks by thatjeffsmith

Other Decks in Programming

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 [email protected] @btspendo github.com/Mmm-Biscuits [email protected]
  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 15 SQLcl: a

    CLI for the 21st Century • GraalVM , faster startups • Vi & Emacs support! • Status Bars • Highlighting
  15. 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!
  16. Copyright © 2021, Oracle and/or its affiliates 17 Charting and

    Visualizations • SQL to charts, easy! • Shareable • Next step, combine charts for dashboards
  17. 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!