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

Hi, here is the first bug-fix update for DataGrip 2020.1. Important bug fixes: DBE-10421: Using Cmd/Alt+1 to open the Database tree view also passes focus to it. DBE-9957: Always Select Opened Element in the Services tool window can be disabled. DBE-10383: Parts of cells from in-editor results can be copied.

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 configuration Query console — Update preview — Easy navigation to Execute settings — Datetime injection Navigation and search — Context data sources scope — Structural

Hi, In the run-up to the 2020.1 release, which is scheduled for next week, here is a Release Candidate. What’s new in this RC The Import file action is now available: – In the context menu of the CSV file, and – In the context menu of the editor when a CSV file is opened. The text data viewer uses the color of the data source. The tab name becomes the file name when exporting data. Your DataGrip team