Date: Tue, 10 Apr 2007 14:45:32 +0200 From: bram <bram@diomedia.be> To: freebsd-questions@freebsd.org Subject: Re: Advice on how to memorize images Message-ID: <461B86EC.7010605@diomedia.be> In-Reply-To: <111db67e68f.vdemart1@tin.it> References: <111db67e68f.vdemart1@tin.it>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?461B86EC.7010605>