0xDBE Becomes DataGrip
0xDBE Becomes DataGrip
Written by Kay Ewbank   
Friday, 18 December 2015

JetBrains has released DataGrip, an IDE for databases and SQL. 

 

DataGrip has been doing the rounds in an Early Access Program under the name of 0xDBE. It has now been released and renamed, and is a combination of an intelligent SQL editor and collection of database tools packed together and running on top of the IntelliJ platform.

datagriplogo

The UI has options for operations like creating/modifying tables and managing their columns, keys and indices. You can execute the generated code as it stands, or there's a text editor where you can work with the DDL script directly.

You get 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.

datagrip

 

DataGrip is aware of dependencies for completing JOIN clauses, can suggest types of parameters for functions and procedures, and describe table structure for INSERT statements. There are also templates for generating conventional parts of statements, and you can add your own templates for statements you use frequently. 

There's a table editor that you can use to add, remove, edit, and clone data rows. It has a filter so you can limit the data you see without writing WHERE clauses, and you can carry out text searches for data.

You can also use the IDE to profile queries and compare results. You can choose to execute the subquery, execute the outer query, or execute the whole script. You can also run a chunk of code by selecting it and choosing run. 

DataGrip is available as part of the JetBrains ToolBox or as a standalone IDE, and can be used with any SQL dialect that has a JDBC driver.

datagriplogo

More Information

Download DataGrip

JetBrains Blog

Related Articles

JetBrains Previews IDE For SQL

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


Kinect Is Back!
07/05/2018

It's not a simple return to what things were but it is still good news. Microsoft has announced at Build that it has decided to make Kinect available to developers.



Internet Pioneers Awarded Franklin Medal
26/04/2018

Vint Cerf and Bob Khan have been presented with Franklin Institute Awards for the part they played in the creation of the Internet.


More News

 
 



Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Friday, 18 December 2015 )
 
 

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