Improvements DBE-12590: Data source colors are now displayed in the Run Configuration UI. Fixes
Hi! A new DataGrip 2021.2.4 bug-fix update is available! We've fixed some bugs, here's a list of the most important ones:
DataGrip 2021.2 EAP is Open!
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 will be based on them. That way you'll always be able to regenerate these files and refresh the DDL data source.Let's take a look at how it works.The new menu item Dump to DDL data source is added to t
DataGrip 2020.3 EAP is Started!
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 knows ab
We open EAP for DataGrip 2020.1
Hello! It’s time to start our EAP for 2020.1. As usual, you don’t need to have a subscription to use them, and regardless of whether you have a subscription or not, we would still truly appreciate your participation. Your feedback will help us ensure that what we release this April is of the highest quality! So, let’s take a look at what’s featured in the EAP! Run configurations This concept is already in use in our other IDEs, and it’s now come to DataGrip. In general, if you want to run something, you just need to create a configuration for it. Let’s look at how this can help you with parti
DataGrip 2019.2 EAP 2
Hello! Please welcome the newest build of our DataGrip 2019.2 EAP. Full-text search The Full-text Search dialog has a nice new look. The whole mechanism has had several improvements made to it: – In PostgreSQL, MySQL, and MariaDB you can now switch it to only search in columns that are indexed. To use this mode, choose ‘Only columns with full-text search indexes’ in Search in the drop-down menu. The query in PostgreSQL will be: `where col @@ plainto_tsquery('query')` The query in MySQL and mariaDB will be: `where match(col) against ('query' in natural language mode)` – The search lo
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 probably have many! Let’s have a closer look at some of the nice SQL-related perks inside DataGrip. 1. Live Templates DataGrip has code snippets called Live Templates. Use them to generate repetitive parts of
Hello, Here it is, the second minor update for 2018.3 with some added improvements. The most notable feature is: Enum values can now be completed in the data editor. This works in both PostgreSQL and ClickHouse. Other important fixes we’ve made: DBE-7561: DataGrip doesn’t change the default value of a column in MySQL. DBE-7572: CREATE OR REPLACE is supported for MariaDB events. DBE-7604: Hidden schemas are not used in comparison now. DBE-7417: Report mismatch between expected/actual column count in the SQL Server OUTPUT clause is fixed. DBE-7457, DBE-7458: DataGrip doesn’t
DataGrip 2017.1 Released!
Hello! From this post you'll find out what's new in DataGrip 2017.1. It is a long read, so let's begin with the table of contents. Database tree: New schema management, SQL resolution scopes; Create database/schema UI; Color settings affects editor and grid. Import/export data: Column mappings and DDL preview; Drag-n-drop tables; Export result-set to a database. Query Console: Respecting the default search path in PostgreSQL; Trigger generation pattern; Insert string concatenation on Enter option; Settings for Qualifying objects and more. Database objects: Double-cliсk ope
DataGrip 2016.2 is Out!
Hello, everybody! We are excited to release DataGrip 2016.2 and this version brings many interesting features. As usual, we thank all our early adopters who helped us make the IDE better during this release cycle. What is in DataGrip 2016.2? tl;dr: UI for importing CSV files, JSON and XML support in literals, regular expressions checking, dynamic SQL support, completion in tables, keyboard layout aware completion, recompile packages in Oracle, search path support for PostgreSQL and much more. Let's look closer. Database view Some changes happened to the instrospector. We've replac
We Open DataGrip 2016.2 EAP
We are glad to open the EAP (Early Access Program) for DataGrip 2016.2. As usual, it means that you can try new features before the official release. Read on to find out what's new, improved and already available. When you install DataGrip on Windows, you will be offered to associate *.sql files with DataGrip. Also, it is possible to open *.sql files from the "Open with" context menu: We've added completion for database names in the connection dialog. Make sure you're logged in to the server, and then press Ctrl+Space (Cmd+Space for Mac): Database view Some changes happened
DataGrip 2016.1 Released!
Hello! Like all other desktop products from JetBrains, DataGrip is switching to the new versioning scheme. So please give a warm welcome to the next release, DataGrip 2016.1. For those of you who were curious and impatient to try the newest things in this update, we did open an EAP program a month ago. We thank all of the EAPers who helped us by test-driving all the new features we added in DataGrip 2016.1. Let's have a look at them. Connectivity We've improved the interface for using the SSH tunnel. SSH/SSL tab is not hidden anymore depending on the driver—you can always se