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


TypeScript 5.4 Adds NoInfer Type
12/03/2024

TypeScript 5.4 has been released, with the addition of a NoInfer utility type alongside preserved narrowing in closures following last assignments. 



Apache Updates Geronimo Arthur
28/03/2024

Apache Geronimo Arthur has been updated with support for Common-compress, XBean, and ensures the default options are compatible with last GraalVM release.


More News

raspberry pi books

 

Comments




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

Last Updated ( Friday, 18 December 2015 )