Absolutely agree with HeidiSQL. I'm in a situation where I'm still running MySQL 4.0.26 and essentially nothing properly supports that with the exception of the old MySQL query client (not workbench) and HeidiSQL which blows mysqls software out of the water. It's a really solid software.
I'm going to give it a shot again, but when I tried before it was buggy with support for that version. It seemed like it technically connected but it wouldnt run any queries nor show any of the columns. Now that it's 1.0 I'll try again but I can't spend too much time fighting it. I really want to be able to use it but time unfortunately equals money :/.
Checked HeidiSQL again after so many years and I'm surprised to see it work so effortlessly and fast with any MSSQL and PgSQL db connection I threw at it. It definitely needs to be given a chance.
HeidiSQL is pretty good feature-wise, though I think it still can't connect to a server via a SSH tunnel if also using an encrypted MySQL connection (the SSL checkboxes are greyed out).
Another issue is that while it's open source, it's written in a language that requires an obscure, proprietary and expensive compiler, which makes contributing to it basically impossible.
Speaking about db tools that run in a browser, have you checked out Datazenit? It has handy data grid, query builder, keyboard navigation everywhere, charts/visualizations and a lot of other features.
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.
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.
I'm not the OP, and I have tried the diagram tooling, walking away not just disappointed, but annoyed at the waste of time every time.
I understand that automated diagramming is one of those problems that looks a lot easier to solve than it actually is; the results were hilariously awful every time I tried it, though, even with pretty basic DB schemas with the most basic of foreign key definitions.
On Mac, you may want to try Warp (http://warp.one). It allows for quick drag-and-drop data importing and exporting across different file and database types. It abstracts the underlying storage away, and will automatically push down queries to the database as much as possible.
It's a fairly weak product given the other JB products that I use. But, I anticipate that they'll continue improving it. The layout is just confusing and not intuitive. And, it lacks a lot of power features.
But, recently, I've been using Redshift a lot (as well as MySQL and Postgres). So, it's convenient to have open all the time.
I've been using the beta pretty much well since day 1, purely as a quick and easy client for non-MySQL databases (e.g. SQL Server).
DataGrip is decent enough, and kinda-sorta works most of the time. Its design seems firmly rooted in the 90s, though, and the extra features (such as diagrams) seem to be bolted-on, half-baked "I can write this in a day!" tools that quickly fall apart after a few minutes' in-depth use.
It's frustrating, as there's a real need for a cross-platform, cross-database version of something like http://www.sequelpro.com
DataGrip's pricing also seems astronomically high for what you actually get.
I completely agree about a need for cross-platform, cross-database tool. For exactly that reason I started building Datazenit[0]. It runs in a browser and currently supports MySQL and PostgreSQL. Datazenit is in beta testing right now, but you can sign up and give it a try.
I used the beta for a couple of days but gave up because i wasn't able to find all the functionality i was used to from Oracle SQLDeveloper. Since i don't write much SQL but use it mostly to view and aggregate information, it's important for me to find the tables and views very quickly.
The beta version i used was a bit early i think and i will definitely give it one more try, since i like using other products by jetbrains, i think they changed a lot since the version i tried.
It needs to be noted that sequelpro is Mac & MySQL only. DataGrip has plans to support even for NoSQL DBs and already supports most popular relational DBs.
I used it for about half of the EAP. For the biggest problems were performance and some general quirks (which admittedly may have been fixed/adjusted by now). It also didn't particularly provide me with a sense that I was being more efficient.
Right now I use a combination of SQL Management Studio and Atlantis SQL Everywhere. SMS to manage entities in design view, and Atlantis because of it's much better intellisense and ease-of-use features.
will this be like a lot of the other individual apps and the functionality also included in intellij? I know there already is a lot of database functionality built in that is similar.
I tried it during the beta and was pretty pleased with it, but the individual price is a bit too steep in my opinion.
My question too! I"m using PyCharm with the DB plugins tools installed. It works very well. And it looks like this product is intellij with only the db plugin installed. What more features does it have?
I use Toad, and the one feature that I can't live without is the tabbed results with column filtering. I do a lot of data explorations and being able to go back to previous queries quickly and compare is a big time saver.
I've been using it on OSX for a few weeks. It hard-crashes on me every few hours, despite using latest version, having latest OS updates, and a beefy machine (maxed out MBPr maybe one generation old)
If you just want something very light and easy and runs in a browser, then Adminer is pretty good (not an IDE, but certainly better than PHPMyAdmin).