From owner-freebsd-questions@FreeBSD.ORG Tue Apr 10 12:46:27 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 E6A3F16A401 for ; Tue, 10 Apr 2007 12:46:27 +0000 (UTC) (envelope-from bram@diomedia.be) Received: from adicia.telenet-ops.be (adicia.telenet-ops.be [195.130.132.56]) by mx1.freebsd.org (Postfix) with ESMTP id 80E1D13C458 for ; Tue, 10 Apr 2007 12:46:27 +0000 (UTC) (envelope-from bram@diomedia.be) Received: from localhost (localhost.localdomain [127.0.0.1]) by adicia.telenet-ops.be (Postfix) with SMTP id 9668F23010F for ; Tue, 10 Apr 2007 14:46:26 +0200 (CEST) Received: from [192.168.1.160] (d5152F411.access.telenet.be [81.82.244.17]) by adicia.telenet-ops.be (Postfix) with ESMTP id 7BE2323011C for ; Tue, 10 Apr 2007 14:46:26 +0200 (CEST) Message-ID: <461B86EC.7010605@diomedia.be> Date: Tue, 10 Apr 2007 14:45:32 +0200 From: bram User-Agent: Thunderbird 1.5.0.10 (X11/20070302) MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: <111db67e68f.vdemart1@tin.it> In-Reply-To: <111db67e68f.vdemart1@tin.it> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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 12:46:28 -0000 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 "freebsd-questions-unsubscribe@freebsd.org" > 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