DataGrip Adds Cassandra Support
Written by Kay Ewbank   
Wednesday, 05 December 2018

Support for Cassandra has been added to DataGrip, JetBrain's IDE for databases and SQL. The 2018.3 release also improves PostgreSQL support, and the ability to generate SQL for selected objects.

DataGrip 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 addition of NoSQL Cassandra support follows the inclusion of Clickhouse support in the previous release. You can now write queries, observe data, and generate scripts for Cassandra from within DataGrip. Support has also been added for extensions and stored procedures in PostgreSQL.

Cassandra support in DataGrip

 

Another improvement to data handling is that if you use DataGrip's SQL Generator to get the DDL from objects, you can also choose to generate the SQL files for those objects. It's a minor change, but a nice one, and once generated they can be edited within DataGrip.

Refactoring support is another area to have received an improvement that might make a real difference, with the addition of support for Introduce alias.  Refactoring improves code to be written better, and DataGrip will now automatically add aliases when completing table names, so the code is more readable and understandable.

Other improvements to code completion are better handling of Group By clauses so that DataGrip shows you a list of non-aggregated fields; and the presentation of a list of all columns in completion after the Select, Merge and Insert Into keywords.

Completion now works well for named parameters of stored procedures, and when you use an ambiguous name, DataGrip now shows you the context.

Join handling has also been improved, with a new setting called Invert order of operands in auto-generated ON clause. If it’s set to off, the From table will be the first in the Join conditions.

The new version can be downloaded from the JetBrains website.


 

 

datagriplogo

More Information

DataGrip site

Related Articles

DataGrip Adds Group Data Sources

DataGrip Improves Schema  Management

0xdbe Becomes DataGrip 

 

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


Intuit Hackathon Returns To London
13/02/2019

Intuit's Small Business Hackathon is back in London for the third time and has a prizes of up to £5000 for creating a brand new solution that saves small businesses time or money.



DigitalOcean Launches Managed Database Service
15/02/2019

DigitalOcean has launched a Managed Database service for PostgreSQL, with plans to add support for other database engines  throughout the year. The service provides fully hosted and managed datab [ ... ]


More News

Python

 



 

Comments




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

Last Updated ( Wednesday, 05 December 2018 )