From owner-freebsd-questions@FreeBSD.ORG Tue Apr 10 12:27:28 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 D9C4216A405 for ; Tue, 10 Apr 2007 12:27:28 +0000 (UTC) (envelope-from vdemart1@tin.it) Received: from vsmtp21.tin.it (vsmtp21.tin.it [212.216.176.109]) by mx1.freebsd.org (Postfix) with ESMTP id A193A13C45A for ; Tue, 10 Apr 2007 12:27:28 +0000 (UTC) (envelope-from vdemart1@tin.it) Received: from pswm6.cp.tin.it (192.168.70.26) by vsmtp21.tin.it (7.2.072.1) id 460D2908001423B2 for freebsd-questions@freebsd.org; Tue, 10 Apr 2007 14:11:31 +0200 Message-ID: <111db67e68f.vdemart1@tin.it> Date: Tue, 10 Apr 2007 13:11:31 +0100 (GMT+01:00) From: Vittorio To: freebsd-questions@freebsd.org Mime-Version: 1.0 Content-Type: text/plain;charset="UTF-8" Content-Transfer-Encoding: 7bit X-Originating-IP: 194.185.25.73 Subject: Advice on how to memorize images X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Vittorio List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Apr 2007 12:27:28 -0000 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