X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7BE53D1D29D; Tue, 17 Feb 2004 00:27:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48668-07; Mon, 16 Feb 2004 20:27:27 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 04F71D1C93E; Mon, 16 Feb 2004 20:27:24 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id F012C1D752C; Tue, 17 Feb 2004 01:27:10 +0100 (CET) In-Reply-To: <200402161343.12924.josh@agliodbs.com> References: <2D9A949E-5F35-11D8-B468-000A95EB456A@dotgeek.org> <402F1FA7.5060407@cs.msu.su> <200402161343.12924.josh@agliodbs.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <0645171A-60E0-11D8-B930-000A95EB456A@dotgeek.org> Content-Transfer-Encoding: quoted-printable Cc: Alexey Borzov , Joshua D.Drake , Marc G.Fournier , josh@agliodbs.com From: David Costa Subject: News Feed: PHP/Postgresql Advocacy Date: Tue, 17 Feb 2004 01:27:10 +0100 To: pgsql-advocacy@postgresql.org, X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/99 X-Sequence-Number: 3664 Hello Everyone :) It was a long day but I managed to finalise a newsfeed from the=20 postgresql.org website. You can see it at http://www.dotgeek.org/ on the right column As you might now, XML Feeds, made available under the rdf/rss format=20 are a tremendous tool. O'Reilly on lamp is using this extensively=20 http://www.onlamp.com/ to aggregate news from several sources. They=20 would certainly add some news from postgresql and I am sure that many=20 of the postgresql users will be more than glad to add the news in their website. Basically everyone with a website and an rss parser can add the=20 postgresql.org news anytime using our raw feed at=20 http://www.dotgeek.org/pgnews/news.rss The news are first parsed, then stored on a postgresql database in our=20 server. For the feed I used PHP, Pear XML_Serializer, and a custom RSS=20 parser. On the next few days we will move on as planned adding a column at=20 dotgeek entirely dedicated to PHP&PostgreSQL development. The first articles will be written by me and Hans-J=FCrgen Sch=F6nig. The next ideal step could be XML feeds for the mailing lists. Oh.. of course if Marc or Dave would like to see/try the sources for an=20 official adoption, all yours, not urgent thou. 1:25 AM here, time to go home. I will keep you posted on my Advocacy=20 initiatives, hope you don't mind ;) All the best, Regards David Costa