In the year 2000…
No, let me start over.
IN the year 2017, we have Oracle SQL Developer version 17.2. It started as Project Raptor in 2005. It’s got a pretty wide and deep feature set covering these areas:
- PL/SQL IDE
- SQL editor
- GUI for browsing and managing database objects
- Ad Hoc reporting
- Database Design & Data Modeling
- Database Administration
- 3rd Party RDBMS Migrations to Oracle
- Deploy and Administer Oracle REST Data Services
- REST Enablement of the Database
- Command Line Interface
Where do we have left to go?
A few predictions…
1. Even more DBA things
The last update saw support for Sharding and Data Guard. As SQL Developer is now fairly ubiquitous on the Oracle developer and DBA’s desktop, those users are asking for more and more feature support. And the Database team here at Oracle likes to work with us on bringing you new features and better access to existing features.
Right now we are doing some work on our Data Pump interface.
2. Did you say Cloud?
No? Well too bad, I said it 🙂
We’re working to extend the Cart so you can use it to load data to any Oracle Public Cloud Service that involves an Oracle Database. You’ll be able to drag and drop tables and files to a Cart, and then upload it to your Cloud Service, where the data will get loaded for you. I’ll have a lot more to say about this soon.
3. Speaking of Cloud…
SQL Developer WEB is still a thing. We’re very close to making it available for our Oracle Public Cloud Service customers.
We’re still deciding if this will be available for customers with on premises databases.
Customers that need to spin up a service and want to interact with it immediately from the database perspective will appreciate this interface versus figuring out how to download, install, and connect to their database with SQL Developer on their desktop.
4. More REST Stuff
We’re doing everything we can to make REST enabling your database with ORDS as easy and flexible as possible. That means that a good bit of GUI support in SQL Developer. We’ll continue along this track and keep adding stuff.
5. The Great Unknown
We have lots of side projects. Open-sourcing parts of the product. Creating a package manager for handling database changes for your applications. We have things we WANT to do. And sometimes those things get promoted to things we DO do – like Oracle SQLcl.
We’re still customer driven. We always will be. We’ll continue listening to you and looking at your requests from support, the forums, tweets, blog comments, and of course our Feature Exchange.
What’s not unknown is this –
Oracle SQL Developer isn’t going away. It’s going to continue to be included with your Database license (it’s free!). Our team will continue supporting it and building new stuff and enhancing existing stuff (the formatter!)
Stay tuned, we’ve got lots of cool stuff coming your way.