5+ million Oracle professionals use SQL Developer on a regular basis.

Our annual conference, formerly known as Oracle Open World, Oracle Cloud World is an opportunity for us to share news and announce upcoming projects and features. This year I spent a few moments teasing what’s next for Oracle SQL Developer.

Let’s recap the last 17 years

Previously on Oracle SQL Developer…

  • launched in 2005
  • a Java Swing application, built on the Oracle FCP
  • Fusion Client Platform, i.e. JDeveloper
  • ~5 million+ users worldwide
  • Billions of dollars saved for our customers

That’s a really, really nice ride for a software product and/or product platform.

But, every beginning eventually has an ending, and it’s time to consider what’s next for SQL Developer.

VS Codium enters the room

Visual Studio Code has become the de facto IDE for developers of all-types. And there’s a open-source distribution of that product that has none of the Microsoft branding or telemetry/tracking included.

Picking up Python was much easier with VS Code having such a nice developer interface.

Oracle SQL Developer Desktop lives on!

Leveraging our existing Java code base – why throw away 17 years of awesomeness, we’ll be able to give you a SQL Developer branded application with the same user experience you’re used to, but with a much more modern, and powerful underpinning.

The keyboard shortcuts will be there, you’ll have connections, object browsers, ability to run ad-hoc SQL, debug PL/SQL, manage your database, run SQLPlus-style scripts, and so much more.

Our parser and all of it’s goodies – the formatter, syntax highlighting, object completion, etc. will all be made available via VS Code’s Language Server Protocol (LSP).

A Quick Glimpse…

Next for Oracle SQL Developer
Yes, you’ll finally get your Dark Mode.

A list of connections on the left, a kick-butt editor on the right. Query results in a easy-to-use and navigate ‘grids.’ Pretty much what one would expect.

Some more fun, our context menus are there, single record view, SQLcl in the terminal…

What about my favorite feature?

Obviously porting 17 years of product to a new platform is going to take awhile. And decisions we made in 2009 won’t necessarily make sense in 2023. That being said, it will take us some time get to the point where the existing Oracle SQL Developer can be officially retired.

That means we may live in a world where you have 2 different desktop application options to choose from for a couple of years.

We’ve always been a community-driven product team. We’ve been working with you collaboratively since 2005. We know your expectations will be deservedly high. We look forward to hopefully meeting if not exceeding those.

When can I get it already?

Early 2023 is the game plan. Now, that might be an Early Adopter/Beta type of offering, but we want something you can download and start using and providing feedback on very soon!

If you want to keep up with news/updates and enjoy being teased be sure to follow us on Twitter (@oraclesqldev @krisrice @thatjeffsmith).

thatjeffsmith
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

10 Comments

  1. Avatar

    Hello,

    I come hère and I like the idea to have a SQL Dev plugin for Vscode, do you have a beta test 🙂

    Thank you for your job

    • thatjeffsmith

      We’ll do an internal beta here at Oracle, so come work for us if you want to participate!

      Then we’ll release product and do at least quarterly updates, aiming for Late Spring/Early Summer.

  2. Avatar

    Why do you abandon Java (which belongs mostly to Oracle) and start develping SQLdeveloper in something created by Microsoft???

  3. Avatar

    On OSD i can execute commands in two modes: Run Statement and Run Script. Will the “Run Script” mode use a separate SQLcl process? This means that statements will be executed in different sessions/transactions.

    • thatjeffsmith

      The execute as script flow will continue using the ‘worksheet connection,’ however having multiple, threaded connections will be a thing, AND you’ll have the option to open SQLcl in the terminal as well if you want complete ‘independence.’

  4. Avatar

    Any new improvements to Data Modeler ? We’d like to see source to target mappings in like in Erwin or PowerDesigner.

  5. Avatar
    Rahul Puttagunta Reply

    This is a huge development. Where can I get alpha/beta access to pronto? I would like to start using this and giving feedback.

Write A Comment