From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | w^3 <pgsql-www(at)postgresql(dot)org> |
Subject: | Re: RFC: Product directory |
Date: | 2008-06-02 15:26:42 |
Message-ID: | 48441132.4010709@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2008-06-02 15:28:52 | Re: RFC: Product directory |
Previous Message | Marc G. Fournier | 2008-06-02 12:19:01 | Re: RFC: Product directory |