Date: Tue, 10 Apr 2007 09:29:23 -0400 From: Bill Moran <wmoran@potentialtech.com> To: Vittorio <vdemart1@tin.it> Cc: freebsd-questions@freebsd.org Subject: Re: Advice on how to memorize images Message-ID: <20070410092923.c5b02c08.wmoran@potentialtech.com> In-Reply-To: <111db67e68f.vdemart1@tin.it> References: <111db67e68f.vdemart1@tin.it>
next in thread | previous in thread | raw e-mail | index | archive | help
In response to Vittorio <vdemart1@tin.it>: > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070410092923.c5b02c08.wmoran>