Item: DataGrip
Rating: 6
Author: Verified User

Overall Satisfaction with DataGrip

Use Cases and Deployment Scope

We use DataGrip as our main database client to connect to many different services and db engines. It has a good selection of connectors and for each of them enough granularity to configure the connection properties properly including ssh tunnelling and ssl certificates.

Pros and Cons

Pros

Connects to most of the db engines known
auto complete is powerful and db objects introspection is complete
one place for all your db connections

Cons

The resources footprint on your system is big
it is not just a db client, it is a db IDE and form most things, for most people, it is too much and overwhelming. Too many options have transformed a db client into another very complicated tool
Connections are grouped by project so just having a quick check to a database could require some change in the approach to the tool otherwise you end up with a single dummy project and tens of connections
introspection to browse db objects is slow and painful
It tries to be smart to help but it ends up to be in the way some time
Java based with all the pros (not many) and cons (bye bye memory)

Return on Investment

centralise handling and re-allocation of license helps organisations to avoid wasting money on unused licenses.
One tool for multiple db engine could end up in less time and money spent on multiple cheaper tools
App well supported with continuos improvements and bug fixing

Usability

Usability has two aspects, being a complete tool and being easy... DataGrip has a lot of features but it is big, not clear how to use most of the things and most people won't need them. In my opinion, usability is good enough but not friendly.

Alternatives Considered

DBeaver, MySQL Workbench, Snowflake, Valentina, Toad Database Developer Tools, pgAdmin, SQLite and CockroachDB

One place for all the connections and uniformity of use and interaction

Key Insights

Do you think DataGrip delivers good value for the price?

Are you happy with DataGrip's feature set?

Yes

Did DataGrip live up to sales and marketing promises?

Did implementation of DataGrip go as expected?

Yes

Would you buy DataGrip again?

Yes

Other Software Used

DBeaver, pgAdmin

Likelihood to Recommend

Company that uses specific db engines that don't have db clients easily available. It comes with a price all this flexibility.
If you are looking for a lightweight and easy db client for some of the most common dbs (like postgres, MySQL, SQLite etc), in my opinion, it is not worth the price, effort to learn to use it and system resources footprint wasted.

Comments

Please log in to join the conversation

A good and complete tool for db developers that comes with a price in terms of money and complexity.