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.


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, FacebookGoogle+ or Linkedin


AI Is Word of the Year 2023

UK-based Collins Dictionary has named "AI" as its word of the year for 2023, explaining that usage of "AI" meaning Artificial Intelligence has quadrupled over the previous twelve months.

Google Resumes Transition To Manifest V3

Google has resumed the planned deprecation of Manifest V2, giving notice to Chrome extension developers that Manifest V2 extensions will be phased out as early as June 2024 in the prestable versions - [ ... ]

More News




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

Last Updated ( Friday, 18 December 2015 )