2021.1

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 ability to explicitly turn on these protocols, though you need to keep in mind that doing so results in vulnerability issues.  There may also be problems connecting to MySQL, even if the database supports the TLSv1.2 and TLSv1.3 protocols. Because of bugs on the server side, the driver

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

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 write a simple query quickly, we also understand that sometimes, when you are in the context of the database explorer and you are already focusing on the object you need, there is a better way to get a simple query using that object. And of course, many other tools use this mechanism for reducing rep

Hello! Here’s yet another build in our EAP for DataGrip 2021.1. Navigation Straightforward actions We've simplified the navigation and got rid of these settings: If you never changed these settings and had these check-boxes marked by default, the major change in 2021.1 for you is the following: Go to declaration (Ctrl/Cmd+B) on the object in SQL now leads you to the DDL, not to the database tree. We also introduced a shortcut for the Select in database tree action: Alt+Shift+B for Windows/Linux and Opt+Shift+B for MacOS. The main reasoning behind this change is the idea that the logic sho

If you’re interested in previewing what the year’s first release of DataGrip will include, here’s what you can already try. Connectivity We’ve reworked the connection window to make it more friendly. Drivers and data sources are now listed on two different tabs. The list of drivers won't bother experienced users, while newcomers will not confuse them with data sources. Every driver's page includes a Create data source button. The Test Connection button has been moved to the footer so that you can use it from any tab of the data source properties, not only the General and SSH/SSL tab as