Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3592E2E009F for ; Mon, 2 Jun 2008 12:28:52 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 75884-01 for ; Mon, 2 Jun 2008 12:28:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id D67332E009A for ; Mon, 2 Jun 2008 12:28:47 -0300 (ADT) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m52FU8fN026666 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 2 Jun 2008 08:30:08 -0700 Message-ID: <484411B4.4020801@commandprompt.com> Date: Mon, 02 Jun 2008 08:28:52 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Dave Page CC: David Fetter , w^3 Subject: Re: RFC: Product directory References: <937d27e10806020130l418d1730o84de8773f1f182f5@mail.gmail.com> <20080602113349.GA8921@fetter.org> <937d27e10806020458o68717cd7sb7e0424338ff5d19@mail.gmail.com> In-Reply-To: <937d27e10806020458o68717cd7sb7e0424338ff5d19@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 02 Jun 2008 08:30:09 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/6 X-Sequence-Number: 15233 Dave Page wrote: > On Mon, Jun 2, 2008 at 12:33 PM, David Fetter wrote: > >>> price text -- Pricing info (where relevant) >> Price is too complicated to model, and suffers from "cache coherency" >> issues. Pointing to a web site, where appropriate, would handle this >> better. > > Agreed but a) we already display that data and b) it's useful to give > users a ballpark figure, even if something like "$99.99US as at > 15/12/2007" I have to go with fetter here. Pricing is not our concern. > >> and more than one license. > > Again, not sure I see a need. Either it's commercial, OSS, or freeware > - I don't think there's much scope to have more than one (the obvious > exception is something like "$99.99, or free to educational users" but > I'd just class that as commercial). I don't want to list the actual > OSS licence used as folks can decide whether a product meets with > their personal ethics once they visit it's homepage. > +1 >> The above schema handles these things. Might we want to break >> "publisher" out into a separate table? > > Possibly. Makes the coding & management a little more tricky though. > If we were to do that perhaps it should be part of a larger project to > have a directory of vendors/publishers etc for news, events, services > and products. Yeah I mentioned this in my previous post. Publisher really needs to be pushed out. There is entirely too much redundant information that can be accumulated. Sincerely, Joshua D. Drake