Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 11B292E004E for ; Mon, 2 Jun 2008 05:31:07 -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 10215-06 for ; Mon, 2 Jun 2008 05:30:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by developer.postgresql.org (Postfix) with ESMTP id 7AA402E003B for ; Mon, 2 Jun 2008 05:30:59 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so387465ywj.73 for ; Mon, 02 Jun 2008 01:30:58 -0700 (PDT) Received: by 10.150.68.2 with SMTP id q2mr3866580yba.86.1212395458831; Mon, 02 Jun 2008 01:30:58 -0700 (PDT) Received: by 10.150.144.11 with HTTP; Mon, 2 Jun 2008 01:30:58 -0700 (PDT) Message-ID: <937d27e10806020130l418d1730o84de8773f1f182f5@mail.gmail.com> Date: Mon, 2 Jun 2008 09:30:58 +0100 From: "Dave Page" To: w^3 Subject: RFC: Product directory MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/1 X-Sequence-Number: 15228 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 The categories table would simply be a lookup table of category names: Administration/development tools Programming interfaces Clustering/replication Procedural languages Reporting tools PostgreSQL extensions Applications ?? The licence type codes will be hardcoded: 'o' - Open Source 'c' - Commercial 'f' - Freeware Sound reasonable? Anything I've missed? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com