3 ms·

For anyone chancing on this thread, here's my recap. Note that I have little experience with these, so am trying to summarize, not give my own verdict. Competi

For anyone chancing on this thread, here's my recap. Note that I have little experience with these, so am trying to summarize, not give my own verdict. Competition: - DataGrip (~$150/yr, Clunky, Powerful) - TablePlus ($50, Pretty, Useful) - DBeaver (Free version, Clunky, Powerful) - SQuirrel (Free, Clunky, Usable) - Heidi (Free, Clunky, Usable) - Postico ($40, Pretty, Mac + Postgres only) - http://sequeljoe.ohwg.net http://sequeljoe.ohwg.net (Free, beta) - Azure (Free, Pretty, SQL server only) - Sequel Pro (Free, Pretty, Mac + Mysql only. IMO has issues with MySQL v8)

joshstrange 6y ago
- DataGrip - $89 first year, $71 second year, $53/year after that - Worth every penny for me and if you stop paying you get the last version - TablePlus - $59 and it is $59/year. You can pay once but to keep getting updates you have to keep paying like with DataGrip - DBeaver - Ugly but I agree, it's powerful - SQuirrel/Heidi/Postico/SequelJoe/Azure - Never used - Sequel Pro - God I loved this software and hung on to it way longer than I should have through the crashes and lack of updates (I would have paid in a heartbeat for it). Too bad it was MySQL-only
oh-4-fucks-sake 6y ago
Let me throw in Popsql (free for 2 saved DB connections, $12/mo for unlimited). I've used a handful of the above but Popsql has become my darling if only because the UI has a productive and inviting feel at a reasonable cost. It's obviously on the expensive side compared to OSS and one-time-licensing-fee products but when I'm firing off dozens of queries per day, it's worth it. As a bonus, their site offers live chat support directly with the engineers so the handful of times I've had some small issues, they've been super helpful.
rathboma 6y ago
This was basically my list. I wanted FOSS, not clunky, all databases, not abandoned. Good FOSS dbs deserve good FOSS tooling. We're still light on features, but electron let's us move very quickly. Good round up.
rathboma 6y ago
Unfortunately the node mysql driver is also not mysql 8 ready. Pr is out there though
sam_goody 6y ago
Correction, since it is after the edit window: Datagrip is indeed cheaper for non Enterprise users, at 53/year from the 3rd year, especially as they have a discount for users of competing software. A few more, not mentioned in this thread: - Valentina Studio - https://www.valentina-db.com/en/valentina-studio-overview https://www.valentina-db.com/en/valentina-studio-overview (Freemium, Pretty) - Workbench - https://www.mysql.com/products/workbench https://www.mysql.com/products/workbench (Free, Pretty, Mysql) - DBForge - https://www.devart.com/dbforge/mysql/studio/editions.html https://www.devart.com/dbforge/mysql/studio/editions.html (Freemium, Mysql Only) - Aqua Studio - https://www.aquafold.com https://www.aquafold.com ($500, Clunky) - Navicat Premium ($599, Pretty, has good reputation) - POPSql - https://popsql.com https://popsql.com (12/Mo., Pretty) I'm sure there are more!

joshstrange 6y ago

- DataGrip - $89 first year, $71 second year, $53/year after that - Worth every penny for me and if you stop paying you get the last version - TablePlus - $59 and it is $59/year. You can pay once but to keep getting updates you have to keep paying like with DataGrip - DBeaver - Ugly but I agree, it's powerful - SQuirrel/Heidi/Postico/SequelJoe/Azure - Never used - Sequel Pro - God I loved this software and hung on to it way longer than I should have through the crashes and lack of updates (I would have paid in a heartbeat for it). Too bad it was MySQL-only

oh-4-fucks-sake 6y ago

Let me throw in Popsql (free for 2 saved DB connections, $12/mo for unlimited). I've used a handful of the above but Popsql has become my darling if only because the UI has a productive and inviting feel at a reasonable cost. It's obviously on the expensive side compared to OSS and one-time-licensing-fee products but when I'm firing off dozens of queries per day, it's worth it. As a bonus, their site offers live chat support directly with the engineers so the handful of times I've had some small issues, they've been super helpful.

rathboma 6y ago

This was basically my list. I wanted FOSS, not clunky, all databases, not abandoned. Good FOSS dbs deserve good FOSS tooling. We're still light on features, but electron let's us move very quickly. Good round up.

rathboma 6y ago

Unfortunately the node mysql driver is also not mysql 8 ready. Pr is out there though

sam_goody 6y ago

Correction, since it is after the edit window: Datagrip is indeed cheaper for non Enterprise users, at 53/year from the 3rd year, especially as they have a discount for users of competing software. A few more, not mentioned in this thread: - Valentina Studio - https://www.valentina-db.com/en/valentina-studio-overview https://www.valentina-db.com/en/valentina-studio-overview (Freemium, Pretty) - Workbench - https://www.mysql.com/products/workbench https://www.mysql.com/products/workbench (Free, Pretty, Mysql) - DBForge - https://www.devart.com/dbforge/mysql/studio/editions.html https://www.devart.com/dbforge/mysql/studio/editions.html (Freemium, Mysql Only) - Aqua Studio - https://www.aquafold.com https://www.aquafold.com ($500, Clunky) - Navicat Premium ($599, Pretty, has good reputation) - POPSql - https://popsql.com https://popsql.com (12/Mo., Pretty) I'm sure there are more!