where to store images

[hanumandev]

I have an sqlite table that has 3 image fields (thumb, med, large) for 500 records. where is the best place to store these images?

seems strange to put 1500 images (3 images for each record) in the resoures folder.

also, I don't want to store them on an external server because the user needs to be able to access the records w/ images if they don't have a network connection.

thanks in advance for any help.

[zardon]

Originally Posted by hanumandev

I have an sqlite table that has 3 image fields (thumb, med, large) for 500 records. where is the best place to store these images?

seems strange to put 1500 images (3 images for each record) in the resoures folder.

also, I don't want to store them on an external server because the user needs to be able to access the records w/ images if they don't have a network connection.

thanks in advance for any help.

Some of the basic tutorials say use BLOBs to store images; but from my background as a web developer says this is wrong because if the db gets corrupted or something you have no backup.

I would either put the images on the phone; or perhaps put the resources online and then use a JSON request to pull them in? But it does mean the user needs to be online to use the app.

Another alternative would be to use PAK the files up, but I do not know if this is possible, reasonable or not.

[GWB104]

[quote=hanumandev;239050]I have an sqlite table that has 3 image fields (thumb, med, large) for 500 records. where is the best place to store these images?

Store the images as PNG files in separate folders in the resource folder (thumb, med, large folders)... the SDK and the IOS uses the PNG format the most efficiently. Have the db reference the image from the folders. Also when moving the images to the project select "copy" otherwise the image is just a reference to the original.

[TUX2K]

I would not suggest use PNG, the files will get very large just use JPG.
Also folder in the resource directory are not used on the phone, all the files in the resource directory just get copied in the bundle.
Be sure to have unique names for all the files.

I would just download the image when the user is about to view them, then store then (cache) in the documents directory.
There is a nice class for this in the 20three library called TTUrlChache.