If values of only one column are extracted, they are combined into an IN operator.Values within one row are combined with the AND operator.Values within one column are combined with the OR operator.New extractor: WHERE clause - A selected range of values can be now extracted as part of the WHERE clause:.Datetime/timestamp (with or without timezone).This is now available for three types of fields: Formats for date and time data types - Added the ability to customize how fields of date and time types will be displayed in the data editor.Drag and drop for script files - To run a script against any schema, you can now just drag and drop your script file from the Files tool window.Colors for global data sources - When you set the color for the global data source, it is now shared along with its data source.Pattern-based schema filtering - Added the ability to choose databases or schemas for introspection based on regular expression patterns.Quick filter - Added the ability to filter objects when using quick search.Select in the database explorer: Alt/Opt+Shift+B.All major navigation actions can be performed there: Navigation in diagrams - Diagram elements are now fully navigable.Please note that using virtual views in your SQL code is not currently possible.
Virtual views are visible in the database explorer and can be run with a double-click. Basically, it’s just a query that retrieves the result and is stored inside DataGrip. Virtual views - This new concept is virtual and lets you use views without actually creating them in your database.This plugin is capable of syncing your settings across all IDE instances connected to your JetBrains account. New Settings Sync solution - The functionality of the separate IDE Settings Sync and Settings Repository plugins has been combined into a single Settings Sync plugin.New UI available via settings - You can switch to the new UI in Settings / Preferences | Appearance & Behavior | New UI Preview.Data Viewer: Filtering and JSON highlighting.Object Editor: Renaming and deleting keys.Coding assistance: Code highlighting, keyword completion, and resolution for databases and keys.Query Execution: The JDBC driver supports the execution of the majority of queries.Database Explorer: Separate folders for keys of different types for Redis v6.0+, and one folder with all keys for older versions.Introspection: Introspection of databases and keys, including the ability to set a default key filter for the introspector.Here’s a quick overview of what it is included: You can now connect to Redis Single Instance, explore key values in the Data Viewer, write and execute Redis queries with the help of the smart coding assistance, and more.
0 kommentar(er)
