coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: go4java on August 24, 2006, 08:46:22 PM

Title: Coppermine // Picture Database Design
Post by: go4java on August 24, 2006, 08:46:22 PM
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!
Title: Re: Coppermine // Picture Database Design
Post by: Gizmo on August 25, 2006, 03:41:21 PM
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 (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 (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 (http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#BackupDatabase).

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