Coppermine // Picture Database Design

[go4java]

I've a general question before starting with COPPERMINE:
I plan a database like that:
1. COUNTRY
2. each Country has its own PROJECTS
3. each PROJECT may have 1...n pictures with thumbnails
4. each thumbnail has THREE pictures of different quality (72, 150, 300dpi)

Is such a structure possible with COPPERMINE - is it flexible enough?

A. How is the process of Uploading pictures? Is it 'easy'?
B. Is there a way of getting all the data stored for safety reasons (Backup/Restore)?

Thanks for your feedback!

[Gizmo]

Actually, as you have described it Coppermine is perfect.

I plan a database like that:
1. COUNTRY - This would be a Category.
2. each Country has its own PROJECTS - This would be a sub-category or in other words, a category within a category.
3. each PROJECT may have 1...n pictures with thumbnails - This would be an Album.
4. each thumbnail has THREE pictures of different quality (72, 150, 300dpi) - You can create a thumbnail, intermediate picture and high-quality popup photo. It's easy to allow only registered users to see the intermediate or popup photos if you wish. See here for setting on intermediate and thumbnail quality - http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_picture_thumbnail

Read up here on ways to upload pictures - http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#uploading.
Read here for backing up Coppermine - http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#BackupDatabase.

The documentation and forum is most valuable so have a look through it.