Comment by foxpc | Hacker News Reader

Comment by foxpc | Hacker News Reader

Parent Full thread

I use DBeaver daily and it is probably not the best tool in the lot (well, it probably is if we're only looking at free ones) but I have become quite accustomed to it.

That said, I use PHPStorm and maybe DataGrip will complement the knowledge of JetBrains IDEs.

I'll give it at least a few hours of SQL work and get back.

EDIT: Well, apparently I won't have a couple of hours fiddling with the tool considering that it does not really work as I expect it to.

* Added a MySQL connection, can't seem to be able to work with multiple databases unless I create multiple data sources. That's weird.

* Selecting a specific DB (what I don't really want to do) still shows me the wrong table list from a different DB. 'Forget Schemas' does not work. Weirdly enough, I can query the DB I selected, it just won't resolve the table names (and do autocomplete).

Though, it's probably just me having this problem since there's no way this would go through the testing phase.

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.

+1 for DBeaver

I've started using it only recently and I'm really pleased with it. I am using Oracle and Postgres constantly, and this was the first tool that worked really nice with both out of the box.

That said, it could use some more features, but all in all, very nice tool.

I've also tried OxDBE, but got feeling that it was not finished at all. Half of stuff was really annoying to use. I was never sure what was commited and what not. Adding columns to table worked sometimes, and sometimes it would just hang. In the end I was writing SQL by hand for even the trivial tasks. Not something I need IDE for. Hopefully they can improve it in the future, because other products from JetBrains are great.

> 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.

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

Thanks for mentioning DBeaver, I didn't knew it.

Quite good for generating ER diagrams, it seems.

If you're using phpstorm, then you already have all the features of DataGrip.

Thank you very much for DBeaver, I had never heard of it. It works great!

Reply on news.ycombinator.com