HeidiSQL Available Also for Linux • Hacker News Board

Re: HeidiSQL Available Also for Linux

#41

Post by racl101 » Mon, Jun 02, 2025, 4:03 PM UTC

Pretty great program for Windows.

Re: HeidiSQL Available Also for Linux

#42

Post by redditor98654 » Mon, Jun 02, 2025, 4:22 PM UTC

wiether wrote: post #40

redditor98654 wrote: post #18

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 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...

I use the dedicated app but IntelliJ ultimate bundles datagrip into the ide too.

Re: HeidiSQL Available Also for Linux

#43

Post by rd07 » Mon, Jun 02, 2025, 4:33 PM UTC

I have wanted to try HeidiSQL before, but the lack of Linux version stopped me. Now, that it releases a Linux version, I think it is time to try it. Currently, I am using DbGate (daily) and DBeaver (occasionally). Feature-wise, DBeaver is better than DbGate, but it is slower than DbGate. Now let's see if Heidi is better than those two.

Re: HeidiSQL Available Also for Linux

#44

Post by orthecreedence » Mon, Jun 02, 2025, 7:53 PM UTC

cies wrote: post #24

deergomoo wrote: post #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?

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.

This is my exact experience with DBeaver. Absolutely cannot stop all the frustrating popups. Finally got fed up and started using vim+dadbod and while the experience is a bit less batteries-included, I was mostly just using DBeaver to run raw SQL anyway, and have been on vim for over a decade so that's an option for me. Now my SQL queries live in per-project versioned files instead of some eclipse project folder somewhere and I can edit them with all the power of vim which speeds up my workflows.

But nobody's going to do this without being a huge vim nerd, so I recognize it's not a general alternative.

Re: HeidiSQL Available Also for Linux

#45

Post by Shorel » Mon, Jun 02, 2025, 8:33 PM UTC

This is one of those programs that are so good and feature-rich that, even though I use Linux full time, I installed Wine to use the Windows version.

No other Linux program has anywhere near half the features of HeidiSQL. Saying this is great news is an understatement.

Re: HeidiSQL Available Also for Linux

#46

Post by dhfbfb » Mon, Jun 02, 2025, 8:50 PM UTC

Shorel wrote: post #45

This is one of those programs that are so good and feature-rich that, even though I use Linux full time, I installed Wine to use the Windows version. No other Linux program has anywhere near half the features of HeidiSQL. Saying this is great news is an understatement.

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?

Re: HeidiSQL Available Also for Linux

#47

Post by spapas82 » Mon, Jun 02, 2025, 9:28 PM UTC

Heidi is the best gui for mysql/mariadb. It's really great and I don't change it with anything when i need to work on mysql servers.

Unfortunately it's not that good on postgres or ms sql server. Feels more buggy and slow for these databases but I'm not sure if it's Heidi or the db drivers.

I'm also one of the people that used heidi on Linux with wine (along with notepad++) so a native version is more than welcome!

Re: HeidiSQL Available Also for Linux

#48

Post by Grazester » Mon, Jun 02, 2025, 10:03 PM UTC

I use Heidi SQL daily but then again if I had to do anything major I would return to MS SQL management studio. Heidi can be buggy at times.

Re: HeidiSQL Available Also for Linux

#49

Post by rorylaitila » Mon, Jun 02, 2025, 10:36 PM UTC

I like how snappy and easy HeidiSQL is, I still use it when I need to manually twiddle some bit. But it's buggy and I don't write any SQL in it as I've lost enough code mid writing. DBeaver is my daily driver now.

Re: HeidiSQL Available Also for Linux

#50

Post by sakesun » Tue, Jun 03, 2025, 7:01 AM UTC

Daril wrote: post #33

igitur wrote: post #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 s…

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.

These days Delphi has community license for non-commercial use