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