Android Question PNG or Blob

Shelby

Well-Known Member
Licensed User
Longtime User
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
 

Attachments

  • SS2021V11.zip
    51 KB · Views: 214
Last edited:
Sort by date Sort by votes

TILogistic

Expert
Licensed User
Longtime User
see:
Can I use the PNG images for the function of display?
Click to expand...
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
 
Upvote 1

TILogistic

Expert
Licensed User
Longtime User
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?
 
Upvote 0

Shelby

Well-Known Member
Licensed User
Longtime User
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".
 
Last edited:
Upvote 0

TILogistic

Expert
Licensed User
Longtime User
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.
 
Upvote 0

TILogistic

Expert
Licensed User
Longtime User
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
 
Upvote 1

Shelby

Well-Known Member
Licensed User
Longtime User
Thanks
 
Upvote 0
You must log in or register to reply here.

Similar Threads

S
  • Solved
Android Question Tool to convert B4X view to a JPG or PNG image
Replies
8
Views
2K
Sergio83
S
  • Question
Android Question widget preview image in some other folder ?
Replies
0
Views
744
AnandGupta
B
  • Question
Android Question [SOLVED]Blob Field Containing Picture Not Updating
Replies
3
Views
1K
Big Dave
B
K
  • Question
Android Question How to use base64 (blob image) image to ImageSlider
Replies
3
Views
2K
Erel
M
  • Question
Android Question [RESOLVED] Download image BLOB and insert into SQLite DB
Replies
14
Views
7K
mfstuart
M
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…