Live data from Hacker News

HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL

heidisql.com

71–80 of 94 posts

Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL

#71
post #69
post #66

Earlier quoted context omitted.

I use Sequel Pro almost daily, pretty damn good, and you can't complain about the price :)

I used the regular Sequel Pro for years but just recently switched to the nightly version, which usually it's stable and has more updates. I recommend the switch to nightly. They share the same DB configurations you have created, so no need to worry that you have to import/export.

Thanks, I didn't know about their nightly builds, and it seems that nightly (true to it's name) supports dark mode. Awesome :)

Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL

#73

I have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?

If you don’t need a reverse engineering capability, Draw.io is pretty good:

https://about.draw.io

Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL

#75
post #32

Feel like I've trialled every multi-DB client under the sun. Spent a good deal of time with Valentina, then DataGrip but firmly in bed with TablePlus ( http://tableplus.com ) now. First class Mac native experience and it's hard to see ever giving it up! There's a Windows build I've not used.

Want to also plug TablePlus — I got it in my SetApp subscription but it’s one I would have no problem buying outright. Really good stuff and consistently developed.

Huge fan of SetApp here. I subscribed months ago and absolutely love being able to just search, install, and get on with my work. Sure it is much cheaper to directly buy software you will use forever but that’s not why I use SetApp. I use it because it makes the hunt for apps obsolete. Any time I think I need software to do something, I have been able to find it instantly on SetApp. From PDF search to simple image editor to TablePlus, it makes me so much more relaxed about finding and installing the right app.

Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL

#76

I have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?

erdplus is decent, if you don't need round-tripping or anything fancy.

Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL

#78

So many people sleeping on DB Visualizer. It’s been around forever, can connect to anything with a JDBC driver, has a ton of features, and is updated frequently. My favorite is the ability to quickly full text search any query I’ve ever run. https://www.dbvis.com/

Sounds interesting, but what are good examples of "Visualizer" part? Screenshots section [1] only has 6 (pretty primitive [2]) images out of about a 100 total, but maybe that is outdated?

[1] https://www.dbvis.com/features/software-screenshots/

[2] https://www.dbvis.com/images/features/screens/chart3.png

Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL

#80
I usually use this on Windows but now that I have all JetBrains tools I opt for DataGrip the most since its cross platform. But also this gets tricky when you want to open a MSSQL db thats local for development I forgot what Microsoft calls it but it may as well be called MSSQLite.
Post reply on HN