HeidiSQL – Lightweight MariaDB, MySQL, SQL Server, PostgreSQL and SQLite Manager
github.com72 points by peter_d_sherman 11 hours ago
72 points by peter_d_sherman 11 hours ago
What's really special about Heidi and idk if this is still true, but sometime after the creator of MySQL forked MySQL into MariaDB, on Windows, the installer used to include HeidiSQL since they no longer owned the MySQL Workbench, and honestly, as far as open source clients go, Heidi was always my preferred one every single time. It's got its quirks but its so good once you figure it out.
I got a taste of Navicat (Paid Software) and I wish I hadn't because being able to control everything in one place with a good SSH support and wide support for all including SQlite and Redis in a unified interface, being able to transfer between servers and take dumps at the comfort of a single software feels like a blessing.
I suggested the Navicat team to put in Redis support in 2020 and they put in a ticket to their Dev team. And in 2023 they added support for Redis and emailing me back saying they did it and released it. I was kinda in disbelief and happy. But, I love their backup and restore option
Paid software can be good, the problem is that the incentives aren't for it to continue being good and improving over a long period of time. The paid products that are able to maintain quality and vision are the exception.
Written in Pascal. That's been a while since I've seen Pascal in the wild!
I use neovim for querying my databases with DBUI and tpope dadbod :) https://www.ssp.sh/brain/query-databases-in-vim-vim-dadbod/
But HeidiSQL and DBeaver are great, and open source (DBeaver even has a vim integration too;)
Does it do anything DBeaver doesn't do?
It's mostly down to preferences and needs.
DBeaver requires Java, supports more RDBMSs, supports plug-ins, supports ER diagrams, but is also a project split into a community/enterprise model so some features are just never going to be implemented or improved upon without you paying an annual fee.
HeidiSQL is written in Delphi, supports the major RDBMSs (except Oracle), and is more focused on being a query analyzer than anything else. There is no edition split or paid model, so you're more likely to see new features in the free edition.
IMX, HeidiSQL is faster. It loads quickly and performs better, though I will say that my experience with both is about 10 years old at this point. From my memory, the DBeaver interface has always felt clunky in that way unique to Java applications, and many of the features in DBeaver are things I never wanted or needed. At the time, HeidiSQL was Windows-exclusive, with Linux support only about a year or two old at this point. My opinion 10 years back was that I would use HeidiSQL when I could and DBeaver if I had to.
Mmmmm just noticed MacOS is now supported. Guess time to say farewell to DBeaver...
heidisql is interesting, but right now i am using beekeeper. it's great and just works
Delphi?! Interbase?! Is this a Borland reunion?
It’s been a long time since I used it but it’s one of those pieces of open source that was so vital to my career when contracting I treated it like I had an annual subscription to pay each year.
How does it compare to DataGrip?
Different kind of beast. In my opinion Datagrip is meant for heavy DB work with jetbrains ecosystem surrounding you as well.
Heidi is perfect for the kind of person who connects to a DB once in awhile to just get some crap done.
My daily driver at work
I used this to move away from MySQL Workbench, which is absolute trash. HeidiSQL is excellent, even though is fugly. Doesn't matter though, works like a charm.
Looks good, but I can't afford Delphi. I might try their Community Free Edition, though.
The Linux version is built with Free Pascal instead, and the Windows version will be based on that code in the future (says the README in the lazarus branch).
people don't realize how good llm is at SQL. I use to use lots of these tools now i just llm on cli.
Perhaps this is for people who have already mastered the skill itself and don't need or want their ability to practice that skill through a meta-skill to exist at the pleasure of other parties.