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

Database objects support:

• Loading source code of triggers, rules, materialized views

• Find usages inside views and procedures

• Tracking databases changes

• Diff viewer for source code changes

• 'Open DDL in new console' action

• Renaming views

• Saving comments for procedures

Data editor:

• Bulk submit changes

• Multiple cells edit

• Data conversion

• Select next occurrence

• Expand selection

Code insight:

• Default fields excluding in INSERT completion

• Unused parameters inspection

• Set operators inspection

• Find usages by $n references in PostgreSQL

• USING completion in PostgreSQL

• Navigation by statements

Miscellaneous:

• Integration with pg_dump and mysqldump

• SQL Server 2016 and PostgreSQL 9.6 support

• Faster scripts executing

• XML extractor comes back

• New icons