DataGrip, our IDE for SQL and databases, has reached a new version. New features and improvements:

Database objects

— Cassandra database supported

— Generate SQL files for the selected objects

— Support for extensions in PostgreSQL

— Support for stored procedures in PostgreSQL 11

— Statistics in Quick Doc

— Use drop cascade syntax option

Code completion

— Postfix completion

— New setting to automatically add aliases when completing table names

— Not aggregated fields in GROUP BY

— All columns list in SELECT, MERGE and INSERT INTO table variable

— Named parameters of stored procedures

— Numeric fields in SUM() and AVG()

— FILTER (WHERE…) clause

— Option to Invert order of operands in auto-generated ON clause

— Window functions

Code generation

— Dialects for Live templates

— Column names hint appears automatically when using INS live template

— CREATE TABLE definition for SELECT

Refactoring

— Intention action to Introduce table alias

— Many fixes in Extract subquery as CTE action

Code insight

— Warnings about unsafe DELETE and UPDATE

— New inspection to detect unreachable code

— Unused subquery item inspection

Connectivity

— Single connection mode

— Auto-reconnect after timeouts

Search and navigation

— New Search Everywhere

— Multiline TODO comments

— Multiline search in Find/Replace in Path

User interface

— High-contrast color scheme

— Better UI for page size setting

— Color settings in the data source Properties dialog

To learn more, read the blog post.

Your DataGrip Team

JetBrains
The Drive to Develop