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

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

Introducing DataGrip 2020.1.4 NB! KNOWN ISSUE! This update breaks the Windows authentication to SQL Server. This problem will be fixed in 2020.1.5, the workarounds are described here. Fixes: 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.

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 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, ent

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. DBE-9993: Pasting to the data editor automatically creates new rows. 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. Bug-fixes DBE-10408: No more UI freezes when editing large SQL strings. DBE-9272: Save LOB works for the

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