BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

JetBrains 0xDBE: A Tool for DBAs and SQL Developers

by Abel Avram on Jun 10, 2014 |

Up until now, JetBrains’ IDEs have included plug-ins for dealing with database administration and development tasks. JetBrains has decided to extract the respective functionality and place it in an IDE of its own, namely 0xDBE.

0xDBE is an IntelliJ-based editor targeted at DBAs and developers working with SQL databases. Andrey Cheptsov, Product Manager for JetBrains, told InfoQ that 0xDBE works with the following databases: DB2, Derby, H2, HSQLDB, MySQL, Oracle, PostgreSQL, SQL Server, SQLite and Sybase.

Some of the most important features of 0xDBE are:

  • Code completion for foreign keys, alter statements, inserts
  • Parameter suggestions for values, functions and procedures
  • Symbol renaming in data source and SQL files
  • Finding symbols in data source and SQL files
  • Detecting errors in SQL code, offering the option to add unresolved table/columns to a data source
  • SQL Editor with multiple carets, toggled comments, etc.
  • Code formatting based on user-defined styles
  • Table Editor
  • Code navigation to declaration, symbol, etc.
  • Schema Editor that can be used to edit tables, indices, foreign keys, functions, procedures, etc.

0xDBE runs on Windows, OS X and Linux. Those interested can access the Early Access Program, while the GA is expected for the end of the year, according to Cheptsov.

When asked if 0xDBE will be enhanced to work with NoSQL databases, Cheptsov said that “NoSQL is also interesting for us, but SQL is the top priority for now.”

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT