BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

JetBrains 0xDBE: A Tool for DBAs and SQL Developers

| by Abel Avram on Jun 10, 2014. Estimated reading time: 1 minute |

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

Rate this Article

Adoption Stage
Style

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

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT