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

Database tree:

• New schema management
• SQL resolution scopes
• Create database/schema UI
• Color settings affect editor and grid
• SQLite introspection

Import/export data:

• Column mappings
• DDL preview
• Drag-n-drop tables
• Export result-set to a database

Query console:

• Respecting the default search path in PostgreSQL
• Trigger generation pattern
• NEW/OLD and INSERTED/UPDATED support
• Hints for column names in INSERT statement
• Insert string concatenation on Enter option
• Settings for Qualifying objects
• Editable Aliases casing
• Statement separators
• Jump to colors and fonts action

Database objects:

• Double-cliсk to open column details in Modify table
• Warning if an object has been changed in another place
• Correct source code for views in SQLite

Miscellaneous:

• Query time and selected column/row numbers in data editor status bar
• Include/exclude text occurrences in Find Usages
• Windows authentication for SQL Server in jTDS driver
• Commit triggers synchronization in PostgreSQL
• Read-only preview available for large files