Live data from Hacker News

HeidiSQL Available Also for Linux

heidisql.com

21–30 of 51 posts

Re: HeidiSQL Available Also for Linux

#21
Heidi was the default option on our work machines a few years ago and it’s one of the buggiest pieces of software I’ve ever used.

Does it still lock up the entire UI if a query takes longer than five seconds to return results? Does it still pop up exception dialogs every ten minutes when it’s been open for longer than a few hours?

Re: HeidiSQL Available Also for Linux

#22

If you have the license for it, it is hard to beat Datagrip from Jetbrains. Support for just about any database and also integrated support for AI/Copilot making it much easier to write exploratory queries.

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!

Re: HeidiSQL Available Also for Linux

#23

I'm curious if anyone here has any experience with DbBeaver and HeidiSQL and can make a comparison. I've been using DbBeaver for a while, but the interface is... strange. Will probably try Heidi tomorrow.

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.

Re: HeidiSQL Available Also for Linux

#24

Heidi was the default option on our work machines a few years ago and it’s one of the buggiest pieces of software I’ve ever used. Does it still lock up the entire UI if a query takes longer than five seconds to return results? Does it still pop up exception dialogs every ten minutes when it’s been open for longer than a few hours?

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.

Re: HeidiSQL Available Also for Linux

#25
post #19

If you have the license for it, it is hard to beat Datagrip from Jetbrains. Support for just about any database and also integrated support for AI/Copilot making it much easier to write exploratory queries.

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 tim…

DBeaver is free, quite full featured (no AI) and FLOSS.

Re: HeidiSQL Available Also for Linux

#26

Heidi was the default option on our work machines a few years ago and it’s one of the buggiest pieces of software I’ve ever used. Does it still lock up the entire UI if a query takes longer than five seconds to return results? Does it still pop up exception dialogs every ten minutes when it’s been open for longer than a few hours?

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.

Re: HeidiSQL Available Also for Linux

#29
post #19

If you have the license for it, it is hard to beat Datagrip from Jetbrains. Support for just about any database and also integrated support for AI/Copilot making it much easier to write exploratory queries.

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 tim…

I love TablePlus. I basically use it for everything at this point even though I have a JetBrains all prod license. Never liked DataGrip.

Re: HeidiSQL Available Also for Linux

#30
Long time user of HeidiSQL here. I respect the author a lot. He's been tirelessly working on this project for many years, mostly alone. Of course, that's due to the closed nature of Delphi.

It's great news that this is now available for Linux, but the better news for me is that I can now build it on Lazarus / FreePascal. Even if it doesn't support all the features (eg MSSQL), at least I can now contribute fixes for some UI issues that have been bothering me.

I can successfully build the FreePascal version on Windows and it runs... fine. Feels a little less snappy than the Delphi version and there are some UI padding issues. But it's a massive step in the right direction.

If you can, please support this project, either financially or through code. contributions. IHMO what is dearly needed is for the different SQL dialects to be abstracted out properly. It's currently done in a bit of a crude way (no disrespect to the author) and it will require a big refactoring to get it right, but will open doors to more dialects.

Post reply on HN