Live data from Hacker News

HeidiSQL Available Also for Linux

heidisql.com

31–40 of 51 posts

Re: HeidiSQL Available Also for Linux

#31
post #25
post #19

Earlier quoted context omitted.

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.

But has a very complex and busy UI that, for whatever reason, makes it difficult/tiring for me to use.

Very emblematic of it's Java GUI roots.

Re: HeidiSQL Available Also for Linux

#32
post #31
post #25

Earlier quoted context omitted.

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

But has a very complex and busy UI that, for whatever reason, makes it difficult/tiring for me to use. Very emblematic of it's Java GUI roots.

Yeah. Some tools are used by many for a long time and get lots of features in the process...

And some tools dont...

Re: HeidiSQL Available Also for Linux

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

Re: HeidiSQL Available Also for Linux

#34
post #33
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.

> easily

Depending on how OS-independent it is, it might just be a matter of opening the project file and selecting Run -> Build (yes, the fact that Build is under Run is something that always bothered me, but it has been like that for 22+ years now). However the resulting app will be very "win-like" and when i was making macOS builds using Lazarus back when i cared about macOS i always had a "Macize" function i called at startup (ifdef'd for mac builds) that did things like replace the Ctrl modifier shortcuts with Command in menus (you can enumerate the menus, no need to do that by hand), move the About command to the apple menu, etc. There are also some other things that you may feel like doing.

TBH one thing that i wish was possible with Lazarus (at the time, now i don't care much :-P) was to be able to define different "layouts" per widgetset in a way that allowed you to use, say, a 'default' layout for Windows and Linux but a modified layout for macOS. Technically it is possible to design a form and then have another form inherit from it and apply modifications there, but it feels kinda awkward to use for different layouts (it is mainly meant for creating forms that you want to reuse but still have modifications - and it can be clunky in how it decides when to ignore changes in the base form or not - i do not use visual form inheritance, but i do use frames to design reusable controls visually and i often have to edit the source code of form files that use frames to remove overrides after saving the form so that changes to the frame are reflected in all forms that use it - this makes me want to add a readonly property to frames at some point :-P).

Re: HeidiSQL Available Also for Linux

#36
post #17

Earlier quoted context omitted.

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…

> DBeaver has the worst name in history Hey man. You take that back.

GIMP would like a word...

Re: HeidiSQL Available Also for Linux

#37
post #33
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.

Since Linux version works, I wonder if it could work on Mac, too?

Re: HeidiSQL Available Also for Linux

#38
post #31
post #25

Earlier quoted context omitted.

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

But has a very complex and busy UI that, for whatever reason, makes it difficult/tiring for me to use. Very emblematic of it's Java GUI roots.

You can turn off most of them.

Re: HeidiSQL Available Also for Linux

#40

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

Post reply on HN