DataGrip 2020.2 EAP Has Started!

Hello, everybody! You may be keen to know what we are planning to include in this summer’s release. We’ve got a description here of what you can already try.

A new UI for boolean values

Well, this is quite a welcome development! There’s a new way to observe and edit boolean values that is more user-friendly.

Boolean

Editing:
– The space key toggles values like it used to.
– Typing f, t, d, n, g, or c will input the corresponding values: false, true, default, null, generated, and computed. We’re all lucky that all these words begin with different letters!
– Typing anything else will open the drop-down with possible values.

A new UI for cropped data

Sometimes DataGrip cannot load all the data for a given cell. This happens if the size of the data in the cell is larger than allowed by the Database | Data views | Max LOB length setting. In these cases, we used to add a small piece of text, like “10 KB of 50 KB loaded”, to the value. Now instead of altering the value, we just show a hint.

Unloaded

Long tabs: no more!

Another usability issue that won’t annoy you in 2020.2: long tabs.

LongTabs

How it works now:

– The Database | General | Always show qualified names for database objects option is now turned off by default. Objects will be qualified in the tab names only if there are two objects with the same name open. For example, if you open two actor tables from different schemas, the schema name will be displayed in the tab name. Otherwise, it won’t be.

– If the data source has a name that is longer than 20 symbols, it will be truncated.

– If you have only one data source, DataGrip won’t display it in the tab name.

– If a qualified object name has more than 36 symbols, it will be cut off.

Introduce variable

This refactoring is now supported in more dialects: SQL Server, Db2, Exasol, HSQL, Redshift, and Sybase. You can introduce variables from any expression that has the simple type.

Introduce

UI for creating views

While we are always advocating for people to use the Generate functionality (Alt+Ins or Cmd+N in the SQL editor) if they want to create a view, many are more comfortable using the UI. We heard you, and we’ve added a UI option for that.

CreateViews

Refresh database quick-fix

Sometimes you have unresolved objects in your script. When you do, DataGrip doesn’t understand where these objects are located and suspects that they don’t exist at all. While in many cases this is true, sometimes the objects are unresolved because you just need to tweak the context you are working on.

Refresh

We’ve added the Refresh database quick-fix, which will help you if an object has been added to the database from somewhere else since the last time you refreshed your database.

Better filtering for MongoDB

In addition to ObjectId and ISODate, filtering now supports UUID, NumberDecimal, NumberLong, and BinData. Also, if you have a valid UUID/ObjectId/ISODate in your clipboard, you will see this value in the offered filters.

FilterRegexp

We’ve also added regular expressions to filtering, in case you are missing the LIKE filter from MongoDB.

FilterIDs

Other improvements

– In the data editor, if you edit a one-line string value, the down/up keys will finish editing it for you.

– In the event you are experiencing network issues, introspection in Oracle databases is now faster than it was before.

– The XML extractor is now a little bit better: If the original value is already XML, the extractor will not wrap it again in the extracted XML. If the value is not already XML, then special characters ‘<‘ and ‘>’ will be converted to xml entities: &lt; and &gt;

That’s all for today! Please try our new EAP build. Your feedback is welcome in our twitter or forum.

The DataGrip team

Posted in Uncategorized | Leave a comment

Workaround for SQL Server Authentication Issue on Windows

In DataGrip 2020.1.4 for Windows there is a problem with SQL Server authentication. We are currently addressing this issue and we expect it to be resolved in 2020.1.5.

There are two workarounds to fix the problem:

Downgrade to 2020.1.3 or switch to a different version of JetBrains runtime.

 

Downgrading to 2020.1.3

If you use the ToolBox application, you can downgrade directly from it.

Screenshot 2020-06-01 at 19.13.44

If you manually installed DataGrip, download the previous version here.

Switching to a different version of JetBrains Runtime

This workaround is more complicated but suits those who need to use the latest version of the IDE.

First, download the JetBrains Runtime from JetBrains BinTray storage. In this case, you need version 765.40 of the runtime. This is the version for Windows because the initial problems are Windows-specific.

Then install the Choose Runtime plugin in your IDE.

Screenshot 2020-06-01 at 19.13.36

After that invoke Search Everywhere (press Shift twice) or Find Action (Ctrl/Cmd + Shift + A) and search for Choose Runtime. In the dialog that opens, select the runtime you’ve just downloaded.

Screenshot 2020-06-01 at 19.13.16

Restart your IDE.

We hope that helps!

DataGrip team.

Posted in Uncategorized | Leave a comment

DataGrip 2020.1.4

Introducing DataGrip 2020.1.4

DBE-10715: [PostgreSQL] Fixed a time zone error affecting PostgreSQL versions prior to 10.
DBE-7578: DataGrip no longer refreshes the database after running a query in read-only mode.
DBE-9417: Targets in the Run Configuration dialog are now filtered by dialect.

Posted in Uncategorized | Leave a comment

Top 9 Spreadsheet Features of DataGrip You Have to Know

JetBrains DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, and many other databases.

TOP9-2020-2

DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP

When you work with databases, you’re exploring the data contained in them. And there are times you’ll want to manipulate that data without having to write queries. DataGrip has your needs covered with its smart data editor, a mini spreadsheet right inside your IDE.

Let’s take a closer look at some of the data viewing and editing perks inside DataGrip.

1. Data search

When working with a table, enter a filter condition written in SQL in the corresponding field as if you were writing a WHERE clause. DataGrip will query the database and return the data set that matches your filter.

Filter

To quickly find data inside a table without querying the database again, call up the text search with Ctrl/Cmd+F. This is especially helpful if you don’t know which column contains the data you’re looking for.

Find

Note that this search works only within the current page of the result set. You can enable All in the paging setting to make the text search look through the entire spreadsheet.

2. Navigation by foreign keys

All values with foreign keys are links! Use them to navigate to the related data for a particular value. In many situations this saves you from having to write a query.

In the example below we’re getting the name of a film that actor Grace Mostel starred in.

ForeignKeys

3. Copy and paste inside the editor

Like in a spreadsheet, you can copy several values and then paste them into some other part of the grid. You can even copy raw CSV content from an external source and paste it into the data editor!

CopyPaste

4. Expand selection

If you want to select a whole column or row to copy it, use the Expand Selection action: Ctr+W for Win/Linux and Opt+Up for MacOS.

To select a column, press once.
To select a row, press twice.
To select the whole grid, press three times.

GrowSelection

5. Powerful export

The data you select can be copied to the clipboard in any format! Select the format you want from the drop-down list and click Copy. For instance, if you choose JSON from the list, Ctrl/Cmd+C will copy the selected data to your clipboard with JSON formatting.

Export

Naturally, the whole table or result can be exported to a file in any format as well.

Even more interestingly, you can create your own clipboard and export formats! Read this tutorial to learn how to do that.

6. View options

The available formats can be used not only for copying or exporting to a file but also for viewing data. Want to see your results in plain text format? Just choose the Pretty format and then select Text in the view options.

ViewMode

You can also Transpose your grid. This makes it easier to view the spreadsheet if it has many columns.

Transpose

7. Column list

Another useful helper for grids with lots of columns is Column List. Call it via Ctrl/Cmd+F12. Then just type the name of the column you want to find and press Enter!

ColumnList

8. Export to database

A new table can be created from any data grid: a table, query result, or CSV file.

Imagine you need to JOIN two tables from two databases of different vendors. With DataGrip you can simply copy and paste one of the tables to the other database! Or perhaps you were waiting a whole hour for a query to finish, and now you want to play with the result. Create a table from it!

ExportToDatabase

9. Compare data

Two data grids can be compared. DataGrip will highlight the differences and let you manage the comparison criteria via the Tolerance parameter. Click the Compare button on the data editor toolbar and choose which result set or table you want to compare it with.

Compare

That’s all for now! We hope those of you already using JetBrains DataGrip found this post useful and learned some new superpowers. If you haven’t tried DataGrip yet, now is a great time to download it and try out the cool stuff from this post. And please remember to share your feedback with us!

DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP

Tweet @ us!
— Discuss anything in the forum.
— Report bugs to our issue tracker.

Your DataGrip team

Posted in Features | Tagged | Leave a comment

DataGrip 2020.1.3

Hello! Here’s a brief overview of the important things we’ve added and fixed in 2020.1.3

Features

DBE-1845: The data editor tab appears automatically for CSV files.

BF-CSvEditor


DBE-9993
: Pasting to the data editor automatically creates new rows.

BF-PasteData


DBE-8019: The data editor allows for scrolling beyond the last row.
DBE-10484: The file name is pre-selected in the dump data dialog.
DBE-8121: The dedicated node for trigger functions has been added to the database tree view.
DBE-10483: [MongoDB]: Collection references specified as string literals are now resolved correctly.
DBE-10410: [Redshift] Support for the syntax of materialized views has been added.

Bug-fixes

DBE-10408: No more UI freezes when editing large SQL strings.
DBE-9272: Save LOB works for the results of complex queries.

Posted in Uncategorized | 2 Comments

DataGrip 2020.1.2

Hello! This update fixes the problem that caused extremely high CPU usage.

Posted in Uncategorized | 2 Comments

DataGrip 2020.1.1 is Out!

Hi, here is the first bug-fix update for DataGrip 2020.1.

Important bug fixes:

  • DBE-10421: Using Cmd/Alt+1 to open the Database tree view also passes focus to it.
  • DBE-9957: Always Select Opened Element in the Services tool window can be disabled.
  • DBE-10383: Parts of cells from in-editor results can be copied.
Posted in Uncategorized | Leave a comment

DataGrip 2020.1

Hello!

We’ve just released DataGrip 2020.1.

Here’s a full list of all the improvements that 2020.1 introduces:

Run configurations

— Configuration for running script files
— Configuration for running code
— Support for utPLSQL and tSQLt

RC-RunSeveralFilesConfigurations

Data editor

— Results in the editor
— Geo viewer
— [MongoDB] Data filtering

DE-InEditroRes

Export options

— Export to Excel
— Better usability
— Text data viewer

EX-TextView

Connectivity

— [PostgreSQL] pg_pass support
— [SQL Server] Domain credentials support
— Shared SSH configuration

CO-SSH

Query console

— Update preview
— Easy navigation to Execute settings
— Datetime injection
— [MongoDB] Better coding assistance

QC-PreviewUpdateDialog

Navigation and search

— Context data sources scope
— Structural Search

NA-ContextDataSource

Working with files

— CSV file type
— Attach directory
— Mark as plain text

IM-EditToolbar

Database tree view

— UI for creating users and roles
— UI for creating schemas and databases

DT-UI

For more details please see the What’s new page.

Download DataGrip 2020.1

Posted in Uncategorized | Tagged | 6 Comments

DataGrip 2020.1 Release Candidate

Hi,

In the run-up to the 2020.1 release, which is scheduled for next week, here is a Release Candidate.

What’s new in this RC

The Import file action is now available:

– In the context menu of the CSV file, and
– In the context menu of the editor when a CSV file is opened.

Screenshot 2020-03-31 at 13.01.23
The text data viewer uses the color of the data source.

Screenshot 2020-03-31 at 13.03.51
The tab name becomes the file name when exporting data.

Screenshot 2020-03-31 at 13.19.52

Your DataGrip team

Posted in Uncategorized | 8 Comments

DataGrip 2020.1 EAP 4

Hello! Here are some improvements from the next build for the DataGrip 2020.1 EAP

CSV file type

DataGrip now has a registered *.csv file type. This means that you will no longer get a notification about CSV supporting available plugins. DataGrip also has the ability to edit CSV files as tables. You will see a floating toolbar with the Edit as Table button.

IM-EditToolbar

If you click this button and define the CSV format in the corresponding dialog, then the editable table with the content of your CSV file will open. Two tabs for the file become visible: Text and Data.

IM-Table

Easy navigation to Execute settings

If your file contains several queries, when you run one of them you’ll see the chooser.

Some people love this chooser, but some don’t. We’ve made it easier to customize the behavior of the Execute action.

QC-Customize

The customize link pictured above will lead you to Settings/Preferences, where you can define whether you want to see the chooser or always run the statement under the caret. You can also choose another type of behavior.

QC-CustomizeSettings

Stay tuned for more updates!

The DataGrip team

Posted in Uncategorized | 2 Comments