Call us on: +44 (0)1364 654100
DataGrip [Commercial - Subscription Licence (1-Year) (1) Licence - Electronic Windows] boxshot

Add this product to your basket

DataGrip [Commercial - Subscription Licence (1-Year) (1) Licence - Electronic Windows]

Published By: JetBrains s.r.o


£146.91 (Ex. VAT)

Our Part #: 1141052 | Availability:  delivered via Email | Media: Electronic

Description
New Features
Features
Regions
Docs & Downloads

DataGrip is the multi-engine database environment. Supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. If the DBMS has a JDBC driver you can connect to it via DataGrip. For any of supported engines it provides database introspection and various instruments for creating and modifying objects.

Documents & Downloads



» JetBrains Download Links

What's new in DataGrip 2016.3

Database objects support

  • Loading source code of triggers, rules, materialized views
  • Find usages inside views and procedures
  • Tracking database changes
  • Diff viewer for source code changes
  • 'Open DDL in new console' action
  • Renaming views
  • Saving comments for procedures

Data editor

  • Bulk submit changes
  • Multiple edit
  • Data conversion
  • Select next occurrence
  • Expand selection

Code insight

  • Navigation by statements
  • Unused parameters inspection
  • Set operators inspection
  • Find usages by $n references in PostgreSQL
  • USING completion in PostgreSQL
  • Excluding default fields in INSERT completion

Miscellaneous

  • Integration with pg_dump and mysqldump
  • SQL Server 2016 and PostgreSQL 9.6 support
  • Faster scripts execution
  • XML extractor comes back
  • New icons

Import CSV
Instead of the way of importing CSV files with the help of Edit As Table, use our new user interface. It will help you to import CSV, TSV (well, DSV) files to the database.

Click the schema you want import data to, and choose Import From File… from the context menu. Then choose the CSV file where your data is.

You will see the Import dialog window. The left-hand panel is for format specification: choose the delimiter, whether the first row is a header (the separate format options are available for it), and specify if you have quoted values in the file.

On the right-hand side, you see a frame describing the table to be created and a result data preview. Press Delete to remove a column from the result. If you wish to import data to an existing table, just use the context menu of this particular table to choose Import From File…

OK, but what happens if there are errors in the file? Write error records to file option is available. The import process will not be interrupted, but all the wrong lines will be recorded to this file.

Adding Schemas
The way schemas are selected from the tab in Properties has been replaced , so now you will find all schemas of the server by clicking 'More Schemas…' in the database view. Choose the schemas you want to see here and hide any you don't need from the context menu. Now you need to refresh your data source if you've updated from the previous version. Remember, that only schemas added to the database tree are available in code completion.

Language Injections

Auto-injection
Language Injections is the feature lets you treat string literals as live code written in other languages (like XML, JSON, any SQL dialect or regular expressions), including formatting, highlighting, usage search, completion, and even refactoring. Language is auto-injected into a literal when DataGrip understands the type of the string inside. For example, if you are inserting values into JSON column, they will be treated as such.

Language can also be injected when you're specifying a column default value. In the following case it's XML, which makes all the XML-related features available there: rename elements by Ctrl+F6, find usages by Alt+F7, and enjoy completion for attribute names. For more information about XML support you can have, read this IntelliJ IDEA help page. DataGrip and IntelliJ IDEA share a common platform, everything described there will work in DataGrip just as well.

Custom Type Injection
By default, there are only two predefined injection types: JSON and XML. However, it's really simple to create your own injections: just press Alt+Enter and then select Inject By Type. There are many languages you can inject. Notice that quick search is available here.

You will be offered to create a custom type pattern that simplifies the use of injections; for instance, you can configure it to inject XML into any type ending with DATA. You can use regular expressions to define the injection patterns. There's RegExp assistance, too: Alt+Enter invokes the Check RegExp feature.

You will be offered to create a custom type pattern that simplifies the use of injections; for instance, you can configure it to inject XML into any type ending with DATA. You can use regular expressions to define the injection patterns. There's RegExp assistance, too: Alt+Enter invokes the Check RegExp feature.

Regular Expressions Checking
Since it's possible to inject languages into any string in the SQL code, we can use Check RegExp if we're inserting, for instance, a value for the MasterCard pattern. First, inject RegExp language to your string by Alt+Enter, then Alt+Enter again and invoke Check RegExp.

Dynamic SQL and Comment Injection
If you want to have the injection whenever you edit a particular piece of code, comment it with 'language=' like on the following screenshot. In it is another important example — the use of DynamicSQL that provides coding assistance for the injected fragment.

Dynamic SQL and Comment Injection
If you want to have the injection whenever you edit a particular piece of code, comment it with 'language=' like on the following screenshot. In it is another important example — the use of DynamicSQL that provides coding assistance for the injected fragment.

Completion for Values in Tables
Completion for values in table is available via Ctrl+Space. It looks through all the values in the column and offers you a list of possible matches.

Fields Editing
Some improvements have been made in PostgreSQL: now you can modify different range types and types with time zones.

Query Console

Ligatures
Just like any other IntelliJ-Platform-based IDE, DataGrip editor now officially supports fonts with programming ligatures. To enable ligatures, go to the Settings ? Editor ? Colors & Fonts ? Font, specify a font that supports ligatures, e.g. Fira Code, Monoid, PragmataPro or Hasklig (the font has to be installed) and select the Enable font ligatures option.

Keyboard Layout Aware Completion
A small enhancement for those who use many languages, IntelliJ-based IDEs including DataGrip now understand what you mean, even if you forgot to switch the language of input.

Surround With Function
Surround action doesn't ruin multi-carets anymore. Also, we've added surround with function which means that the caret will be placed before the brackets, not after: put the name of the function here.

Search Path Support
DataGrip now supports search path in PostgreSQL, meaning you can add schemas one by one in the switcher of the console. The console has a list of schemas to look in. If there are two tables with the same name in different schemas, the first one will be used. Thus, the order is important: move schemas in the search path with the mouse or Alt+Up/Down.

Dumping Tables

Now you can dump multiple tables and even the entire schema, which means that any data (not only result-sets), can be exported to CSV, JSON or a list of INSERT/UPDATE statements.

Recompiling Packages
Some bugs fixed in recompiling packages in Oracle and added a way to recompile any DB object. It has to be recompilable like procedures, views, types, triggers, etc. There is a possibility to recompile only invalid objects in the group, too.

Background Images

A small new feature will help you make DataGrip look different: set any image as the background of your IDE. Add the folder with the picture to the Files panel, and then choose Set Background Image from the context menu. Or just choose Set Background Image from Find Action by Ctrl+Shift+A.

Other Improvements

  • Fixed DBE-569: important bug with timed out connection on MySQL.
  • The Database tool window now provides the option Auto-scroll from Editor.
  • If you use auto-completion, in case of identical names DataGrip will qualify the name of the object automatically.
  • Added Tools ? Create Command-line launcher/Create Desktop Entry actions in Linux.
  • Go to source works from the preview in Find in path.
  • Copying SSH and SSL settings copies the password as well.
  • *.sql files are associated with DataGrip on Windows and also can be opened from the 'Open with' context menu.
  • CTE support has been improved — we parse it even not finished.
  • Inserting the selected keyword in completion by ';' and ',' doesn't insert a space anymore.
  • Aggregate functions in ORDER BY are not highlighted as errors.
  • The same for PREVIOUS VALUE in DB2.
  • Test connection UI has been improved.


Intelligent query console - Allows you to execute queries in different modes and provides local history that keeps track of all your activity and protects you from losing your work.

Efficient schema navigation - Lets you jump to any table, view, or procedure by its name via corresponding action, or directly from its usages in the SQL code.

Explain plan - Gives you an extended insight into how your queries work and into database engine behavior so you can make your queries more efficient.

Smart code completion - DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing.

On-the-fly analysis and quick-fixes - DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers the way to fix problems.

Refactorings that work in SQL files and schemas - DataGrip correctly resolves all references in your SQL code and helps you refactor them. When you rename a variable or an alias, it will update their usages throughout the entire file. Even the actual table names in the database are updated when you rename references to them from your queries.

Version control integration - We provide unified support for all major version control systems: Git, SVN, Mercurial and many others.

Cannot sell to the USA

Shopping Basket
    0 Item(s)
    Total:
    0.00


    View and amend your basket
         
    ISV Royalty Licensing
    VMware vRealize