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 firstname.lastname@example.org, rest assured, I’ll receive it on my self-hosted mail server. While self-hosting certainly has its benefits, it does have some downsides, like poorer performance, that should be addressed.This is the story of how I “fought” with self-hosted MySQL to get better database performance. Nex
DataGrip 2023.1 Quality Release
Hello! For DataGrip 2023.1, we focused entirely on quality. We’ve fixed many bugs that had accumulated in our public issue tracker (not the most fun part of the job, but important nonetheless). While there won’t be any new features for you to explore this time, we hope you’ll notice improvements in your daily work with DataGrip. Here are a few of the highlights, and for a full list of bug-fixes with more details, please visit our What’s New page. Working with code DBE-4469: We fixed the problem causing the SQL Formatter not to apply the correct style for subqueries in EXIS
DataGrip 2023.1 EAP 3
DataGrip 2023.1 EAP 3 is out! Here are the new fixes in this version: Introspection Switch the introspection level to Level 1, where DataGrip introspects only the names and types of objects. On introspection Level 1, you can click Refresh selected object to edit a specific object or view its sources. Check if you have the SELECT_CATALOG_ROLE and the SELECT ANY DICTIONARY permissions, which grant you access to the Oracle internal catalog. This makes introspection much faster. Code highlighting Schema Diff If the Specify next value for sequences option is
DataGrip 2023.1 EAP 2
We're continuing our release cycle dedicated to product quality. However, no new features will be introduced in the upcoming release. Here's the list of improvements and fixes you can already try in this EAP build: DBE-16238: Errors no longer appear while saving a diagram. DBE-17229: The Schema diff viewer now works properly. Previously it opened empty if there were database or server objects included. DBE-7087: Usage search no longer looks in the installation bundled resources. DBE-17434: The correct font color is used in the data editor header. DBE-17292: The Quick Do
DataGrip 2023.1 EAP 1
Hello, DataGrip fans! Our 2023.1 release cycle is all about quality, which means we’re working on the bugs that have accumulated in our public issue tracker. Today we’ll cover what we’ve managed to fix so far. Of course, you can already get the benefits of these fixes by downloading our EAP build! Working with code DBE-4469: We fixed the problem where SQL Formatter didn’t apply the right style for a subquery in the EXISTS clause. Now it works as expected, and DataGrip can also add a space between the EXISTS keyword and the left parenthesis. For this part, we also added a new
Hello! We’ve released the third minor update for DataGrip 2022.3. Here are the most notable improvements and bug fixes: DBE-11963: Auto-refresh is now available with adjustable intervals. It can be disabled manually or automatically (for example, if you start editing). You can set up auto-refresh for sessions in Virtual views to monitor sessions in real time, which finally resolves this really old ticket, DBE-229! DBE-17059: A list of settings was added to the Object Migration dialog.
DataGrip Turns 7!
7 years ago today, DataGrip was brought into the world. We’d like to share some milestones from our history and express our gratitude to our users who have made huge contributions to DataGrip over the years. We’ve done it together! June 2014 Early Access Program starts for 0xDBEDecember 2015 DataGrip 1.0 releasedJuly 2016Import CSV filesOctober 2016DataGrip’s first participation in PASS Summit in SeattleNovember 2016Source code storageMarch 2017First PGConf US in New YorkJuly 2017AWS Redshift supportedOctober 2017First PGConf EU in WarsawNovember 2017First AWS re:InventDecember 201
Hello! The first update for DataGrip 2022.3 introduces some important improvements and fixes. Improvements: You can view and edit External Objects Files for virtual objects, such as foreign keys, views, and columns. Virtual views now can be added to schemas, data sources, and databases.Virtual views with session lists are available for most dialects: Sybase ASE, ClickHouse, IBM Db2, Exasol, H2, HSQLDB, Microsoft SQL Server, Azure SQL Database, MySQL, MariaDB, Oracle, PostgreSQL, Amazon Redshift, Greenplum, Snowflake, and Vertica. It is now possible to dro
DataGrip 2022.3: Redis Support, Quick Filter In Database Explorer, Pattern-Based Schema Filtering, Formats for Datetime Fields, and More!
DataGrip 2022.3 is here! This is the third major update of 2022, and it’s packed with various enhancements. Let’s take a look at what it has to offer! For a detailed description of this update, please visit our What’s new page. General Redis SupportNew UI available via settingsNew Settings Sync solutionVirtual viewsNavigation in diagrams Database explorer Quick filterPattern-based schema filteringColors for global data sourcesDrag-and-drop for script files Data editor Working with code Intention action previewSingle line copy-pasteNew layout for the SQL sch
DataGrip 2022.3 Release Candidate
This is the release candidate for 2022.3. Check out these publications for a reminder of what’s new in this version: 2022.3 EAP 12022.3 EAP 2: Redis support2022.3 EAP 3 Try it out and share your feedback with us!
DataGrip 2022.3 EAP 3
Hello! Here’s a brief overview of what we've released in the latest update to DataGrip 2022.3 EAP. UI for virtual foreign keys The ability to create virtual foreign keys was introduced a while ago and the main way to create them was by using the intention action Store Relation at the JOIN clause in your query. This was a little bit tricky to find and the whole functionality lacked an intuitive way to use it. Here’s an overview of the implemented changes:Virtual foreign keys are visible in the database explorer: You can create and drop them here, in the database explorer, and also