Android Question PNG or Blob

[Shelby]

Hi All,
I have completed my repository of 500 plus images for my SQLite table to display a respective image when one value in a row is clicked. I've read some about blob images so I'm not sure if my PNG image files will suffice for my purpose but that's the format I used. Here's my SQLite app as prepared for me months ago by Klaus. I'm thinking of making a 5th column where the value will display the respective image when the value is clicked or use my present 4th column to serve as the clickable value. My first question is: Can I use the PNG images for the function of display?
Thanks

 

[TILogistic]

see:

Can I use the PNG images for the function of display?

view png

[B4X] ZoomImageView - Cross platform zoomable + pannable image view

A custom view that shows an image and allows the user to zoom and pan the image. Instructions: - Add with designer. - Call SetBitmap. Updates: v1.05 - Base_Resize is public. Call it after resizing the view in B4A. v1.04 - Fixes an issue in B4i where the image jumps when switching from pinch...

www.b4x.com

[B4X] HugeImageView - show very large images

Q: I want to load a 10,000 x 10,000 image? A: That's impossible!!! The memory required is: width * height * 4 = 400MB. A: You will need to scale down the image. A: Sure. Use HugeImageView: (image source: https://images4.alphacoders.com/655/655004.jpg) How does it work? It uses two layers -...

www.b4x.com

 

[TILogistic]

Your 5th column will be a text type field that will contain an external link to the image, or base64 encoding, or will it be an image blob field?

 

[Shelby]

I don't know if my image repository should be internal or external. I want the entire program to be eventually encrypted if that has any relevance. I'm not sure what a blob is nor if I should use blobs or some other format for image files. The clickable field could be either text or integer if you ask me. The value will be a page number clickable; or it could be a message like "click for image".

 

[TILogistic]

In general, it is not recommended to have the images stored in the database, because they cause slow access and increase the size of the database.

It is suggested to save the external link where the image is located, which can be a directory on your server.

 

[TILogistic]

see:

[B4X] BitmapsAsync

Don't use this. Better implementation in SimpleMediaManager: https://www.b4x.com/android/forum/threads/b4x-simplemediamanager-smm-framework-for-images-videos-and-more.134716/#content A cross platform library that allows loading images using background threads. It can be useful with keeping the...

www.b4x.com

 

[Shelby]

OK, that sounds like what I need.

 

[Shelby]

see:

[B4X] BitmapsAsync

Don't use this. Better implementation in SimpleMediaManager: https://www.b4x.com/android/forum/threads/b4x-simplemediamanager-smm-framework-for-images-videos-and-more.134716/#content A cross platform library that allows loading images using background threads. It can be useful with keeping the...

www.b4x.com

Thanks