I have been using HeidiSQL with Wine for couple of years now, works great! It does have some bugs though, like after running a large SQL file the UI just freezes and you have to kill the program.
HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
11–20 of 94 posts
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#12So what's the best x-platform SQL client these days?
A simple postgres client I'm working on in my free time: https://sanchosql.com/
Linux only now but it's open source so it should be possible to compile for win/mac
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#13So what's the best x-platform SQL client these days?
DBeaver is solid and supports the most DBs with lots of handy features: https://dbeaver.io/
Jetbrains Datagrip is popular too, more intelligent but less DBs than DBeaver: https://www.jetbrains.com/datagrip/
If you want a web-based tool, especially for Postgres, then OmniDB is a good choice: https://www.omnidb.org/en/
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#14If I need a GUI for MySQL, I find MySQL Workbench to work great:
https://www.mysql.com/products/workbench/
But in 90% of cases, I do find that the cli sql client for your DB of choice is sufficient.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#15If I need a GUI for MySQL, I find MySQL Workbench to work great: https://www.mysql.com/products/workbench/ But in 90% of cases, I do find that the cli sql client for your DB of choice is sufficient.
I used the workbench all the time. Only niggle is that it hangs if you connect to an older version of MySQL, but the older version of Workbench works.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#16If I need a GUI for MySQL, I find MySQL Workbench to work great: https://www.mysql.com/products/workbench/ But in 90% of cases, I do find that the cli sql client for your DB of choice is sufficient.
I wish I had the same experience as you. I use MW at my work and it is constantly crashing, hanging, freezing, and otherwise puttering out. We don't have a stupidly large database either. Lately I've been hounding my team to switch to another product, such as HeidiSQL or DBeaver.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#17If I need a GUI for MySQL, I find MySQL Workbench to work great: https://www.mysql.com/products/workbench/ But in 90% of cases, I do find that the cli sql client for your DB of choice is sufficient.
I wish I had the same experience as you. I use MW at my work and it is constantly crashing, hanging, freezing, and otherwise puttering out. We don't have a stupidly large database either. Lately I've been hounding my team to switch to another product, such as HeidiSQL or DBeaver.
>HeidiSQL or DBeaver
I've used both, and they're both good.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#18So what's the best x-platform SQL client these days?
DBeaver is solid and supports the most DBs with lots of handy features: https://dbeaver.io/ Jetbrains Datagrip is popular too, more intelligent but less DBs than DBeaver: https://www.jetbrains.com/datagrip/ If you want a web-based tool, especially for Postgres, then OmniDB is a good choice: https://www.omnidb.org/en/
I'll second DBeaver.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#19Does this app actually export to CSV correctly, because MySQL Workbench and SSMS both screw it up?
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#20Does this app actually export to CSV correctly, because MySQL Workbench and SSMS both screw it up?
Though I'm not familiar with the CSV export of those two tools, I've had adventures in CSV parsing from other tools. How do they screw it up? Is there a canonical "correct" way defined somewhere?