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