Re: Advice on how to memorize images
Vittorio schreef: I'm now moving my first steps in trying to memorize my many digital photos (for the time being some 700 pictures but rapifdly growing, average size among 800-900kb) in a centralised system easy to deal with. I'm now successfully (but still in an experimental level) using a postgresql 8.0.2 db with its wonderful lo_creat, lo_export, etc functions. Unfortunately I've read in the internet many criticism on the use of mysql or pgsql db to memorize images, that this is not an efficient way to do the job (no alternatives seem to be proposed anyway!) because the db easily becomes cumbersome (isn't that the core business of a great db such as mysql or pgsql?). Could someone out there tell an almost definite word on this subject with some suggestions (other applications?) based on real experience? Ciao Vittorio ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] Hi, I'm not a db guru but I have done some experimenting with pictures in postgres and was quiet happy with it. I do however prefer to keep the data and the pictures separate because some programs have difficulty with pictures in postgres, or it's just very hard to program. I now use an http server secured with digest authentication, I then up and download the pictures from python. The main advantages for me are: -easy to work with, you view your picture from any programming language with url support or from any web based solution. -the pictures are stored on a different raid wich is not as fast as the primary but a lot larger. -database backups remain fast while I can use lots of different methods to backup the pics. I think pictures in the db is not such a problem but if you have a lot of pictures (eg 100 gig) it could become a little bit clumsy. It also depends on the rest of the application. just my toughts ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Advice on how to memorize images
In response to Vittorio [EMAIL PROTECTED]: I'm now moving my first steps in trying to memorize my many digital photos (for the time being some 700 pictures but rapifdly growing, average size among 800-900kb) in a centralised system easy to deal with. I'm now successfully (but still in an experimental level) using a postgresql 8.0.2 db with its wonderful lo_creat, lo_export, etc functions. Unfortunately I've read in the internet many criticism on the use of mysql or pgsql db to memorize images, that this is not an efficient way to do the job (no alternatives seem to be proposed anyway!) because the db easily becomes cumbersome (isn't that the core business of a great db such as mysql or pgsql?). I highly recommend that you research some of the available open source image organizers. PostgreSQL would do excellent as a storage system for your pictures, but you'd have to program in all the methods you wanted to used to catalog them and so forth. If you grab one of the existing album programs, it will have all of that, including tools to crop your photos, adjust for redeye, do fancy effects, etc, etc ... I was at a LUG meeting where a number of these were presented recently, and I'll be damned if I can remember any software names ... Here are some that I found during some googling: http://gpc.sourceforge.net/ http://appliworks.jondesign.net/ http://f-spot.org/Main_Page -- Bill Moran http://www.potentialtech.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Advice on how to memorize images
Op dinsdag 10 april 2007, schreef Bill Moran: Hi, I was at a LUG meeting where a number of these were presented recently, and I'll be damned if I can remember any software names ... Here are some that I found during some googling: http://gpc.sourceforge.net/ http://appliworks.jondesign.net/ http://f-spot.org/Main_Page Digikam should be capable of that as well (frontend for gphoto and with album management) -- Bram Schoenmakers What is mind? No matter. What is matter? Never mind. (Punch, 1855) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Advice on how to memorize images
You can use MySQL or any other relational database to cross-reference/catalog storage locations and information about a large quantity of items/data such as pictures. IMHO, to make such a project worthwhile, you need a database design that serves your needs. If you don't want to design/develop it yourself, you can probably find a free cataloging program or database schema that will work well. You store the actual images in a filesystem, and insert database records that have a field for specifying the path/filename where the image is located and other fields such as date/time photograph was taken, a name and/or description, etc. You will want to have one or more tables for categorizing your images (at least two levels deep) to make it easier to find the one(s) you are looking for. I would provide several ways to cross-reference images (based on one or more criteria). Vittorio [EMAIL PROTECTED] wrote: I'm now moving my first steps in trying to memorize my many digital photos (for the time being some 700 pictures but rapifdly growing, average size among 800-900kb) in a centralised system easy to deal with. I'm now successfully (but still in an experimental level) using a postgresql 8.0.2 db with its wonderful lo_creat, lo_export, etc functions. Unfortunately I've read in the internet many criticism on the use of mysql or pgsql db to memorize images, that this is not an efficient way to do the job (no alternatives seem to be proposed anyway!) because the db easily becomes cumbersome (isn't that the core business of a great db such as mysql or pgsql?). Could someone out there tell an almost definite word on this subject with some suggestions (other applications?) based on real experience? Ciao Vittorio ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] - Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Advice on how to memorize images
Vittorio [EMAIL PROTECTED] wrote: I'm now moving my first steps in trying to memorize my many digital photos (for the time being some 700 pictures but rapifdly growing, average size among 800-900kb) in a centralised system easy to deal with. I'm now successfully (but still in an experimental level) using a postgresql 8.0.2 db with its wonderful lo_creat, lo_export, etc functions. Why not use a pre-built image gallery application: Coppermine: http://coppermine-gallery.net/ Gallery : http://gallery.sourceforge.net/ MG2 : http://www.minigal.dk/ malcolm ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]