The DataGrip Blog : The Cross-Platform IDE for Databases & SQL

The DataGrip Blog

The Cross-Platform IDE for Databases & SQL

Latest posts

View all posts

Hello! We've released DataGrip 2012.1.3! The problem of bad handshakes with old servers Due to their security policy, Java dropped the usage of the TLSv1 and TLSv1.1 protocols. This caused a problem when connecting to old servers that accept only these protocols. As a fix, we now offer you the ability to explicitly turn on these protocols, though you need to keep in mind that doing so result

Hello! We’re starting our EAP program for DataGrip 2021.2. We would really appreciate you trying out these new features and sharing your feedback with us – it helps us make the release better! Let's go! DDL data source Generation from a real data source It is now possible to generate a DDL data source based on a real one. The DDL files will be created on the disk and the new data source w

Hello! Today we’ve got a new minor update for DataGrip 2021.1. Let's see what’s been improved. Features DBE-13048: Some run configurations require the data source to be disconnected first. Now it’s possible to disconnect from a data source before launch. DBE-12906: We’ve introduced a Modify grants action. Introspection DBE-6276: [PostgreSQL] Support for security policies. DBE-13138 [Redshift] Support for sort keys for tables and views. DBE-13024: [Redshift] Fixed the bug with the completely failed introspection. DBE-12442: [Oracle] Source code is retrieved correctly for Oracle 9i. DBE-13146: [Oracle] Type attributes are retrieved correctly for Oracle 11. DBE-12954: [BigQuery] No more missing schemas. DBE-12166: [BigQuery] Creating a temporary function doesn't re-run the introspection. Navigation and search DBE-12901: It's possible to navigate to the data source from the Database tab of the search. DBE-11738: The Context data source scope works again in search. DBE-12968: Color settings are respected again in search. DBE-13090: View DDL from data works again. DBE-5341: Go to related symbol has been added to the context menu of the object in the code editor. DBE-4960: [PostgreSQL] Go to related symbol works for navigating from triggers to the related procedure, and vice versa. DBE-13033: Navigation by foreign keys supports references to one column. DBE-13037: Scroll from editor works from the data editor. DBE-12967: [SQlite] Full-Text Search uses LIKE to search within LONGVARCHAR fields. Data viewer DBE-5435, DBE-11780, DBE-12827, DBE-11591: Fixed some bugs with missing ctid columns. DBE-13150: The data diff viewer works again. DBE-13126: Text search works when invoked a second time. DBE-12985: [MySQL]: The default value for the date field is now correct. DBE-12940: The Toggle Soft-Wrap and Toggle Formatting buttons don't disappear anymore. DBE-12594: Formatted mode for XML no longer removes all spaces. Code generation DBE-8654: Run routine generated code contains qualified objects. DBE-12934: Argument direction is taken into account when modifying the routine. DBE-12873 [BigQuery] Int64 is the default type when creating a new column. DBE-12892 [BigQuery] Dropping views now works. Code highlighting DBE-9813: [Clickhouse] Support for CREATE DICTIONARY. DBE-12996: [Clickhouse] Support for EXISTS (database | dictionary | view) statements. DBE-12993: [Clickhouse] Correct syntax highlighting for CREATE OR REPLACE. DBE-12994: [BigQuery] Support for EXPORT DATA, TABLESAMPLE SYSTEM, CREATE SCHEMA, ALTER SCHEMA, and DROP SCHEMA. That's all for today! The DataGrip team

🔥 Important content!We’ve released the DataGrip overview video, covering all the major capabilities of our IDE. We bet you’ll learn something new today!No matter how experienced of a DataGrip user you are, there’s always room for improvement.

Hello, This is the first minor update for DataGrip 2021.1. Check out what’s new inside! Important fixes

Today we’re introducing DataGrip 2021.1, our first major release this year and possibly the most remarkable release in the history of our IDE. We hope you will find that v2021.1 addresses at least one of your pain points, or maybe you will discover a new feature you’ll love or both. Let’s dive in! UI for grants Grants can be modified from the Modify object and Modify user/role dialogs. This

Releases

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 W

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 crop

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 configu

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

Features

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

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

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

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