giancarlostoro26 minutes 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.
tacomagick4 hours ago
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.
tgeorge2 hours ago
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
gchamonlivean hour ago
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.
flossly13 minutes ago
Written in Pascal. That's been a while since I've seen Pascal in the wild!
articsputnik5 hours ago
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;)
dominicrose5 hours ago
Does it do anything DBeaver doesn't do?
da_chicken3 hours ago
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.
anta4037 minutes ago
Mmmmm just noticed MacOS is now supported. Guess time to say farewell to DBeaver...
root-parent16 minutes ago
If you want to have schema and data dif, DBeaver is very expensive.
fwgijcqywqeo3 hours ago
yes, runs without java.
yamapikarya27 minutes ago
heidisql is interesting, but right now i am using beekeeper. it's great and just works
owlstuffing35 minutes ago
Delphi?! Interbase?! Is this a Borland reunion?
tclancy4 hours ago
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.
overflowy3 hours ago
How does it compare to DataGrip?
JoeBOFH3 minutes ago
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.
fallen_comrade3 hours ago
My daily driver at work
mohragk3 hours ago
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.
peter_d_shermanop11 hours ago
Related: https://www.heidisql.com/
orionblastar11 hours ago
Looks good, but I can't afford Delphi. I might try their Community Free Edition, though.
ptx5 hours ago
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).
jeremyjh4 hours ago
There are release binaries on their website.
faangguyindia3 hours ago
people don't realize how good llm is at SQL. I use to use lots of these tools now i just llm on cli.
add-sub-mul-div2 hours ago
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.