JetBrains Previews IDE For SQL
JetBrains Previews IDE For SQL
Written by Kay Ewbank   
Friday, 30 October 2015

The team at JetBrains has announced a preview version of their new IDE for developers who work with SQL and databases. The final version will be released in mid November as a part of JetBrains Toolbox.

The preview version of 0xDBE 1.0 is described as nearly finished, and other good news is that 0xDBE is not the final name of the product and will be changed. It is designed to support a wide range of database platforms:

sqlidefor

 

The product is a combination of an intelligent SQL editor and collection of database tools packed together and running on top of the IntelliJ platform. The package provides coding assistance including schema-aware completion, on-the-fly code analysis and quick-fixes, search, navigation, and refactoring. The code completion is based on the context and schema constraints, with foreign-keys-aware completion; alter-statements-aware completion; Insert statement completion; and parameter suggestion for values, functions and procedures.

 

sqlide

 

The software detects probable bugs in your SQL code and suggests the best options to fix them on the fly. It will add unresolved tables or columns to a data source. It will also create table or column definitions for unresolved symbols. There’s a table editor that you can use to browse and modify data. It lets you navigate by a foreign key, find usages by a primary key, and view the data transposed by rows.

0xDBE provides unified support for major version control systems including Git, SVN, and Mercurial. It can be used to manage schemas, letting you change tables, columns, indicies, keys, and stored procedures.

The product has been in a private invitation only preview until now, but the latest version is available for public preview. This update has faster and more accurate schema introspection. The way the IDE fetches meta information about database objects has been reworked, and the developers have extended the JDBC-based introspection for all supported database engines to make it more native, accurate and fast.

The preview can be downloaded for testing ahead of the mid-November launch. At that point it will be available as part of JetBrains Toolbox with a monthly or yearly subscription plan. The adoption of this new revenue model met with such a negative reaction from JetBrains existing customers when it was announced in September that the company had to make concessions in the form of a perpetual fallback license so that having paid for software you won't ever lose access to it if you con't continue to pay. 

JetBrains presumably hopes to gain new customers by including products like this that extend the functionality of the Toolbox.

sqlidesq

More Information

Download OxDBE 1.0 Preview

Related Articles

JetBrains Toolbox - An Unwelcome Change

JetBrains Responds To Backlash 

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin.

 

Banner


Google Starts Its Push To Progressive Web Apps - Bye Bye Chrome Apps
06/12/2017

Google has removed Chrome apps from the Chrome Web Store and has made it clear that Progressive Web Apps are what you should move to. There is a lot that is unclear about all of this and, apart from a [ ... ]



Alexa For Business - The Big Shake Up
05/12/2017

Having consolidated its dominance of the home consumer market for voices assistants, Amazon is bringing Alexa's capabilities into the enterprise market with Alexa for Business.


More News

 

 
 

 

blog comments powered by Disqus

Last Updated ( Friday, 30 October 2015 )
 
 

   
Banner
RSS feed of news items only
I Programmer News
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.