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.

4 Comments

  1. Avatar

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

  2. 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