So what's the best x-platform SQL client these days?
I'm a big fan of Aqua Data Studio. I'd never heard of it until my current position, but it's very nice.
HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
21–30 of 94 posts
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#22I have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#23Does 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?
I wonder what percentage of CSV represented data 1) passes through a spreadsheet at some point from data source to final data consumption and 2) how much of that spreadsheet action is specifically MS Excel.
You're right, there is no standard that I'm aware of, though the answer to those first two questions could well be a proxy for a de facto standard in practice.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#24I have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?
I use pgModeler for Postgres. Although lately I've been using Valentina Studio and it has a decent schema modeler too.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#25Does this app actually export to CSV correctly, because MySQL Workbench and SSMS both screw it up?
I'm not sure about HeidiSQL but I've had great luck with MySQL database exports using PHPStorm. I think PHPStorm essentially has DataGrip built-in:
https://www.jetbrains.com/datagrip/
After having trouble with workbench, Using PHPStorm I was able to export a whole database to a file per table in one go and both TSV/CSV are supported. I found my resultant CSV files to be reliably escaped.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#26I have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?
I've been looking for something decent in Linux too.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#27I 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.
I really love using HeidiSQL as well, but I have the same issue. If I'm running large SQL files, I'm either using workbench or the CLI app.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#28Earlier quoted context omitted.
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.
third!
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#29I have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?
I use Enterprise Architect at work. If you have money its worth it.