DataGrip 2019.3.1

Posted on December 19, 2019 by Maksim Sobolevskiy

Hello! This is the first bugfix update for DataGrip 2019.3. Here’s what it has inside:

  • DBE-9708: A new option lets you choose whether you want to use schema qualifications when using JOIN.

Screenshot 2019-12-19 15.25.39

  • DBE-9736: The table filter is cleared when opening a table from the database explorer.
  • DBE-9743: The correct schema is used when adding a foreign key.
  • DBE-9728: Fixed the bug with queries seeping into column names.
  • DBE-9714: Right-clicking on a column header shows the menu again.
  • DBE-8196: A new registry option to remove the schema qualification when updating data.
Posted in Uncategorized | Leave a comment

DataGrip 2019.3: MongoDB support, Debugger for Oracle, Inline query progress and more!

Posted on December 3, 2019 by Maksim Sobolevskiy

We’re pleased to introduce DataGrip 2019.3. This is the third major update of 2019, and it’s packed with various enhancements. Let’s take a look at what it has to offer!

DGR

MongoDB support

The day has finally come for us to start adding MongoDB support. Since the request received more than 400 votes, we decided that the time was ripe to begin including basic functionality for it.

UD-Mongo

Here’s a quick overview of the MongoDB features that work in this version:

Introspection: You can observe collections and fields in the database explorer.

Data viewer: Open any collection or observe the query result and you have the option to sort it by column or filter the values. Paging works, as well.

Tree view: It’s also possible to explore a tree view of the data. To turn it on, click the Gear icon | View as… | Tree.

Query console: To run a statement, put the caret on it and run the console by pressing Ctrl/Cmd+Enter, or use the Play button on the toolbar.

Oracle PL/SQL debugger

In this first version of the long-awaited PL/SQL debugger, you can debug procedures, functions, triggers, and anonymous blocks, and observe variables.

UD-Debug

You can visit our help page to learn more about how the debugger works. If you have any feedback for us about the debugger, please don’t hesitate to post it in the corresponding issue.

Working with the source code

  • Diff viewer for routines
  • 3-way merge
  • Code prettifier in PostgreSQL
  • Intentions now work inside the source codes

UD-Sources

Running queries

  • Inline query progress
  • Flame chart for explain plan

UD-InlineProgress

Coding assistance

  • New inspections
  • New intention actions
  • An option to sort lines alphabetically
  • An option to search only in a selected area
  • Resolve respects filtering
  • New items in the Generate menu

UD-EqualsNull

Data editor

  • There are no longer problems with ambiguous names in the result-set.
  • The Modify Table action is now available from the data editor context.

UD-DataEditor

To take in all the new features with full descriptions, please visit the What’s New page.
You already know all of this, but just as a quick reminder:

Thank you for your attention!
Your DataGrip Team

Posted in Features, Releases | Tagged , | 6 Comments

DataGrip 2019.3 EAP 4

Posted on November 15, 2019 by Maksim Sobolevskiy

Hello, today we have a new build for the DataGrip 2019.3 EAP for you to try.

DBE-7976: The Modify Table action is now available from the data editor context. Want to add a new column while editing table data? Just press Ctr/Cmd+F6 and go ahead!

Screenshot 2019-11-15 00.51.31

DBE-9336: Intentions now work inside the source code of routines. For example, if you want to expand the wildcard via Alt+Enter on an asterisk, now this is possible.

Screenshot 2019-11-15 00.46.53

DBE-9548: Now if your result-set contains multiple columns with the same name, you won’t have any problems with ambiguous names if you create a table from it.

Screenshot 2019-11-15 00.50.41

DBE-9428: A new intention is introduced to help you convert JOIN ON to JOIN USING, and vice versa.

Screenshot 2019-11-15 00.47.14

That’s all, folks!

The DataGrip Team

Posted in Uncategorized | Leave a comment

DataGrip 2019.3 EAP 3

Posted on November 8, 2019 by Maksim Sobolevskiy

Hello! It’s time for a new EAP build for 2019.3 which is due for release this December.

Tree data view

We’re continuing to build on the MongoDB support. We’ve just crossed another milestone with this process by adding the tree data view.

TreeView

To turn it on, click the Gear icon -> View as… -> Tree.

Inline query progress

Now you can clearly see when your query is running: there is a spinning icon on the gutter and the inline live timer as well.

Progress

Flame chart for explain plan

We’ve added a new type of visualization for the explain
plan results. To see it, click the corresponding button on the right. It is just under the
diagram button.

FG1

Here’s how it looks:

FG2

New inspections and warnings

If you try to paste null into a not nullable column, you will get:

InspNullColumn

If the first argument in your COALESCE call is not nullable, you will get:

InspCoalesce

If you use TOP and OFFSET simultaneously in SQL Server, you will get:

InspOffset

That’s all, folks!

The DataGrip Team

Posted in Uncategorized | 8 Comments

DataGrip 2019.2.6

Posted on October 31, 2019 by Maksim Sobolevskiy

DataGrip 2019.2.6 is Out!

– Result tabs switch with the consoles again.
– No more freezes on MacOS Catalina when exporting data. DBE-9334 
– Fixed the bugs with the external tables in Redshift not showing. DBE-9181 
– Various bugs with paging are fixed. DBE-9217 
– Column names are no longer collapsed when the data editor is transposed. DBE-8904 
– The “column specified more than once” error does not appear for data import anymore. DBE-9283 
– The table and column comments are not truncated anymore. DBE-8000 
– There are no longer false warnings about the number of values when selecting the identity column. DBE-8924 

Posted in Uncategorized | Leave a comment

DataGrip 2019.3 EAP 2

Posted on October 11, 2019 by Maksim Sobolevskiy

Hello! It’s time for the new EAP build for 2019.3 that is going to be released this December. Let’s take a look at several new features.

Oracle PL/SQL debugger

We’ve started working on a debugger for Oracle PL/SQL. Right now, it provides just basic functionality: you can debug procedures, functions, triggers, anonymous blocks and observe variables there.

Updates to this feature and additional information will appear in the corresponding issue.

EAP-11-DEBUG

Search with Google for connection error

It’s now easier to deal with connection errors! When a connection fails, it’s possible to Google the error text using the corresponding button.

EAP-11-SWG

Drop action keyboard shortcut remapping

We’ve updated the Drop action and made it available for shortcut remapping. Before, it used the shortcut of the Delete action. If you don’t want to have the default shortcut for the Drop action, it’s now possible to remap it from the settings.

EAP-11-DROP

That’s it!

The DataGrip team.

Posted in Uncategorized | 5 Comments

DataGrip 2019.3 EAP is Open!

Posted on October 4, 2019 by Maksim Sobolevskiy

Hello! We have begun our DataGrip 2019.3 EAP and there is something really exciting inside.

MongoDB support

Finally, the day has come for us to start working on MongoDB support. After more than 400 votes we have decided now is a good time to begin including at least some very basic functionality.

What actually works now:

Introspection

You can observe collections and fields in the database explorer. We fetch the first 10 documents from each collection to get information about the fields. This can be customized via the JDBC parameter fetch_documents_for_metainfo which is available in the Advanced tab of the data source properties dialog.

00-EAP-MongoExplorer

Data viewer

Open any collection or observe the query result and you can sort by columns or filter the values also paging works as well.

EAP-00-MongoData

Query console

There is currently no coding assistance, but this doesn’t stop you running queries and getting the results. To run a statement, select it and run it via Ctr/Cmd+Enter or by using the Play button on the toolbar.

EAP-00-MongoConsole

These commands are available right now:

use <database>
show databases or show dbs
show collections
db.collection.find().skip(n).limit(m)
db.collection.find({...})
db.collection.count()
db.collection.insert({…})
db.collection.delete({…})
db.collection.deleteOne({…})
db.collection.update({…}, {…})
db.collection.updateOne({…}, {…})
db.collection.createIndex({…})
db.collection.listIndexes()
db.collection.aggregate(…)
db.collection.runCommand(…)

The EAP program stage is the best time to provide your feedback, so please comment here or create issues in our tracker.

3-way source code merge

When you submit source code and DataGrip determines that it was changed while you were editing it, a notification will pop up. This notification will suggest you to resolve the conflict by way of a three-way-merge.

EAP-02-Merge

Also, don’t forget that if you want to make sure that you won’t be deleting someone else’s work by submitting an outdated object, the Warn if editing outdated DDL option should be turned on.

00-EAP-Warn

That’s it!

DataGrip team.

Posted in EAP | 6 Comments

DataGrip 2019.2.5

Posted on September 26, 2019 by Maksim Sobolevskiy

Hi! We have an update for 2019.2. Some bug-fixes are inside.

– Improvements in H2 grammar support.
– DBE-7893 [PostgreSQL] Procedure is back to the Generate menu.
– DBE-9098 Fixed the bug with importing data from CSV files that include an IDENTITY column.
– DBE-9105 Numbers at the beginning of table names are supported again.
– DBE-9093 The Replace IN intention doesn’t corrupt code anymore.

Posted in Uncategorized | 3 Comments

DataGrip 2019.2.4

Posted on September 12, 2019 by Maksim Sobolevskiy

Hi! We have an update for 2019.2. Some bug-fixes are inside.

– DBE-8977 Compare content action has been added to the context menu of two tables.

Screenshot 2019-09-12 12.21.03

– We’ve fixed some problems with the Help plugin’s compatibility.
– DBE-9021 UUIDs are now quoted when navigating to referenced rows.
– DBE-8897 Full-text search results are now sorted alphabetically.
– DBE-1878 DataGrip offers to introspect the schema if it’s used in the console.

Posted in Uncategorized | Leave a comment

DataGrip 2019.2.2

Posted on August 16, 2019 by Maksim Sobolevskiy

Hi!

This update for DataGrip 2019.2 is huge. Not only many bug fixes are here, but some cool features as well!

Features

DBE-4499 We’ve added JOIN completion based on column names.

Completion

 

DBE-2640 The markdown data extractor is bundled with DataGrip!

Markdown

 

DBE-7315 Drag-and-drop of columns became smarter: now it adds commas!

DragNDrop

 

DBE-8239 Breadcrumbs are now shown for SQL as well.

Screenshot 2019-08-16 11.16.10

DBE-5661, DBE-7960 [PostgreSQL] Support for partition tables is improved. The key enhancement: partition tables are now displayed under the main one.

PArtititons

Bug fixes

IDE general

DBE-8380, DBE-8769, DBE-8778, DBE-7107 Performance improvements.
DBE-8633 The folder path became editable in SQL Dialects settings section.

Code generation

DBE-8835, DBE-8376 Schema comparison: the same objects are not marked as different anymore.
DBE-8826 [Oracle] No more disappearing semicolon in the package code.
DBE-6261 [Oracle] Column names are not missed from view’s code anymore.
DBE-8344 [DB2] Editing procedures is available on DB2 for i (AS/400).
DBE-8889 [Sqlite] Check constraints do not disappear after the update.

Data editor

DBE-5165, DBE-8732 Fixed bugs in file import.
DBE-8857 Fixed problem with the column width when using the Material Theme plugin.
DBE-8788 BLOB fields are displayed correctly.
DBE-8433 The Forward and Back buttons don’t run queries anymore.
DBE-6601 The Ctrl/Cmd+F12 shortcut in the filter field of the data editor opens the columns list.
DBE-8511 The Go To Related Data action enabled showing only required rows.

Database explorer

DBE-8728 Adding a new schema doesn’t remove items from the database explorer.
DBE-8871 [Redshift] External tables are back!

Coding assistance

DBE-8845, DBE-8767, DBE-6776 Fixed bugs in the SQL formatter.
DBE-8850 [Exasol] DROP INDEX support.

DBE-8895 Results in Find Usages are sorted by the line number.

Develop with pleasure!
DataGrip team

Posted in Uncategorized | 4 Comments