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 Working directory Data editor Separate editor for cell values: Formatted value Separate editor for cell values: Bottom position Separate editor for cell values: Images O

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 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 th

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 Data editor — The page size is easy to change — The results tabs can be named Database tree view — Quick table backup — Quick group creation — Force Refresh action — Table comment

Hello everybody! We are excited to release DataGrip 2019.1 today! As usual, we thank all our early adopters who have helped us make the IDE better during this release cycle. If you wish to see the detailed overview of this update, please visit our What’s new page. Read on for a list of all the enhancements waiting for you in 2019.1. Support for new databases In this release cycle, we focused a lot on supporting several new databases. Greenplum is an analytics database based on PostgreSQL. It is currently developed by Pivotal and the open source community. Vertica is column-or

When it comes to the tools of your craft, it never hurts to make sure that you are always working with the most stable version. Please meet DataGrip 2018.2.4. Inside you’ll find the following have all been fixed: DBE-7023 The Find Action not working when invoked from the Welcome Screen DBE-7019 The JSON exported data being formatted to scientific notation instead of flat DBE-7012 The import of a custom enum type to PostgreSQL from CSV not working DBE-6996 The ClickHouse datasource not properly loading after an IDE restart DBE-7007 The MySQL dialect configuration change which was lo

Hello! Please give a warm welcome to our new major release, DataGrip 2018.2! Starting with this version, the database functionality of IntelliJ-based IDEs is available in CLion and AppCode. So if use one of these IDEs welcome to our blog :) Also, those who use WebStorm and DataGrip simultaneously can now install a database plugin inside WebStorm. We thank all of the EAP contributors who have helped us by testing all the new features added in this release. Let’s have a look at what’s in there. — SQL log — New SQL formatter — Running stored procedures — Source code migrations —

Please welcome DataGrip 2017.3, the third big update of 2017, packed with various enhancements. Let’s have a look what it has to offer! — Database tree view — SQL — Executing queries — Connectivity — Data editor — Navigation Database tree view Group data sources Closing an old outstanding ticket with a number less than 100 is not a situation that we frequently find ourselves in; especially when it’s for such a long-awaited feature. We are happy to introduce you to our new feature: group data sources. Press F6 or choose Move to group… from the context menu. Group is the attribut

Hello!  From this post you'll find out what's new in DataGrip 2017.1. It is a long read, so let's begin with the table of contents. Database tree: New schema management, SQL resolution scopes; Create database/schema UI; Color settings affects editor and grid. Import/export data: Column mappings and DDL preview; Drag-n-drop tables; Export result-set to a database. Query Console: Respecting the default search path in PostgreSQL; Trigger generation pattern; Insert string concatenation on Enter option;  Settings for Qualifying objects and more. Database objects: Double-cliсk ope

Hello, everybody! This release cycle was really important for DataGrip — triggers support, find usages inside views/procedures, bulk submitting of changes: all these features were long-awaited and we thank everybody who helped us provide them in the right way during our EAP program. We are excited to release DataGrip 2016.3! As usual, everything described here is also available in 2016.3 version of IntelliJ IDEA, PyCharm, RubyMine and PHPStorm, except one small feature we will tell you about. Here we go! Source code storage Now DataGrip shows triggers, views, and materialize

Hi! We are rushing to the release in the end of November, and here is the release candidate for 2016.3! Among various bug-fixes a couple of new features were added since the last EAP: Navigate to the next method, familiar to many of you from our other IDE’s now works in DataGrip. It’s called Navigate to the next statement and should be invoked by Alt+Down and Alt+Up (Ctrl+Down and Ctrl+Up for OSX). If you run large script files from the context menu, please know that now they are executed much faster. We'll be happy if you try this build and follow us not to miss the huge b

Hello, everybody! We are excited to release DataGrip 2016.2 and this version brings many interesting features. As usual, we thank all our early adopters who helped us make the IDE better during this release cycle. What is in DataGrip 2016.2? tl;dr: UI for importing CSV files, JSON and XML support in literals, regular expressions checking, dynamic SQL support, completion in tables, keyboard layout aware completion, recompile packages in Oracle, search path support for PostgreSQL and much more. Let's look closer. Database view Some changes happened to the instrospector. We've replac

Hello! Like all other desktop products from JetBrains, DataGrip is switching to the new versioning scheme. So please give a warm welcome to the next release, DataGrip 2016.1. For those of you who were curious and impatient to try the newest things in this update, we did open an EAP program a month ago. We thank all of the EAPers who helped us by test-driving all the new features we added in DataGrip 2016.1. Let's have a look at them. Connectivity We've improved the interface for using the SSH tunnel. SSH/SSL tab is not hidden anymore depending on the driver—you can always se