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]

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

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

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

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

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

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

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

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

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

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

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

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??

Copyright © 2021, Oracle and/or its affiliates 14 SQLcl: a CLI for the 21st Century DEMO TIME!

Copyright © 2021, Oracle and/or its affiliates 15 SQLcl: a CLI for the 21st Century • GraalVM , faster startups • Vi & Emacs support! • Status Bars • Highlighting

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!

Copyright © 2021, Oracle and/or its affiliates 17 Charting and Visualizations • SQL to charts, easy! • Shareable • Next step, combine charts for dashboards

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!