DataGrip 2022.3

Aggiunge il supporto Redis e la possibilità di utilizzare le visualizzazioni senza crearle nel database.
Dicembre 2, 2022
Nuova versione

Funzionalità

  • General
    • Redis Support - Added support for Redis. 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. Here’s a quick overview of what it is included:
      • 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 resolution for databases and keys.
      • Object Editor: Renaming and deleting keys.
      • Data Viewer: Filtering and JSON highlighting.
    • New UI available via settings - You can switch to the new UI in Settings / Preferences | Appearance & Behavior | New UI Preview.
    • 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. This plugin is capable of syncing your settings across all IDE instances connected to your JetBrains account.
    • Virtual views - This new concept is virtual and lets you use views without actually creating them in your database. Basically, it’s just a query that retrieves the result and is stored inside DataGrip. Virtual views are visible in the database explorer and can be run with a double-click. Please note that using virtual views in your SQL code is not currently possible.
    • Navigation in diagrams - Diagram elements are now fully navigable. All major navigation actions can be performed there:
      • Open DDL: Ctrl/Cmd+B.
      • Open data: F4.
      • Select in the database explorer: Alt/Opt+Shift+B.
      • Modify: Cmd/Ctrl+F6.
  • Database explorer
    • Quick filter - Added the ability to filter objects when using quick search.
    • Pattern-based schema filtering - Added the ability to choose databases or schemas for introspection based on regular expression patterns.
    • Colors for global data sources - When you set the color for the global data source, it is now shared along with its data source.
    • 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.
  • Data editor
    • 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. This is now available for three types of fields:
      • Datetime/timestamp (with or without timezone).
      • Time (with or without timezone).
      • Date.
    • New extractor: WHERE clause - A selected range of values can be now extracted as part of the WHERE clause:
      • Values within one column are combined with the OR operator.
      • Values within one row are combined with the AND operator.
      • If values of only one column are extracted, they are combined into an IN operator.
    • SQL filtering by multiple values - The Filter by action now generates a condition if you select several values.
    • Text search field: populate with selection - If you press Ctrl/Cmd+F for text search, the search fields will now be automatically populated with the value under the cursor. This is similar to the well-known logic of the text editor.
    • Struct values are displayed correctly [Google Big Query] - Struct values are now displayed in a readable way: Each nested value is displayed as a separate column.
  • Working with code
    • Intention action preview - You can now instantly see how your query will be altered once you apply the IDE’s suggestions. The preview appears when you open the list of available intention actions and hover over an option. You can disable the preview feature by pressing F1/Ctrl+Q while the list of intention actions is open.
    • Single line copy-paste - If there is no selection, pressing Ctrl/Cmd+C automatically selects and copies the entire line in the text editor.
    • New layout for the SQL schema generator: Per Object By Schema and Type - The new layout is called Per Object By Schema and Type. If it’s used for generating SQL for the whole schema, the resulting files will be placed in folders according to the object’s type: tables, views, etc.
    • Improvements:
      • [Oracle] SET ROW is now supported.
      • [Microsoft SQL Server] $PARTITION is now supported.
  • Working with tables
    • UI for virtual foreign keys - Virtual foreign keys are now visible in the database explorer. You can create and drop them in the database explorer and in the Modify Table dialog.
    • Table size in quick documentation [MySQL and PostgreSQL] - The size of the table is now displayed in the quick documentation popup for MySQL and PostgreSQL. To see it, click on Show table preview.
  • Connectivity
    • Startup script for session templates - It’s now possible to set the startup script for the session templates. This means that the script will be run each time a new session is created based on the corresponding template.
    • Authentication options [MongoDB] - Added many authentication mechanisms to the connection dialog for MongoDB. To use them, update your driver to version 1.16.
  • Schema diff viewer
    • Support for object dependencies - The schema diff viewer now takes into account dependent objects.
      • The most important such object is PostgreSQL identity columns:
        • If the related sequences are different for two otherwise identical identity columns, then this difference will be displayed when these two columns are compared.
        • Another example would be a trigger calling a procedure from another schema. Now the difference between such triggers will be displayed if the routine names are different.
DataGrip 2022.3
Redis support

DataGrip

Un database IDE diretto a soddisfare le esigenze specifiche di sviluppatori SQL e amministratori di database professionisti.

Richiedi preventivo Acquista ora

DataGrip è disponibile anche in:

Hai una domanda?

Chatta live con i nostri specialisti di gestione delle licenze di JetBrains ora.