HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL • Hacker News Board

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

#31

Post by iblaine » Thu, Jan 17, 2019, 7:10 PM UTC

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 prefer lucidchart for being easy to integrate to confluence and share with teams.

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

#32

Post by justkez » Thu, Jan 17, 2019, 7:14 PM UTC

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.

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

#33

Post by d4nc00per » Thu, Jan 17, 2019, 7:17 PM UTC

The Postgres support was no good last time I tried. I'm using dbeaver now on linux

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

#34

Post by bouncing » Thu, Jan 17, 2019, 7:20 PM UTC

d4nc00per wrote: post #33

The Postgres support was no good last time I tried. I'm using dbeaver now on linux

You might consider DataGrip -- it's got surprisingly good Postgres support and even does ssh tunneling quite nicely.

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

#35

Post by bouncing » Thu, Jan 17, 2019, 7:20 PM UTC

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

Dia. https://wiki.gnome.org/Apps/Dia/

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

#36

Post by nwsm » Thu, Jan 17, 2019, 7:22 PM UTC

Heidi, DbVisualizer, and DataGrip are all great.

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

#37

Post by ediardo » Thu, Jan 17, 2019, 7:24 PM UTC

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

f you're using MySQL/MariaDB: MySQL Workbench

https://www.mysql.com/products/workbench/

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

#38

Post by andrewmackrodt » Thu, Jan 17, 2019, 7:30 PM UTC

paulryanrogers wrote: post #8

BrentOzar wrote: post #2

It's a Windows app. Github repo is here: https://github.com/HeidiSQL/HeidiSQL/ The repo doesn't show releases, but the heidisql.com site has nightly builds done directly from the master branch.

FWIW, it does work on Wine

Works very well with Wine (but only with non Hi-DPI displays when and the Windows Version is set to 2003). It's my favourite client on desktop Linux / Windows.

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

#39

Post by glogla » Thu, Jan 17, 2019, 7:30 PM UTC

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

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

#40

Post by taylorwc » Thu, Jan 17, 2019, 7:39 PM UTC

cowmix wrote: post #3

So what's the best x-platform SQL client these days?

I enjoy Sqlectron. Good cross-platform support, and a terminal option if you'd prefer.