MariaDB longblob column

I am new here. I am looking for a replacement for Beekeeper Studio, which I have been using for a few years.

I have a small MariaDB database on my LAN that has a longblob column to hold images. The entire database is less than 300MB with just under 400 records. I am careful to scale images down before adding them.

Whenever I run a query in Beekeeper Studio that includes the longblob column it crashes. Any query that does not include the longblob column works normally. The web application that uses the database also has no problem running queries and stored procedures in the background and displaying the images stored in the column. The server that holds the database is running Ubuntu Server and Apache, so I can use phpMyAdmin but it is not very user friendly for even simple queries.

Can I expect similar issues with HeidiSQL? I would be installing it on a workstation running Ubuntu 24.04.

Looking forward to a reply.

There are indeed some issues with large blob fields, for instance displaying them as an image preview is very slow. And editing these can be a pain. But real crashes should not happen here. I would recommend to give it a try. HeidiSQL has native Linux builds and deb/rpm packages since one year, which should be quite stable currently.

Thanks for the quick reply.

I have no need to display images in a preview. I use the PHP web application for that.

I will give HeidiSQL a try and let you know if it solves my problem.

That worked. Downloaded and installed and first "session" created. "Select *" query on database table containing longblobs now works. No crash.

Thank you very much.