Message-ID: <48441132.4010709@commandprompt.com>
Date: Mon, 02 Jun 2008 08:26:42 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: Dave Page <dpage@pgadmin.org>
CC: w^3 <pgsql-www@postgresql.org>
Subject: Re: RFC: Product directory
References: <937d27e10806020130l418d1730o84de8773f1f182f5@mail.gmail.com>
In-Reply-To: <937d27e10806020130l418d1730o84de8773f1f182f5@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dave Page wrote:
> I'm looking at replacing the ad-hoc lists of products at
> http://www.postgresql.org/download/ and
> http://www.postgresql.org/download/commercial with a product
> directory. I'd like to keep it fairly simple, and propose the
> following data be stored:
> 
> id serial primary key -- easier in the framework, complaints to /dev/null
> publisher text -- Company/person/project name
> publisher_url text -- Company/person/project URL
> product text -- Product name
> product_url text -- URL for the product
> category int4 -- Category ID (fkey -> categories table)
> description text -- Product description
> price text -- Pricing info (where relevant)
> licence char(1) -- Licence type flag
> 

I would push publisher and publisher_url to their own table. Further we 
may really want to consider that a publisher could be a sponsor. We 
don't want to duplicate all this info.


Sincerely,

Joshua D. Drake