From owner-freebsd-questions@FreeBSD.ORG Tue Apr 10 13:29:26 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4A5F216A406 for ; Tue, 10 Apr 2007 13:29:26 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by mx1.freebsd.org (Postfix) with ESMTP id 1C6DB13C4D1 for ; Tue, 10 Apr 2007 13:29:26 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from vanquish.pgh.priv.collaborativefusion.com (pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTP id DCF12EBC6D; Tue, 10 Apr 2007 09:29:24 -0400 (EDT) Date: Tue, 10 Apr 2007 09:29:23 -0400 From: Bill Moran To: Vittorio Message-Id: <20070410092923.c5b02c08.wmoran@potentialtech.com> In-Reply-To: <111db67e68f.vdemart1@tin.it> References: <111db67e68f.vdemart1@tin.it> X-Mailer: Sylpheed 2.3.1 (GTK+ 2.10.11; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: Advice on how to memorize images X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Apr 2007 13:29:26 -0000 In response to Vittorio : > 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