DataGrip 2023.1 EAP 2
We're continuing our release cycle dedicated to product quality. However, no new features will be introduced in the upcoming release. Here's the list of improvements and fixes you can already try in this EAP build: DBE-16238: Errors no longer appear while saving a diagram. DBE-17229: The Schema diff viewer now works properly. Previously it opened empty if there were database or server objects included. DBE-7087: Usage search no longer looks in the installation bundled resources. DBE-17434: The correct font color is used in the data editor header. DBE-17292: The Quick Do
Hello! We’ve released the second bug-fix update for DataGrip 2022.3. Here’s what’s been improved:
DataGrip 2022.3 EAP 3
Hello! Here’s a brief overview of what we've released in the latest update to DataGrip 2022.3 EAP. UI for virtual foreign keys The ability to create virtual foreign keys was introduced a while ago and the main way to create them was by using the intention action Store Relation at the JOIN clause in your query. This was a little bit tricky to find and the whole functionality lacked an intuitive way to use it. Here’s an overview of the implemented changes:Virtual foreign keys are visible in the database explorer: You can create and drop them here, in the database explorer, and also
DataGrip 2022.3 EAP 2: Redis Support
Summary In DataGrip 2022.3 EAP 2, we’ve implemented a preliminary iteration of long-awaited support for Redis. Here is the list of what is now supported: Connectivity: Redis Single Instance.Introspection: Introspection of databases and keys, including the ability to set a default key filter for the introspector.Database Explorer: Separate folders for keys of different types for Redis v6.0+, and one folder with all keys for older versions.Query Execution: The JDBC driver supports the execution of the majority of queries.Coding assistance: Code highlighting, keyword completion, and resolut
DataGrip 2022.3 EAP Is Open
Hello, DataGrip fans! As usual, we want to share our new functionality with you before the official release happens. Here’s what you will find in DataGrip 2022.3. Of course, you can already try all of this out by downloading our EAP build. Let’s go! Database explorer Quick filter A long-awaited feature is finally here! Now, when using quick search, you also have the ability to filter objects. All non-matching objects will be hidden. Pattern-based schema filtering If you have lots of different schemas, this is for you. It's now possible to choose databases or schemas for
DataGrip 2022.2.2 Improves the Modify Object UI
This bug-fix update is focused on enhancing the new Modify Object UI. Before listing what we’ve improved, let us give you a bit more background info about how the new UI came about. Why the new UI? At some point it became clear that the whole Modify Object UI had to be rewritten from scratch. There were some usability issues, like expanding the UI, which we admit was not the best idea. However, the main reason was that with so many supported database engines, DataGrip just could not provide a powerful UI for objects in each of them. We could manually design the dialog for 3 or maybe 5 da
Not All Databases/Schemas Are Displayed by Default. Why?
There is one thing which makes DataGrip different from many other database tools: DataGrip doesn't show all schemas and databases by default in the database explorer. In this post we'll briefly describe why it's designed like this and what you can do if this doesn’t suit your workflow. The most important thing about DataGrip is that the essence of its work concerns database introspection. Introspection is the process where DataGrip loads the metadata for all the database objects and then uses this metadata for coding assistance and navigation. By default, all schemas shown in the databas
DataGrip 2022.2 EAP 1
Hello! We’re starting our EAP program for DataGrip 2022.2. We would appreciate it if you could try out these new features and share your feedback with us – it will help us make the release better! Let’s take a look at what’s new in the first EAP build. Option to import multiple CSV files You can now select several CSV files and import them at once! New Modify UI The new Modify UI, a basic version of which was introduced in the 2022.1 release, has become the default option. Starting with version 2022.2, all of a table’s child objects can be added and edited using this new UI.
Hello! We have released the third bug-fix update for DataGrip 2022.1. DBE-15179: Read-only icons are again available for data sources. DBE-15494: Introspection no longer fails with an Unknown column 'generation_expression' in 'field list’ error. DBE-15354: Dates are now saved correctly after you edit them via the text field. Thanks! DataGrip team.
DataGrip 2022.1 EAP 3
Hi! A new EAP build for DataGrip 2022.1 is now available. Let's see what's new: New version of Modify Table We are slightly reworking the Modify Table window. The new version will have a fully generated UI based on introspective properties, which will allow it to have a variety of database-specific parameters. For now we are releasing only a small portion of the update, but it can already be uniquely useful. The new Modify Table window lets you add and edit column check constraints, which was previously impossible! Also, you can now edit all the properties of tables and columns DataGr
Working with source codes in DataGrip
Basics The source code of the object is the core part of the DDL script which is needed to create this object. In other words, the CREATE statement is not part of the object's source code. The source code is stored inside the database. The most common objects found with the source code are views, functions, and stored procedures.In many other tools, to update the source code, you would need to generate the CREATE OR REPLACE script, make the required changes and run it. In DataGrip it works a little differently. You just need to make the changes you need to make and the proper script will be
DataGrip 2022.1 EAP 2
Hello! Here's a list of all the enhancements that await you in the second EAP build of DataGrip 2022.1. Canceling running statements Previously, when you clicked the Cancel Statement button several times, it looked like the query was terminated, but in fact the request continued to be executed in the database. There was some tricky logic behind this behavior. On the first click, DataGrip sent a cancellation request to the database, while on the second click it canceled the JDBC Driver process to terminate all connections to the data source (we'll refer to this as data source deactivat