From owner-freebsd-questions@FreeBSD.ORG Wed Apr 11 01:15:38 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 36D7C16A400 for ; Wed, 11 Apr 2007 01:15:38 +0000 (UTC) (envelope-from xrayv19@yahoo.com) Received: from web58111.mail.re3.yahoo.com (web58111.mail.re3.yahoo.com [68.142.236.134]) by mx1.freebsd.org (Postfix) with SMTP id D882513C448 for ; Wed, 11 Apr 2007 01:15:37 +0000 (UTC) (envelope-from xrayv19@yahoo.com) Received: (qmail 51272 invoked by uid 60001); 11 Apr 2007 01:15:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=U0UcvViOVqex3t+ON4h1rMVjWBsJXay6JGKX/rJoOfkEjaozbSCCtcPc/sWPcgdUebz6EAvpLU5VL+H/iboIY8LPQNAiVgWI3WTrXc6CDOWx8deQpojUwmcxPydK3Zw2SyULpn7a3YCFDeX/l0Dhjm3s3w2+P1r75JFC/PyR1y8=; X-YMail-OSG: LgsIBicVM1lWtnyToYTTufj_40n_tIFFOiJjIQSK.szFZKFFPDaJZ65mkBQTDQPcfR_hv_l_uLsKKt3QG0_XSMj8NubIPtYb4TPdLMbS_Zg0nWhzmb7p.JfxuVsU7ABG Received: from [131.191.24.2] by web58111.mail.re3.yahoo.com via HTTP; Tue, 10 Apr 2007 18:15:36 PDT Date: Tue, 10 Apr 2007 18:15:36 -0700 (PDT) From: L Goodwin To: freebsd-questions@freebsd.org In-Reply-To: <111db67e68f.vdemart1@tin.it> MIME-Version: 1.0 Message-ID: <62670.49754.qm@web58111.mail.re3.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 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: Wed, 11 Apr 2007 01:15:38 -0000 You can use MySQL or any other relational database to cross-reference/catalog storage locations and information about a large quantity of items/data such as pictures. IMHO, to make such a project worthwhile, you need a database design that serves your needs. If you don't want to design/develop it yourself, you can probably find a free cataloging program or database schema that will work well. You store the actual images in a filesystem, and insert database records that have a field for specifying the path/filename where the image is located and other fields such as date/time photograph was taken, a name and/or description, etc. You will want to have one or more tables for categorizing your images (at least two levels deep) to make it easier to find the one(s) you are looking for. I would provide several ways to cross-reference images (based on one or more criteria). Vittorio wrote: 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" --------------------------------- Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games.