DataGrip 2023.3 EAP is Open
Hello! We’re starting our 2023.3 Early Access Program (EAP) and, as usual, we invite you to try the latest features and improvements we’re adding to DataGrip ahead of the official release.
Let’s take a look at what’s inside the first EAP build.
[Oracle]: Introspection level defaults
DataGrip takes a long time to introspect schemas in Oracle because Oracle catalogs are very slow. To address this problem, introspection levels were introduced.
By default, the highest level was selected, which meant that selected schemas immediately began to be introspected at the third level, which was slow.
Also, some users were unaware that the introspection level setting existed at all.
In 2023.3, DataGrip prioritizes the user experience and performance over the fullness of functionality. The default value for the introspection level now is Auto Select.
Our new approach is to set the default introspection level for each schema based on the schema type and number of objects.
We assumed that users most often work with the current schema, less often with other schemas, and very rarely with system ones. The current schema is the one the Oracle session is connected to.
For each schema the introspector counts objects and selects the introspection level using the following thresholds, where N is the number of objects:
|Schema||Level 3||Level 2||Level 1|
|Current||N ≤ 1000||1000 < N ≤ 3000||N > 3000|
|Non-current||Never||N ≤ 3000||N > 3000|
|System||Never||N ≤ 100||N > 100|
We’ve also implemented fragmental introspection – the ability to retrieve metadata for one single object. This helps in situations where the metadata (usually, the source code) is explicitly requested by the user.
For example, if you double click on a view, but the introspection level is low, DataGrip requests the source code at the same moment. This is more similar to how all other database tools work.
The automatic level detection is enabled by default. If you want DataGrip to work as before, go to Data Source properties | Options | Introspection | Default level | Level 3.
[SQLite] Warning if using WSL path
Unfortunately, it is impossible to work with the SQLite database located under a WSL path. The reason is that WSL doesn’t respect the SQLite file locking mechanism. For now, the only available solution for DataGrip is to show a warning in that particular case.
Don’t forget to vote for the original WSL issue if it’s critical for you.
That’s it for today!
The DataGrip team
Subscribe to Blog updates
Thanks, we've got you!
DataGrip 2023.3 EAP 2 is Out!
Hello, DataGrip community! The second Early Access Program version for DataGrip 2023.3 is here. If you want to try the new features before the official release, this is for you! Introspection scheduler It's now possible to set an introspection interval for each data source. Materialized…
DataGrip 2023.2: New UI with toolbar icons in the header, AI Assistant, time zones in the data editor, support for Redis Cluster
DataGrip 2023.2 is out!Here’s a sneak peek at what it has to offer. For a detailed description of this update, please visit our What’s New page. User Interface New UI: The toolbar icons have been moved to the header Improved main toolbar customization Light theme with light …
DataGrip 2023.2 EAP 2: Redis Cluster, New Schema Migration Dialog and More
Hello, DataGrip community! The second Early Access Program version for DataGrip 2023.2 is here. If you want to try the new features before the official release, this post is for you! Support for Redis Clusters Now you can connect to Redis Clusters and have the same feature set as with standalo…
DataGrip 2023.2 EAP is Open!
Hello! We are starting our EAP (Early Access Program) for 2023.2 and, as usual, we're inviting you to try the latest features and improvements we’re adding to DataGrip ahead of the official release. Let's look at what's inside the first EAP build. New UI The new UI is now enabled by d…