[Bug]: MySQL Blobs render all blob content and freezes the app

[mudrockdev]

Describe the bug

I have a table with Image Blobs in it.
When I query few rows the UI tries to render few MiBs of Blob data.
All UI becomes frozen and restart needed on Tabularis client.

I suggest a setting for seeing blobs as their file header instead of actual blob content.

This is the way how AntaresSQL handles the issue.

To Reproduce

1. Open any table has any type of BLOB column.
2. Query rows.

OS Version

Fedora 41

Tabularis Version

v0.8.14

Relevant Log Output

[debba]

Hi @mudrockdev !
Yes looks the right solution.
I will do it

[debba]

Hi @mudrockdev !
Can you do a check from branch: feat/blob-data-type ?

[mudrockdev]

I tested it on MySQL 8.4.
My tests are:

• Uploading few types of images and audios and getting them back.
• Uploading files with wrong extensions.

• Only issue I found is when I set a blob field empty. It shows plain/text on sidebar but when I submit the row says application/octet-stream.

• I think we can just remove the Set EMPTY instead of fixing it, because BLOB is used for Binary Data otherwise people would use TEXT types.

[debba]

Yes i will do it tomorrow, I am afk now.
Feel free to change it if you want .