Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

heidisql.com

Post reply on HN
Print view View original

41–50 of 94 posts

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

#42

Post by brylie »

stevoski wrote: post #22

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/

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

#43

Post by brylie »

manigandham wrote: post #13
cowmix wrote: post #3

So 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/

Interestingly, OmniDB is built with Django.

DBeaver has support for many databases through JDBC.

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

#44

Post by dariusj18 »

jasonjayr wrote: post #20
dariusj18 wrote: post #19

Does 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 cannot remember exactly how they each screw it up, but the issues I have had are, but not limited to,

a) truncation of data b) removal of line breaks c) not escaping enclosing values, ex. " as "" d) using \n or other values in place of actual line breaks or tabs e) using \N for NULL values (which isn't too bad, but it would be nice to be able to configure this) f) in general not complying with https://tools.ietf.org/html/rfc4180

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

#45

Post by ken »

glogla wrote: post #39

Is there a gui client that can do both "normal" databases (like postgres and oracle) and Hive or Presto?

Induction [1] was supposed to be that, but the webpage is long gone, and it looks like there's just a source dump on GitHub with "alpha" code that hasn't been touched in 5 years.

[1]: https://github.com/pothibo/Induction

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

#46

Post by pjmlp »

thedangler wrote: post #29
stevoski wrote: post #22

I 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.

I had a couple of projects where it was the official modelling tool.

Can vouch for it, one of the best experiences with enterprise modelling tools.

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

#47

Post by Max_aaa »

jamisonbryant wrote: post #16
Max_aaa wrote: post #14

If 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.

I am using the CE version that is in the Ubuntu Repo.

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

#48

Post by sabas_ge »

dariusj18 wrote: post #19

Does this app actually export to CSV correctly, because MySQL Workbench and SSMS both screw it up?

Yes, you can choose the separator (csv/ excel csv / tsv / also custom) and export to file or to clipboard, and choose whether to have headers or not.

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

#50

Post by sabas_ge »

jasonjayr wrote: post #20
dariusj18 wrote: post #19

Does 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?

No 'standard' but you could check and use the FrictionlessData specifications from OKFN (https://frictionlessdata.io/specs/csv-dialect/)
Post reply on HN