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


Azure Container Apps Dynamic Sessions Generally Available
02/12/2024

Dynamic Session support has been added to Azure Container Apps. Azure Container Apps is a serverless platform for running containerized applications, and dynamic sessions is designed to provide fast a [ ... ]



Google Intensive AI Course - Free On Kaggle
05/11/2024

Google is offering a 5-Day Gen AI Intensive Course designed to equip data scientists with the knowledge and skills to tackle generative AI projects with confidence. It runs on the Kaggle platform from [ ... ]


More News

espbook

 

Comments




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

Last Updated ( Friday, 18 December 2015 )