Released: Apr 6, 2020

2020.1 中的更新

特性

Run configurations

• Configuration for running script files - Before, you could only run files one by one. This could be especially frustrating if the files included dependencies and the order was crucial. Now, you can run several files at once. Choosing to run multiple files creates the run configuration. In this configuration, you can reorder the files, add new ones, and run other programs or configurations before launch. Your run configuration will be saved automatically. If you want to run...

Released: Mar 17, 2020

2019.3.4 中的更新

特性

• Added subquery folding feature.

修補程式

• Can't Synchronize Schemas with latest Redshift drivers.
• CSV/TXT Import to MSSQL Database without importing an id value.
• "Preview update" does not work when table is not introspected.
• Fixed the false positive in the Unused expression inspection.
• Fixed the false positive in the Redundant COALESCE inspection.

Released: Feb 13, 2020

2019.3.3 中的更新

修補程式

• The right schema is now used when adding a foreign key constraint to a table.
• Auto sync is working after a DROP followed by a CREATE statement.
• No more freezes in JOIN completion.
• [Oracle] The OracleSqlPlus dialect is back.
• [ClickHouse] Deleting rows works as expected.
• [BigQuery] Identifiers are quoted using back quotes.
• [BigQuery] LIMIT and OFFSET are generated when opening a table’s data.

Released: Jan 22, 2020

2019.3.2 中的更新

特性

• Added the concept of virtual foreign keys which help you:
  • Have proper completion when writing JOIN clauses.
  • Display relations in diagrams.
• Added stored procedure runner for MySQL.

修補程式

• Aliases are no longer used when completing table names in DDL.
• Only trigger functions are offered in the corresponding completion list.
• The wildcard is now resolved inside row constructors.

Released: Dec 19, 2019

2019.3.1 中的更新

特性

• A new option lets you choose whether you want to use schema qualifications when using JOIN.
• The table filter is cleared when opening a table from the database explorer.
• Added new registry option to remove schema qualification when updating data.

修補程式

• The correct schema is used when adding a foreign key.
• Fixed the bug with queries seeping into column names.
• Right-clicking on a column header shows the menu again.

Released: Dec 3, 2019

2019.3 中的更新

特性

MongoDB support

• Introspection - You can now observe collections and fields in the database explorer. It fetches the first 10 documents from each collection to get information about the fields. This can be customized via the JDBC parameter fetch_documents_for_metainfo which is available in the Advanced tab of the data source properties dialog.
• Query console - Run statements via Ctrl+Enter or by using the Run button on the toolbar. If you’re using the database support in any other JetBrains IDE...

Released: Sep 26, 2019

2019.2.5 中的更新

特性

• Improved H2 grammar support.
• Support for numbers at the beginning of table names re-added.

修補程式

• [PostgreSQL] Procedure added back to the Generate menu.
• Fixed the bug importing data from CSV files that include an IDENTITY column.
• The Replace IN intention no longer corrupts code.

Released: Sep 12, 2019

2019.2.4 中的更新

特性

• Added Compare Content action to table context menu.
• UUIDs are now quoted when navigating to referenced rows.
• Full-text search results are now sorted alphabetically.
• DataGrip offers to introspect the schema if it’s used in the console.

Released: Aug 16, 2019

2019.2.2 中的更新

特性

• Added JOIN completion based on column names.
• Markdown data extractor is now bundled with DataGrip.
• Drag-and-drop of columns now adds commas.
• Breadcrumbs are now also shown for SQL.
• Improved support for partition tables in PostgreSQL . The key enhancement: partition tables are now displayed under the main one.

修補程式

IDE general

• Performance improvements.
• The folder path became editable in SQL Dialects settings section.

Code generation

• Schema comparison: the same objects are not marked as...

Released: Aug 1, 2019

2019.2.1 中的更新

修補程式

• No more high memory usage, leading to total freezes.
• Fixed problems with failed startup on Linux.