B4J Question [BANano]: How to save, read, show images in a BLOB field in a database

VittorioBarile said:

Hello,
i need to save, read and show images in a BANano Project from BLOB field in DB.
I search on forum but there aren't any topic about it.

Could you help me guys?

Thanks a lot ^_^

Click to expand...

That is not a BANano specific question. There are plenty of code samples and threads related to MySQL and blob field, specially images related.
Just do a simple search.

Basically it is a BAD practice to store images in a Database. Store them on HDD and remember the path to the file in the Database.

In my app I gave users the option to send files to one another. What I did was:
1. Similar to Manfred's suggestion, I would upload the file to the server and just store the URL address in the database.
HOWEVER, to make sure it's not accessed by others just by knowing the file name, I would store the file on the server with a random junk name (like AD76wadawd.f) and again put that name and the real name in a database field.

Just found out that one can get the base 64 string of an image from the assets folder like this:


I guess one can then save this on a db and then extract this and save it back as an image.

I wouldnt not do this though..