Today we’re releasing the second minor update for 2021.2, which introduces several important improvements and fixes. Improvements DBE-2216: Wildcards are now considered as column usages. DBE-13773: Ctrl/Cmd+Click from the navigation bar correctly navigates to the desired element. Fixes DBE-12656: Enable DBMS_OUTPUT works immediately after being turned on.
Transition from SSMS to DataGrip: 10 tips
This post is for people familiar with SQL Server Management Studio who have decided to try DataGrip with SQL Server. Some concepts, pieces of the user interface, and shortcuts differ between these two tools. We'd like to try and help you with this transition! TLDR: table SSMSDataGripConnects to any running serverTCP/IP and SQL Server Browser should be enabledAll databases and schemas are sho
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 for statements inside set statements, for example, UNION statements. Fixes DBE-9198: The Re
DataGrip 2021.2 is Out!
DataGrip 2021.2 is here! This is the second major update of 2021, and it’s packed with various enhancements. Let’s take a look at what it has to offer! For a detailed description of this update, please visit our What’s new page. DDL data source Generation from a real data sourceCreating objects Diagrams Table comments are now visibleTable colors are also displayed on
Don’t Lose Your Work! Stay Safe With DataGrip
We’ve all been in situations where we thought we lost something forever, a text file or a photo, perhaps. But then somehow we found a way to recover it. The relief you feel in that moment can stay with you for a long time. DataGrip can be a really powerful tool for recovering your queries, even if it can't recover all your data. Read on to learn about what it can do. Query history D
DataGrip 2021.2 EAP 3
Hello! The third EAP build for 2021.2 is available! Try it out and share your feedback with us. 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 not only on the page that is being displayed, but also throughout the whole collection. Navigation We've made the
DataGrip 2021.2 EAP 2
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 folder, inside the DataGripProjects subfolder. Your project in DataGrip is a complex of your
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 result
DataGrip 2021.2 EAP is Open!
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 data source based on a real one. The DDL files will be created on the disk and the new data source w
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
DataGrip overview video
🔥 Important content!We’ve released the DataGrip overview video, covering all the major capabilities of our IDE. We bet you’ll learn something new today!No matter how experienced of a DataGrip user you are, there’s always room for improvement.