B4J Question [ABMaterial] show blob image from mysql

[jayel]

How can I display a blob image from mysql on a page?

 

[alwaysbusy]

It is probably somehow possible if you use Base64, but this would be a huge overkill. (no caching for example). Having them on disk in e.g. jpeg format and using the url is really the way to go it in WebApps.

 

[Harris]

My app takes many pictures and stores each JPEG on disk - after transfer from the mobile device.
I find this easier and faster than storing images in a blob - which when researched, was not the optimized method to use.
Store a reference in your table to the file name on disk. When you need to deal with it (show it, delete it) - you know where to find it.

I tried using blob initially and it was a horrible mess (although it can be done using same method as B4A). When your data gets big, blobs are most problematic.

Good advise from the community on SourceForge.

Thanks