Image / Video paths in database for Android tablet app

[jim1001]

I've been asked by a researcher to develop an Android tablet application that allows users to view images & videos they have taken with the tablet and optionally label them as a favourite or as “special”.

The researcher also wants to pre-load videos onto the tablet from an external source which will be displayed as a separate “album” to the images & videos taken by the user. The user should also be able to label these pre-loaded videos as favourite or “special”.

I was thinking to create the app using a database & rather than storing the full binary data of each image/video in the database (as in LiveCode App Building Course Photos App #9) only store the paths to the images/videos there.

Does that sound reasonable/possible?

Any help/advice appreciated.

Thanks,
Jim

[MaxV]

No problem on Android, read here: http://livecode.wikia.com/wiki/Saving_files_on_Android

[jim1001]

Thank you MaxV. Looks like a lot of useful information on this Livecode Wiki - sure I"ll be using it again

Best wishes,
Jim

[okk]

Hi,
is there a special folderpath to images that were taken with different camera applications? If I understood correctly in Android images are in most cases stored in a special image folder? Let's assume I want to make an app which can browse all image files on that phone, where should i start looking? In an android forum it was suggested: "For internal phone storage, the directory is /mnt/sdcard/DCIM/Camera. For the external SD card, the directory is /mnt/sdcard-ext/DCIM/Camera." In other forums I read that the filepath for external SD card is /mnt/sdcard2/DCIM/Camera. It feels always risky to hardcode filepaths into the app, so something like specialFolderPath("images") and specialFolderPath("imagesexternal") would be great.

Thanks!
Oliver