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

#51

Post by eerikkivistik » Thu, Jan 17, 2019, 8:22 PM UTC

justkez wrote: post #32

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.

Can back this up, TablePlus is really well implemented and a pleasure to use!

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

#52

Post by raphaelj » Thu, Jan 17, 2019, 8:39 PM UTC

justkez wrote: post #32

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.

I really like TablePlus too and bought the premium version a couple of weeks ago. The native UI is very nice. It's a very nice and cheaper alternative to Navicat.

I still experience bugs from time to time. But it's improving.

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

#53

Post by timvisee » Thu, Jan 17, 2019, 8:41 PM UTC

It's one of the best free apps I've used when I was still developing on Windows, and it's one of the few tools I miss for development when on other platforms. If you haven't yet, give it a try!

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

#54

Post by mmsimanga » Thu, Jan 17, 2019, 8:43 PM UTC

cowmix wrote: post #3

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

I use three tools interchangeably. DBeaver as mentioned by other comments. Squirrel SQL[0] has been around for a very long time. I have been using it for well over 10 years. Probably 15. Don't be fooled by the dated screenshots. First thing I always do it change the look and feel to Windows native then looks like any other Windows application. SQL Workbench/J[1]. Has tonnes of features, is well documented. I particularly like the headless mode which allows me to automate running of SQL statements using a batch file.

[0]http://squirrel-sql.sourceforge.net/ [1]https://www.sql-workbench.eu/

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

#55

Post by iRobbery » Thu, Jan 17, 2019, 8:54 PM UTC

dariusj18 wrote: post #19

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

Curious how do workbench and the other (have not used that i guess) screw up CSV exports?

Recently tried workbench after a year or 2 again; was enjoying some new features, but the lack of OSX dark theme support is hurting usability, some parts of UI and or texts are simply unreadable. I hope they sort that soon. Workbench is not one of many that supports connections over ssh native, which is nice as i hope non of the folks here run interfacing databases :). The performance analyses tab is quite neat, saves me a lot of manual query logging and plowing through that to find bad queries.

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

#56

Post by morenoh149 » Thu, Jan 17, 2019, 9:09 PM UTC

pca2 wrote: post #28

soperj wrote: post #18

Earlier quoted context omitted.

I'll second DBeaver.

third!

fourth dbeaver db support and data model diagramming

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

#57

Post by markn951 » Thu, Jan 17, 2019, 9:22 PM UTC

For working with MySQL on Mac, I really enjoy Sequel Pro [1]. Full native (and kinda old-skool, if you dig that kinda thing) Mac experience/design. Works fast. Is free.

[1] https://sequelpro.com

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

#58

Post by cholmon » Thu, Jan 17, 2019, 9:26 PM UTC

One of my favorite features of HeidiSQL is its "Find text in database", see https://www.heidisql.com/forum.php?t=1006

It'll search through all text fields of all tables of whichever database you specify for a given string, and displays a nice per-table summary for each matching record. I haven't found anything like this in any other DB client.

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

#59

Post by voltagex_ » Thu, Jan 17, 2019, 9:31 PM UTC

andrewmackrodt wrote: post #38

paulryanrogers wrote: post #8

Earlier quoted context omitted.

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.

Is there any way to improve the HiDPI support? I remember that Wine was doing some work on that in recent versions.

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

#60

Post by filmgirlcw » Thu, Jan 17, 2019, 9:32 PM UTC

justkez wrote: post #32

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.

Want to also plug TablePlus — I got it in my SetApp subscription but it’s one I would have no problem buying outright. Really good stuff and consistently developed.