JetBrains Announces 0xDBE An IDE For SQL
Written by Kay Ewbank   
Tuesday, 10 June 2014

0xDBE has been designed to suit the specific needs of professional DBAs and developers. It has an intelligent SQL editor, schema management, version control integration and other database tools all running on the IntelliJ platform.

The package is mainly the database tools from the other JetBrains IDEs put together in their own separate IDE. The suite is still under development, but a private EAP (Early Access Program) has just been announced and you can sign up for it.

The code completion element of the IDE includes foreign-keys-aware completion, alter-statements-aware completion, and Insert statement completion:

(click for larger image)

database completion 4

There’s a find and rename command that resolves all table and column references over your SQL files so you can rename any symbol and its usages. You can rename symbols in both data sources and SQL files:

 (click for larger image)

database refactoring

 

An option to analyze code will detect probable bugs in your SQL code and suggests the best options to fix them on the fly, with options to add unresolved tables or columns to a data source, and to create tables and column definitions for unresolved symbols.

Alongside the SQL specific coding assistance the IDE also inherits other features from the IntelliJ Platform, including multiple carets and structural selection. The editor lets you make multiple selections, select words, and toggle comments. You can also choose the formatting style for your SQL code and have it formatted automatically. There’s a built-in table editor that can be used to browse and modify data, and that can show data or navigate by a foreign key, find usages by a primary key, and display your data in a transposed row view.

The schema management options let you create and modify schema objects including tables and columns, indices, foreign keys, functions and procedures for all supported databases. The supported databases list includes Oracle, MySQL, PostgreSQL, Sybase, IBM DB2, SQLite, Microsoft SQL Server, HyperSQL, Apache Derby, ODBC, and H2. 0xDBE supports the major version control systems (Git, SVN, Mercurial, Perforce, and many others according to the overview).

More Information

0xDBE

Related Articles

IntelliJ IDEA 13 Released

SQL Prompt - An Add-In To Aid Productivity

PostgreSQL Studio Released

MySQL Workbench 6.0 Released

SQL Fiddle

 

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

 

Banner


Google Code-In 2014 Announced
08/10/2014

Now in its 5th year Google Code-In is an opportunity for pre-university students aged between 13 and 17 to have an experience of real world coding and making a contribution to an open source proj [ ... ]



Windows Not 9 But 10
01/10/2014

The next version of Windows has just been presented to the world and  the biggest surprise is that it is to be called Windows 10 rather than the more logical Windows 9.


More News

 

blog comments powered by Disqus

Last Updated ( Tuesday, 10 June 2014 )
 
 

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