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.

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

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, Facebook, Google+ or Linkedin. 

Comments

Make a Comment or View Existing Comments Using Disqus

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