DataBases and how to store images on mobile devices(?)

[DevBoyLars]

Hi there,
I want to build an App, which takes pictures on mobile devices and save them (not in cam-roll).

Would it be the best way to create a (SQL?) database and save the filenames (with category) inside and save the images in folders or is it possible/better to store the image itself into a database?

Thank you

[DevBoyLars]

No one can help?

[jmburnod]

Hi DevboyLars,
You can store the images in a subfolder of the documents folder of the sandbox of your app
Best regards
Jean-Marc

[DevBoyLars]

Thank you

And would it be better to store the filenames in a SQL-DB or use XML?

[jmburnod]

And would it be better to store the filenames in a SQL-DB or use XML?

Sorry I don't use them.
I use the directory of the images folder to build an index of files which is stored in a simple .txt file

[DevBoyLars]

Could you post an example-code, please?

[jmburnod]

I use the files in this script but you can use detailed files to get more information about each file

Code: Select all

on mouseUp
   answer folder "Open:"
   if it = empty then exit mouseUp
   put the defaultfolder into tODF
   put it into sCurFolPict
   set the defaultfolder to it
   put the files into tFiles
   filter tFiles without ".*"
   put sCurFolPict & "/" & "myIndex" into tUrl
   put tFiles into url("file:" & tUrl)
   set the defaultfolder to tODF
end mouseUp