Store Images in SQLite database and retrieve in ios5

Question

I am using SQLite 3.0 and iOS5.

Now I want to store images in vrchar2 datatype in database and retrieve it in my iPhone's view.

I have used images stored in BLOB data type and through NSDATA I have retrieved it..Nut now I want to retrieve it in ImageView ..

How can I use it?

As an aside, there is a difference of opinion in some circles about images and DBs. In one camp you have the "Store the image in the DB", and in the other camp, "Keep the image in the filesystem and store the path to the image in the DB". There are tradeoffs with each method. — Peter M, Feb 13 '12 at 16:47
This link help you. http://stackoverflow.com/questions/10811437/store-images-in-to-sqlite-database — Gajendra K Chauhan, Jun 20 '13 at 05:52

score 1 · Answer 1 · answered Feb 13 '12 at 11:25

1

You should first create a UIImage from NSData using:

UIImage *img = [[UIImage alloc] initWithData:theData];

Then you can use this image in your image view:

UIImageView *imgView = [[UIImageView alloc] initWithImage: img];

Don't forget to do the proper memory management though!

answered Feb 13 '12 at 11:25

Bani Uppal

866
9
17

But how can I retrive image from perticluar row from database? – Khushbu Shah Feb 13 '12 at 11:34
For that, you need to have some logic as to which image you are fetching. What exactly you want to achieve? theData indicates the NSDATA that you had mentioned in your question that you had retrieved. – Bani Uppal Feb 13 '12 at 12:31

score 1 · Answer 2 · answered Feb 14 '12 at 08:32

Is there any specific reason of using the whole image in to database?

The reason behind asking this is simply because I think storing NSData in database is storing a lot of data in the database, which on a longer run can make your database really heavy.

Better option is to save the image in Documents Directory or may be Library directory for that matter and then simply saving the full image path of the image in your database.

Then simply which retrieving it in an imageView you need to call

UIImageView *imgView = [UIImageView setImage:[[UIImage alloc] initWithContentsOfFile:filePath]];

Here all you need to pass is "filePath" which you have fetched from database.

Hope this helps you.

Yeah...Better option...I will try..Thanks – Khushbu Shah Feb 14 '12 at 09:07 — Khushbu Shah, Feb 14 '12 at 09:07

alecnash · Accepted Answer · 2012-02-13T16:29:53.357

You have to create a DAO so that you can retrieve the information form the sqlite file. Then call that file to get all the info you need. Then retrieve the blob like this:

const char * myData = sqlite3_column_blob(statement, 1(this number is different according to your database));
int myDataSize = sqlite3_column_bytes(statement, 1);
NSData *data = [NSData dataWithBytes:myData length:myDataSize];

Then initialize

myPhoto.thePhoto = [[UIImage alloc] initWithData:data];

Store Images in SQLite database and retrieve in ios5

3 Answers3