DataGrip 2017.1

Database tree

• New schema management - Now the schema selection UI is a tree with the ability to choose if you want to introspect the current schema/database or, all schemas/databases. ‘Schemas...’ node in the database view will also show this tree. The Schemas tab comes back to the data source properties dialog. We added the Pattern field where you can describe what you want to be introspected. The Ctrl+Q shortcut will give you information about the syntax.
• SQL resolution scopes - Now, you can simply map any file or folder to any datasource in Settings -> Database -> SQL resolution scopes. This means that all unqualified objects will be resolved to the selected datasource/database/schema.
• Create database/schema UI - Decide if you want these new schemas and databases to be introspected immediately. This also applies to creating and deleting schemas/databases from the query console.
• New options in color settings - Data source color now affects the console and result tab toolbars. It can even be applied to the editor and grid as well. We hope this will help you avoid running test scripts on your production databases.
• SQLite better introspection - Now shows triggers, expression indexes, partial indexes and check constraints.

Import/Export data

• Column mappings and DDL preview - Now it’s possible to map every column of the file being imported to a table column in your database, which can be either an existing table or a new one created during the import process. Of course, completion works for column names.
• Export/import tables - Now there is an easy way to export tables and their data from one database/schema to another.

Query console

• Respect the default search path  - The most important for PostgreSQL users: now DataGrip respects the default search path.
• Better trigger support - A trigger template has been added to the Generate menu, which is invoked with Ctrl+N. The IDE supports NEW/OLD and INSERTED/UPDATED tables when creating or editing triggers. This means you can use completion for these tables’ columns as well.
• Smart SQL keys - The Insert string concatenation on Enter option lets you choose if you actually need this. But the majority of database management systems support multiline string literals, so this IDE behavior may be annoying. Uncheck the option if you use multiline literals. Qualify object in completion has also been implemented.
• INSERT statement column names name hints - DataGrip will now prompt you about column names in INSERT statements.
• Options for alias casing - Aliases casing now can be set in Settings -> Editor -> Code style -> SQL. Aliases are offered in code completion.
• Named parameters completion - Named parameters of routines can be completed by using second completion (pressing Ctrl+Space twice).
• Statement separators - The general platform setting in Settings -> Editor -> Appearance -> Show method separator now draws a line between statements.
• Jump to colors and fonts - This action will navigate to the settings which are relevant to the context under the caret. If there are several of them, just choose one.

Database objects

• Modify table UI improvement - The column details in the Modify Table dialog are now opened by double-cliсk. We changed it based on your negative feedback on single-click opening.
• Tracking source code changes - Sometimes you make changes to the source code of some object, but forget to apply them. If you modify such an object in some other place in DataGrip, the source code editor will alert you.
• Documentation link for system tables - The quick info pop-up (Ctrl+Q) for PostgreSQL system tables now contains the link to the documentation page at postgresql.org.
• SQLite views - Now DataGrip loads the correct source code for views in SQLite. Before it was CREATE table code.

Miscellaneous

• More information in result-set status bar - Some information was added to the status bar of the data editor. It is query time and selected column/row numbers under the cursor.
• Text occurrences in Find Usages - A new option to include or exclude text occurrences in Find Usages. If it’s selected, results will include comments, occurrences in text files and string literals.
• Wnidows authentification for SQL Server in jTDS driver.
• Correct line endings are sent to the database in SQL Server.
• Support of CREATE/ALTER construction from SQL Server 2016.
• TNS names are correctly parsed from tnsnames.ora file in Oracle.
• It’s possible to use routine parameters in LIMIT in MySQL.
• Commit triggers synchronization in PostgreSQL.
• Single quotation mark is now escaped in DDL.
• Read-only preview is available for large file.
• Warnings are added on the Output tab as soon as they’re raised.
• Zero-latency typing is now enabled by default.
• Icons for synonyms are seen in structure view and completion.