Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
New Contributor
Posts: 4
Registered: ‎02-01-2012
My Device: Blackberry Torch 9860
My Carrier: Rogers

SQLite Inserting and Selected images using Blobs

I have a SQLite database that I need to store images (i.e JPEG's) in as BLOBs.

 

I'm not sure the best way to go about inserting images into the BLOB and later retrieving it via a Select statement.

Developer
Posts: 467
Registered: ‎07-16-2009
My Device: Z10 LE
My Carrier: Vodafone NL

Re: SQLite Inserting and Selected images using Blobs

Just one question - why not file? You could save filename to db and use from select. I see one adavanatge of it that you coudl load images in another thread and present other info from db after select.

 

I don't know also how db works with blob - does it load blob on select or only when you getting from cursor?

New Contributor
Posts: 4
Registered: ‎02-01-2012
My Device: Blackberry Torch 9860
My Carrier: Rogers

Re: SQLite Inserting and Selected images using Blobs

Unfortunetly I am connecting to a desktop application (I can't change this code) and syncing the blackberry app's database with the desktop app's database and the images must be stored as BLOB's.