HeidiSQL Available Also for Linux

Very good news that the Freepascal version compiles and works correctly also on Windows. As you said, Delphi was a huge barrier to prevent other developers to contribute, but if we can use Lazarus, Heidi can receive a lot of help not only for Linux version but also for Windows one. Probably, thanks to Freepascal / Lazarus, it can be ported easily also to Mac OS now.

I used Datagrip like 10 years ago and it was amazing, back then I used some pre-release evaluation thingy, loved it, was only working with mysql though.

last year i looked at it again, in a project where mongodb is used, it did not perform so well, sure the features where there, but still mongodb is document orientated so i had to come up with workarounds and so ... yeah back to cli unfortunately

but for any relational database, I'd rather use datagrip!

For simpler use-cases I've used both https://dataflare.app/ and https://tableplus.com/ with success. They are much quicker and lighter to start-up, browse some tables and run some queries.

Free versions are generous enough for daily use as well. For example for TablePlus "The free trial is limited to 2 opened tabs, 2 opened windows, 2 advanced filters (filters are not available on the free TablePlus Windows) at a time."

I suppose it has more advanced features than IntelliJ?

Because when I switched to MacOS I had to find a replacement for HeidiSQL and, to my surprise, I was able to do everything I wanted to directly from IntelliJ, which was already my main IDE.

https://www.jetbrains.com/help/idea/database-tool-window.htm...

HeidiSQL has its quirks and occasional rough edges, but it's certainly simpler and more straightforward to use than DBeaver, the other common free SQL client that is sometimes recommended.

I prefer Heidi where the DB setup allows it, and use DBeaver as a backup.

Using DBeaver and its also not without problems. Lots of popup dialogs that we cannot stop. But ti does not constantly crash or lock up.

I only ever used DBeaver, because that seemed like the best free option for Linux to manage several SQL and NoSQL databases. What does Heidi offer that makes it better?

I've been using HeidiSQL since around 2008(?) at my first job. What I like the most about Heidi is the UI for generating queries and editing left/right joins in a graphical manner. So you can use it to "prototype" your queries first, try them out, see the results, and then copy/paste them into your code, which is a supernice experience, including for beginners that haven't had much experience with SQL databases and lack the "feeling" of how to decouple datasets into tables.

I was trying out DBeaver a lot, actually, but a couple of things here and there didn't work as expected. Sometimes I had problems with batch selections that I couldn't reproduce so I was then most of the time switching back to HeidiSQL in my wine sandbox when it didn't work, out of frustration.

To me it's really great to see Heidi getting revived into a community software again, I really missed the tool a lot since I've made the switch to Linux as my daily driver everywhere. Wine's double click seemless windows aren't really nice and sometimes really annoying.

Yeah, DbBeaver is a slow behemoth while HeidiSQL is like 2 MB snappy lean and mean exe.

Works great in Wine before this native version came about.

When I switched to Linux full time, I had to ditch Heidi as they didn’t have a Linux version. I actually prefer dbeaver now, Heidi had some odd defaults (default collation especially) which need attention but you don’t realise it until too late. It also was a bit crashy here and there.

DBeaver has the worst name in history but it can do everything Heidi does and doesn’t fall over every 20 minutes. The buttons are all over the place and it’s harder to navigate than Heidi but it’s also standard on a few distros.

I’m glad it has some competition though. If you’re working with sql server Microsoft have really dropped the ball with SSMS and don’t talk to me about azure data studio it is a undergraduate project that got a C.

I was switching a lot between SQLite, pawl, Marian and sql server and dbeaver is excellent on all of them

With DBeaver I was able to use tnsnames.ora to use a few tricks to connect to an oracle db

It required certain host/user/cid combination to pass the whitelist.

I've used both; DBeaver for personal stuff, Heidi at work. Heidi has a much more intuitive interface, IMHO

For me, DbBeaver is jack-of-all-trades, master of none. Seems to handle every database known to mankind, but not a fantastic user experience. While HeidiSQL is a work of art for MySQL / MariaDB, but not much else. I use & appreciate both in different ways.