DataGrip 2019.2 EAP 2
Hello! Please welcome the newest build of our DataGrip 2019.2 EAP.
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 looks in columns which don’t support the LIKE operator, for instance, columns of JSON type. Values in these columns are converted to string type beforehand.
– In Cassandra, DataGrip creates several queries for one table, because the OR condition isn’t supported by the database.
Drag-and-drop now works for creating groups in the database explorer.
If you want to create a new group, just drag-and-drop one data source onto the other.
If you want to place the data source into an existing group, drag-and-drop it there.
Working with queries
Before, when working in the read-only mode we had some inconsistency: if a user wanted to run an update query from the read-only mode, we turned off only the IDE-level mode, but not the JDBC one (DBE-8145). Now though, we turn off both so you can run the query if you really need to.
A new action is available: Select current statement. You can get to it from Find Action (Ctrl/Cmd+Shift+A) or assign it a shortcut of its own.
New combined items are now in code completion: IS NULL and IS NOT NULL.
And we’ve added another intention action: now you can convert GROUP BY to DISTINCT if all the columns of a SELECT clause are presented in a GROUP BY clause.
That’s all for this new EAP! Stay tuned for the next EAP release coming your way; 2019.2 is going to be cool.
Subscribe to Blog updates
Thanks, we've got you!
DataGrip 2023.2: New UI with toolbar icons in the header, AI Assistant, time zones in the data editor, support for Redis Cluster
DataGrip 2023.2 is out!Here’s a sneak peek at what it has to offer. For a detailed description of this update, please visit our What’s New page. User Interface New UI: The toolbar icons have been moved to the header Improved main toolbar customization Light theme with light …
DataGrip 2023.2 EAP 2: Redis Cluster, New Schema Migration Dialog and More
Hello, DataGrip community! The second Early Access Program version for DataGrip 2023.2 is here. If you want to try the new features before the official release, this post is for you! Support for Redis Clusters Now you can connect to Redis Clusters and have the same feature set as with standalo…
DataGrip 2023.2 EAP is Open!
Hello! We are starting our EAP (Early Access Program) for 2023.2 and, as usual, we're inviting you to try the latest features and improvements we’re adding to DataGrip ahead of the official release. Let's look at what's inside the first EAP build. New UI The new UI is now enabled by d…
Nextсloud Performance Hacks with EverSQL and DataGrip
Hi, I'm Pasha. In my everyday life, I'm a Developer Advocate for data engineering, but by night, I'm a geek. Like, a really geeky geek! I have used Linux since 2009 as my primary OS (BTW I use Arch). If possible, I always prefer to host everything I use. So if you decide to drop me an email at me@as…