The JetBrains Blog

Today we’ve got the first minor update for 2021.2 for you, with several important improvements and fixes. Improvement DBE-4978: Inlay hints appear in SET statements. If you turn on For set operations in Preferences | Editor | Inlay Hints | SQL| Show column names, you will get column hints f…

Hello! The third EAP build for 2021.2 is available! Try it out and share your feedback with us.  Add/delete column Now there is the ability to add columns to MongoDB collections. This action lets you add a new field to any document of a collection. Delete column will delete data n…

Hello! Another EAP build for 2021.2 is available! We would appreciate it if you would try it out and share your feedback with us.  New location for projects In DataGrip, projects are now located by default in the same place as they are in all other IntelliJ-based IDEs – in the user's home…

Hello! We've released DataGrip 2021.1.3! The problem of bad handshakes with old servers Due to their security policy, Java dropped the usage of the TLSv1 and TLSv1.1 protocols. This caused a problem when connecting to old servers that accept only these protocols. As a fix, we now offer you the…

Hello! We’re starting our EAP program for DataGrip 2021.2. We would really appreciate you trying out these new features and sharing your feedback with us – it helps us make the release better! Let's go! DDL data source Generation from a real data source It is now possible to generate a DDL …

Hello! Today we’ve got a new minor update for DataGrip 2021.1. Let's see what’s been improved. Features DBE-13048: Some run configurations require the data source to be disconnected first. Now it’s possible to disconnect from a data source before launch. DBE-12906: We’ve introduced a Modify grants action. Introspection DBE-6276: [PostgreSQL] Support for security policies. DBE-13138 [Redshift] Support for sort keys for tables and views. DBE-13024: [Redshift] Fixed the bug with the completely failed introspection. DBE-12442: [Oracle] Source code is retrieved correctly for Oracle 9i. DBE-13146: [Oracle] Type attributes are retrieved correctly for Oracle 11. DBE-12954: [BigQuery] No more missing schemas. DBE-12166: [BigQuery] Creating a temporary function doesn't re-run the introspection. Navigation and search DBE-12901: It's possible to navigate to the data source from the Database tab of the search. DBE-11738: The Context data source scope works again in search. DBE-12968: Color settings are respected again in search. DBE-13090: View DDL from data works again. DBE-5341: Go to related symbol has been added to the context menu of the object in the code editor. DBE-4960: [PostgreSQL] Go to related symbol works for navigating from triggers to the related procedure, and vice versa. DBE-13033: Navigation by foreign keys supports references to one column. DBE-13037: Scroll from editor works from the data editor. DBE-12967: [SQlite] Full-Text Search uses LIKE to search within LONGVARCHAR fields. Data viewer DBE-5435, DBE-11780, DBE-12827, DBE-11591: Fixed some bugs with missing ctid columns. DBE-13150: The data diff viewer works again. DBE-13126: Text search works when invoked a second time. DBE-12985: [MySQL]: The default value for the date field is now correct. DBE-12940: The Toggle Soft-Wrap and Toggle Formatting buttons don't disappear anymore. DBE-12594: Formatted mode for XML no longer removes all spaces. Code generation DBE-8654: Run routine generated code contains qualified objects. DBE-12934: Argument direction is taken into account when modifying the routine. DBE-12873 [BigQuery] Int64 is the default type when creating a new column. DBE-12892 [BigQuery] Dropping views now works. Code highlighting DBE-9813: [Clickhouse] Support for CREATE DICTIONARY. DBE-12996: [Clickhouse] Support for EXISTS (database | dictionary | view) statements. DBE-12993: [Clickhouse] Correct syntax highlighting for CREATE OR REPLACE. DBE-12994: [BigQuery] Support for EXPORT DATA, TABLESAMPLE SYSTEM, CREATE SCHEMA, ALTER SCHEMA, and DROP SCHEMA. That's all for today! The DataGrip team

Hello, This is the first minor update for DataGrip 2021.1. Check out what’s new inside! Important fixes DBE-5341 It's possible to navigate from a synonym to the table. DBE-12985 The default date for the datetime cells is correct. DBE-12994 CREATE/ALTER/DROP SCHEMA, TABLESAMPLE and EXPORT DATA a…

We’ve released our last EAP build before the official release of DataGrip 2021.1. Let's see what's new. Context live templates This is our solution for anyone wanting to generate simple statements straight from the database explorer. While general live templates cover many cases where you need to wr…