X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1AEC49DD6C6 for ; Sat, 3 Dec 2005 04:21:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98929-09 for ; Sat, 3 Dec 2005 04:21:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from anchor-post-36.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by postgresql.org (Postfix) with ESMTP id A43899DD5F3 for ; Sat, 3 Dec 2005 04:21:24 -0400 (AST) Received: from mailgate.vale-housing.co.uk ([194.217.48.34] helo=vale-housing.co.uk) by anchor-post-36.mail.demon.net with esmtp (Exim 4.42) id 1EiSe5-000OH3-Jk for pgsql-www@postgresql.org; Sat, 03 Dec 2005 08:21:25 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: Integration Requirements WAS: Launching PostgreSQL KB Project Mark 2 Date: Sat, 3 Dec 2005 08:21:25 -0000 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Integration Requirements WAS: Launching PostgreSQL KB Project Mark 2 Thread-Index: AcX3l4fJAey/njhiT1G4fPEZEQchRAASjoZV From: "Dave Page" To: , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.516 required=5 tests=[AWL=0.516] X-Spam-Score: 0.516 X-Spam-Level: X-Archive-Number: 200512/52 X-Sequence-Number: 8993 Well, just to start throwing ideas around; - Moving data; originally we'd looked at exporting from the cms into the = filesystem, and having script that did a cvs add/remove/commit over the = entire tree, into the main web CVS. This is still preferrable from an = 'ease of rebuilding' point of view, but might be easier just to rsync = the content from the filesystem of the cms machine to wwwmaster. - Data format; pages should probably be in our standard template-style = XML.=20 - Navigation; Gevik was working on a tree-style thingy in PHP. Perhaps = the CMS could export an XML file describing the navigation tree, which = the PHP handler on the main website could use to generate it's treeview = in dynamic mode. By accepting some sort of pointer to the currently = selected node as a GET value, we should be able to make the tree fully = mirrorable. Thoughts? /D -----Original Message----- From: pgsql-www-owner@postgresql.org on behalf of Josh Berkus Sent: Fri 12/2/2005 11:28 PM To: pgsql-www@postgresql.org Subject: Re: [pgsql-www] Integration Requirements WAS: Launching = PostgreSQL KB Project Mark 2 =20 Folks, While we discuss on the *other list* the business requirements for a=20 Postgres KB, it would be really helpful to get together on *this* list a = document giving the requirements for projects to be incorporated into = the=20 PostgreSQL.org web infrastructure. Such a document would be very = helpful,=20 as well, to others wanting to add things to the web site. --=20 --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend