[ArtB]

> EDIT2: The price is also way too much in my opinion. It basically costs as much as PHPStorm. Not sure why you would by DataGrip instead of Navicat.

Uhm for Navicat you need to buy a different license for each database and operating system you use. Where I work we use both SQL Server and MySQL and I use three different computers with different operating systems. JetBrains terms are much friendlier.

[jasode]

Navicat the Premium[1] edition includes all the databases. But to your point, you still have to pay separately for each operating system, and paying $599 for a single platform is expensive.

That being said, I've tried a dozen SQL utilities and the only one that is fast and responsive for large tables is Navicat. The other utils such as RazorSQL, SQLMaestro, Firefox XUL plugins, NET LINQPad, etc are memory hogs and very slow for browsing tables with 100,000+ rows. I haven't tried JetBrains yet but the 3 others that were written in Java and used JDBC were very slow so I wouldn't be surprised if DataGrip is slower than Navicat.

If one is mainly using SQL frontend tools to help with syntax completion to speed up typing in commands (ALTER TABLE, SELECT INNER JOIN, etc), any of those utilities will work fine. But if you happen to need the tool to provide a responsive "Excel-like datagrid" for browsing big tables, my experience has found that Navicat is unmatched.

[1]http://www.navicat.com/products/navicat-premium