The DataGrip Blog : The Cross-Platform IDE for Databases & SQL

The DataGrip Blog

The Cross-Platform IDE for Databases & SQL

Latest posts

View all posts

Today we’re releasing the second minor update for 2021.2, which introduces several important improvements and fixes. Improvements DBE-2216: Wildcards are now considered as column usages. DBE-13773: Ctrl/Cmd+Click from the navigation bar correctly navigates to the desired element. Fixes DBE-12656: Enable DBMS_OUTPUT works immediately after being turned on.

This post is for people familiar with SQL Server Management Studio who have decided to try DataGrip with SQL Server. Some concepts, pieces of the user interface, and shortcuts differ between these two tools. We'd like to try and help you with this transition! TLDR: table SSMSDataGripConnects to any running serverTCP/IP and SQL Server Browser should be enabledAll databases and schemas are sho

Today we’ve got the first minor update for 2021.2 for you, with several important improvements and fixes. Improvement DBE-4978: Inlay hints appear in SET statements. If you turn on For set operations in Preferences | Editor | Inlay Hints | SQL| Show column names, you will get column hints for statements inside set statements, for example, UNION statements. Fixes DBE-9198: The Re

DataGrip 2021.2 is here! This is the second major update of 2021, and it’s packed with various enhancements. Let’s take a look at what it has to offer! For a detailed description of this update, please visit our What’s new page. DDL data source Generation from a real data sourceCreating objects Diagrams Table comments are now visibleTable colors are also displayed on

We’ve all been in situations where we thought we lost something forever, a text file or a photo, perhaps. But then somehow we found a way to recover it. The relief you feel in that moment can stay with you for a long time. DataGrip can be a really powerful tool for recovering your queries, even if it can't recover all your data. Read on to learn about what it can do. Query history D

Hello! The third EAP build for 2021.2 is available! Try it out and share your feedback with us. Now there is the ability to add columns to MongoDB collections. This action lets you add a new field to any document of a collection. Delete column will delete data not only on the page that is being displayed, but also throughout the whole collection. Navigation We've made the

Releases

We’re pleased to introduce DataGrip 2020.3. This is the third major update of 2020, and it’s packed with various enhancements. Let’s take a look at what it has to offer! SQL for MongoDB SELECT, FROM, JOIN, WHERE, HAVING, GROUP BY clauses Functions and object builders are supported JS query preview Copy JS query to clipboard Connectivity Couchbase support Azure AD authentication W

Hello everybody! Today we release DataGrip 2020.2! As usual, we thank all our early adopters who helped us make the IDE better during this release cycle. Here's a brief overview of the new version. For a detailed description of this update, please visit our What’s new page. Data editor — Separate editor for cell values — DML preview in the data editor — New UI for boolean values — New UI for crop

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 Data editor — Results in the editor — Geo viewer Export options — Export to Excel — Better usability — Text data viewer Connectivity — Shared SSH configu

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! 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. Here’s a quick

Features

People often ask us: – Do you have a query book? I have numerous queries I run time after time. I want to store them and to be able to call any of them when I want. There's an issue for this feature in our DataGrip issue tracker. While we don't have a feature specifically named query book, we believe there are approaches you can take with DataGrip that cover the majority of these needs: live

JetBrains DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, and many other databases. 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

Hello! We’ve just released DataGrip 2019.2. In this post, we’ll highlight the new features briefly. For detailed descriptions, please visit the What’s new page. Services tool window — Observe and manage all the connections — Manage Docker services — Query live timer Full-text search — Search for data everywhere — SQL preview — Search in columns that don’t support the LIKE operator

Hello! No long preamble, we have begun our DataGrip 2019.2 EAP! Let’s look at what’s inside. Services tool window All our IDEs now have a new tool window called Services. In DataGrip, you can observe and manage all the connections there. Here is how it looks: Every connection has its own node under the corresponding data source. If the small green light on the icon is on, it means tha