I have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?
DBeaver has built-in support for diagrams based on an existing database schema: https://dbeaver.io/
HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
91–94 of 94 posts
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#92Feel 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.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#93Earlier 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.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#94I still think the best sql client in existence is sequelpro. It only works with mysql but the ui and feature set is incredible.