Query Book in DataGrip
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
Top 9 Spreadsheet Features of DataGrip You Have to Know
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
DataGrip 2019.3: MongoDB support, Debugger for Oracle, Inline query progress and more!
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
DataGrip 2019.2: services, full-text search, filtering in navigation, easy paging, naming of results tabs, query live timer and more!
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
DataGrip 2019.2 EAP
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
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 f
Top 9 SQL Features of DataGrip You Have to Know
DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, and many other databases. DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP One of the most important activities for anyone working with databases is writing SQL. Built on IntelliJ Platform, DataGrip makes coding an enjoyable experience by automating repetitive tasks: as an SQL developer, you probabl
DataGrip 2019.1 EAP is started
For those eager to try the newest things, we invite you to join our Early Access Program for DataGrip 2019.1. 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! New databases: Greenplum, Vertica, and Apache Hive In this release cycle, we focused a lot on supporting several new databases. Gre
DataGrip and GitHub: Step-by-step Integration
All IDEs based on the IntelliJ Platform have Version Control System integration. DataGrip is no exception! But because database developers usually do things a little differently from other developers and because DataGrip’s project model has its own specific workflow, the integration between the IDE and VCS support isn’t quite as straightforward as with other JetBrains IDEs. We’ll cover two
DataGrip 2018.2.2: ClickHouse Support and Bugfixes
With just a few weeks since the last minor update, we're in hurry again to bring you a fresh portion of improvements. Please welcome DataGrip 2018.2.2. One of the highlights in this update is added support for ClickHouse (an open-source analytic DBMS for big data from Yandex). The update offers a dedicated driver, and allows you to browse the tables, views, table data, run queries, and pretty m
DataGrip 2017.3 is Released!
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; especia
The Many Ways of Exporting Data in IntelliJ-based IDEs
In DataGrip, as well as all other JetBrains IDEs that feature database support, there is a powerful engine to export data in many formats. You can even create your own export format. Let’s look closer at this engine. Export directions Any table/view or result-set can be exported to a file or copied to the clipboard. To export to file: — Context menu on a table/view and → Dump da