I still think the best sql client in existence is sequelpro. It only works with mysql but the ui and feature set is incredible.
HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
81–90 of 94 posts
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#82Downloads are programmatically disallowed while you're viewing the page under an ad blocker.
Of course, it only disallows the downloads via clicking the link. Easily circumventable.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#83I'll have to check out some of these I havent heard of. I use SQLYog (there is an opensource community edition)
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#84It'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.
Looks like it's written in Pascal!
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#85I have been using this ever since SSMS (when it was built with WinForm IIRC) was a pain to use in my old job and my OS was Windows XP.
Plus, I can update single column field from the query result by double clicking it.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#86A while back, I was fixing up procedures in PL/pgSQL for a company. The procedures had to be rewritten, and they all sort of looked like this:
create function...
"""
declare some string "'"this string"'" int
"""
end;
The cross-database client didn't support or comprehend $$ escaping, so the people who wrote everything had no choice but the write with loads of quotes everywhere. I didn't realize this, so I passed some code back to them and they couldn't run it at all.
The client-specific programs are all optimized to the RDMS you are using, so I never was able get on board with these products.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#87One 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.
I don't have to do this frequently but if any dev/QA/myself need to do this, I dump the DB and run grep. Not the fastest way for sure but gets the job done!
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#88Downloads are programmatically disallowed while you're viewing the page under an ad blocker. Of course, it only disallows the downloads via clicking the link. Easily circumventable.
You can install it with chocolatey without ever visiting the site.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#89Downloads are programmatically disallowed while you're viewing the page under an ad blocker. Of course, it only disallows the downloads via clicking the link. Easily circumventable.
You can install it with chocolatey without ever visiting the site.
You're seriously overestimating my ability to operate command line.
I'm only here for a serious discussion.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#90Props to Ansgar Becker for maintaining this awesome SQL client pretty much by himself.
HeidiSQL is hands down the best SQL client I've used.