Recent

Author Topic: HeidiSQL 12.10 for Linux  (Read 1537 times)

anse

  • New Member
  • *
  • Posts: 31
  • Bugmonkey
    • HeidiSQL
HeidiSQL 12.10 for Linux
« on: May 03, 2025, 11:15:29 am »
As the title says, I copied the current Delphi code base of HeidiSQL to a Lazarus branch and converted 80% of the things which are different in Delphi/Lazarus.
HeidiSQL is a database manager for MySQL, MariaDB, SQLite, PostgreSQL. Support for MS SQL and Interbase/Firebird are available in the Delphi/Windows version, but have to be rewritten for Linux.

https://github.com/HeidiSQL/HeidiSQL/tree/lazarus

There's a Debian/Ubuntu package available on the download page: https://www.heidisql.com/download.php - it will install the latest binary, an icon and translation .mo files used by HeidiSQL. An rpm package for RedHat Linux and a macOS compile target is on the todo list.

I learned a lot about Lazarus and FPC in the recent months. And I want to express my gratitude for such an excellent software and the inspiring community.

JD

  • Hero Member
  • *****
  • Posts: 1908
Re: HeidiSQL 12.10 for Linux
« Reply #1 on: May 03, 2025, 11:27:15 am »
@anse

This is absolutely wonderful. Thank you so much for your work and commitment. I use HeidiSQL in environments where, for security reasons, I cannot install anything. I just unzip the portable app and do my work. Now that it is coming to Linux, I'll use it in my Linux deployments too.  :D :D
Linux Mint - Lazarus 4.0/FPC 3.2.2,
Windows - Lazarus 4.0/FPC 3.2.2

mORMot 2, PostgreSQL & MariaDB.

JD

  • Hero Member
  • *****
  • Posts: 1908
Re: HeidiSQL 12.10 for Linux
« Reply #2 on: May 03, 2025, 11:43:40 am »
@anse

I compiled it without issues using Lazarus 4RC3/FPC 3.2.2 on Linux Mint 22.1 Cinnamon :D. And I was able to connect to my principal PostgreSQL database inside a Docker container.

However, the size of the application's icon is too large. See attached screenshot. In addition, opening the Preferences dialog takes a little while and can hang the application. It is also not possible to change the interface language, the only option is *** Auto-detect.

Cheers,

JD
« Last Edit: May 03, 2025, 11:58:02 am by JD »
Linux Mint - Lazarus 4.0/FPC 3.2.2,
Windows - Lazarus 4.0/FPC 3.2.2

mORMot 2, PostgreSQL & MariaDB.

JD

  • Hero Member
  • *****
  • Posts: 1908
Re: HeidiSQL 12.10 for Linux
« Reply #3 on: May 03, 2025, 11:59:46 am »
Quote
I copied the current Delphi code base of HeidiSQL to a Lazarus
Copyright and lince issues: therefor I can't use that.
You are advertising your own coyright and license infringement and so makes you an offender.

Correct me if I'm wrong, but the GitHub profile of this port to Lazarus and the profile of the developer on the application's website are the same. What did I miss?

JD
« Last Edit: May 03, 2025, 12:01:33 pm by JD »
Linux Mint - Lazarus 4.0/FPC 3.2.2,
Windows - Lazarus 4.0/FPC 3.2.2

mORMot 2, PostgreSQL & MariaDB.

Thaddy

  • Hero Member
  • *****
  • Posts: 18344
  • Here stood a man who saw the Elbe and jumped it.
Re: HeidiSQL 12.10 for Linux
« Reply #4 on: May 03, 2025, 12:02:22 pm »
I missed that. Will remove my post.
Due to censorship, I changed this to "Nelly the Elephant". Keeps the message clear.

paweld

  • Hero Member
  • *****
  • Posts: 1500
Re: HeidiSQL 12.10 for Linux
« Reply #5 on: May 03, 2025, 12:17:48 pm »
Quote
I copied the current Delphi code base of HeidiSQL to a Lazarus
Copyright and lince issues: therefor I can't use that.
You are advertising your own coyright and license infringement and so makes you an offender.

Correct me if I'm wrong, but the GitHub profile of this port to Lazarus and the profile of the developer on the application's website are the same. What did I miss?

JD
Even if they wouldn't be the same, it doesn't matter, because as the author (copyright holder) can change the license.

@anse: great work
Best regards / Pozdrawiam
paweld

JD

  • Hero Member
  • *****
  • Posts: 1908
Re: HeidiSQL 12.10 for Linux
« Reply #6 on: May 03, 2025, 12:22:32 pm »
I missed that. Will remove my post.

I guess you can now use it without mixed feelings.  :D

The more applications are ported to Lazarus, the better it is for our community.

 :D :D
Linux Mint - Lazarus 4.0/FPC 3.2.2,
Windows - Lazarus 4.0/FPC 3.2.2

mORMot 2, PostgreSQL & MariaDB.

ALLIGATOR

  • Sr. Member
  • ****
  • Posts: 294
  • I use FPC [main] 💪🐯💪
Re: HeidiSQL 12.10 for Linux
« Reply #7 on: May 03, 2025, 03:10:33 pm »
Great news about great software, yoo-hoo!
I may seem rude - please don't take it personally

LemonParty

  • Sr. Member
  • ****
  • Posts: 362
Re: HeidiSQL 12.10 for Linux
« Reply #8 on: May 03, 2025, 04:35:54 pm »
Good news. I used HeidiSQL on Windows. Useful program.
Lazarus v. 4.99. FPC v. 3.3.1. Windows 11

anse

  • New Member
  • *
  • Posts: 31
  • Bugmonkey
    • HeidiSQL
Re: HeidiSQL 12.10 for Linux
« Reply #9 on: May 03, 2025, 04:50:23 pm »
Thanks a lot for all of your feedback. And yes, I am also the maintainer and founder of HeidiSQL's code, so there's no need to worry about copyright.

Quote
However, the size of the application's icon is too large. See attached screenshot. In addition, opening the Preferences dialog takes a little while and can hang the application. It is also not possible to change the interface language, the only option is *** Auto-detect.

Yes, the icon is not only too large, its colors are also broken. I probably need to use a 48x48 px png instead of the 256x256, and another bit depth.
The languages .mo files are installed when you use the .deb package. I thought localization is not important to have at development time. But I guess I should drop a note near that drop-down, saying I could not find any .mo files.

And yes, I also noted the (short) waiter when opening the preferences. Smells like slow code somewhere. Will have a look.

dseligo

  • Hero Member
  • *****
  • Posts: 1601
Re: HeidiSQL 12.10 for Linux
« Reply #10 on: May 03, 2025, 05:46:48 pm »
Very nice! :)

cris75

  • Jr. Member
  • **
  • Posts: 75
Re: HeidiSQL 12.10 for Linux
« Reply #11 on: May 05, 2025, 04:15:07 pm »
@anse

WOW! Wonderful news!
I also use HeidiSQL very often, so I am really happy that there will be a native Linux version of your (very useful) DB Manager!!
This way I'll not be forced to use a VM to use it!
Thank you really very much for your work, really appreciated!!  :D :D
Lazarus: 4.2 / FPC: 3.2.2 [x86_64-win64-win32/x86_64-linux-qt5/]
Win10 x64
Debian 12

 

TinyPortal © 2005-2018