Hello! In this post about our third EAP build for 2020.3, we'll describe just one feature – but it’s a huge one: SQL for MongoDB TL;DR – You can now use SQL to query MongoDB databases. Only SELECT queries work. Working сlauses: JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET. SELECT Options you can use: DISTINCT, ALL. You can use aggregate functions: AVG, SUM, MIN, MAX, and others. Columns can be qualified. Restrictions COUNT (expression) is not yet supported. You can't use aggregate functions, such as AVG, SUM, MIN, and MAX, as if they were not aggreg

Hello! We've got something new for you in this fresh EAP build. Azure AD authentication The DataGrip community has been asking for this for a while! You can now use Azure AD to log in to your database. Collect introspection diagnostic information Introspection is the process by which DataGrip retrieves information about a database. This information is used to show the objects in the database explorer, display their DDLs, suggest them during completion, and so on. Sometimes introspection runs into problems. Now, when things go wrong, you can collect useful data that you can pass on t

For those of you who are eager to try the newest things, we invite you to join our Early Access Program for DataGrip 2020.3. As you may know, these builds don’t require a license – we just want everybody to try the new features out before the official release. Let’s go! Couchbase support We're always happy to welcome a new database into our family, and our newest member is Couchbase! It's important to mention that DataGrip supports the Couchbase Query service, not the Couchbase Analytics service. Introspection Grants The most important enhancement in this aspect is that DataGrip now k

Important fixes: DBE-11340: The username and password fields no longer disappear. DBE-11156: When updating the source code, if a new version contains errors and fails to be submitted, you'll now see a prompt to restore the previous version.

Hello! This is the first update for DataGrip 2020.2. We’ve fixed some bugs, and here’s a list of the most important ones: DBE-11268: The annoying bug causing the parameters pop-up to appear instead of the context menu has been fixed. DBE-10951: No more freezes when editing CSV files. DBE-10749: Code completion inside OVER clauses works again. DBE-11243: Filters are respected when migrating databases. DBE-10590: No more high memory consumption during export to Excel. Also now DataGrip fully supports the grammar of Greenplum 6.9! DataGrip team

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 cropped data — Export to the clipboard in the context menu of the data editor SQL editor — Inspection widget — Introduce variable — Suggested rename — Even better JOIN completion — Refresh database quick

This is the release candidate for 2020.2. Check out these publications for a reminder of what's new in this version: 2020.1 EAP 1 2020.1 EAP 2 2020.1 EAP 3 Please try it and share your feedback with us!

Hello, Here is a new build as part of our DataGrip 2020.2 Early Access Program. Google BigQuery dialect We’ve added a new SQL dialect: Google BigQuery. Full support for BigQuery is not here yet, but all things must begin somewhere. So far, DataGrip can correctly highlight and provide coding assistance for your queries if you use Google BigQuery. TextMate bundles TextMate, a text editor for Mac, offers syntax highlighting bundles for many languages. We can import and use them in DataGrip. Starting with this release, the IDE will provide syntax highlighting for the file types register

Introducing DataGrip 2020.1.5! Check out what’s new inside! Most important The issue with SQL Server Authentication on Windows is fixed. Other fixes DBE-9876: Forced execution in read-only mode now runs the correct query. DBE-10727: Schemas comparator respects column order. New features A new quick-fix is available: Refresh schema. If your colleague adds a new object after you have already refreshed your database, this fix will make sure your query is properly highlighted. We have also renamed the migration buttons in the schema comparator to make it clearer what they actuall

Hello! Please welcome the newest build of our DataGrip 2020.2 EAP. Separate editor for cell values Now if you have a huge value in your cell, it can be viewed or edited in a separate panel. You can also toggle soft wrap mode using the right-hand toolbar. DML preview in the data editor Starting with this version, you can review the query that represents your changes in the data editor. This query is not the exact SQL that will be run to modify your data, because DataGrip uses a JDBC driver to update tables, but most of the time it will be the same. So, now you have There is now a DML

Hi! We've released the new version of the MongoDB JDBC driver, which means that DataGrip now includes support for the new MongoDB Shell out of the box. This is the result of a close collaboration between engineering teams at MongoDB and JetBrains, and we are excited to finally release it to all our users. If you use DataGrip to work with MongoDB and Atlas, you get a console/shell experience that is 100% consistent with what you get in MongoDB’s own shell and other MongoDB developer tools. To use the newest version of the driver, just update it in the properties window of your MongoDB dat

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