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.
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.
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)
[+] [-] JonoBB|10 years ago|reply
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).
[+] [-] julioneander|10 years ago|reply
I've been using it on Linux for quite some time. Being able to work on MSSQL from Linux is just great :)
[+] [-] luchadorvader|10 years ago|reply
[+] [-] egeozcan|10 years ago|reply
[+] [-] realharo|10 years ago|reply
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.
[+] [-] lauriswtf|10 years ago|reply
[+] [-] foxpc|10 years ago|reply
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.
[+] [-] ekspreso|10 years ago|reply
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.
[+] [-] ArtB|10 years ago|reply
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.
[+] [-] pjmlp|10 years ago|reply
Quite good for generating ER diagrams, it seems.
[+] [-] gamesbrainiac|10 years ago|reply
[+] [-] mosselman|10 years ago|reply
[+] [-] louhike|10 years ago|reply
It had mostly problems to manage the specificities of SQL Server (not in the SQL standard).
[+] [-] pjmlp|10 years ago|reply
Having ER models is pretty standard on the documentation of our projects.
The page doesn't provide any screenshots for them.
EDIT: Found the screenshots, https://www.jetbrains.com/datagrip/features/other.html
[+] [-] misterdata|10 years ago|reply
[+] [-] ap22213|10 years ago|reply
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.
[+] [-] mootothemax|10 years ago|reply
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.
[+] [-] jimmcslim|10 years ago|reply
[+] [-] lauriswtf|10 years ago|reply
[0] https://datazenit.com
[+] [-] bigbasti|10 years ago|reply
[+] [-] DomBlack|10 years ago|reply
[+] [-] egeozcan|10 years ago|reply
[+] [-] mootothemax|10 years ago|reply
I would kill for a sequelpro that worked with other databases.
[+] [-] rongenre|10 years ago|reply
[+] [-] ilitirit|10 years ago|reply
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.
[+] [-] netcraft|10 years ago|reply
I tried it during the beta and was pretty pleased with it, but the individual price is a bit too steep in my opinion.
[+] [-] TeeWEE|10 years ago|reply
[+] [-] polskibus|10 years ago|reply
How does DataGrip support connectivity with different database engines? Is it JDBC or ODBC connectivity?
Does DataGrip use internal SQL parsing for various SQL dialects or is the SQL validated always against the server?
Does DataGrip include SQL profiling, like MS SQL Profiler?
Do you intend to add MDX support?
[+] [-] mariuz|10 years ago|reply
https://devnet.jetbrains.com/message/5518562#5518562
[+] [-] Dnguyen|10 years ago|reply
[+] [-] bdcravens|10 years ago|reply
[+] [-] torbica|10 years ago|reply
Unfortunately there is no oracle support but for PostgreSQL and MySQL is by the far the most convenient tool.
[+] [-] jimktrains2|10 years ago|reply
[+] [-] xemoka|10 years ago|reply