X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9CD45D1BB5E for ; Tue, 17 Feb 2004 09:40:58 +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 76806-03 for ; Tue, 17 Feb 2004 05:40:59 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 208F9D1B511 for ; Tue, 17 Feb 2004 05:40:56 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id E4B761D7868 for ; Tue, 17 Feb 2004 10:40:57 +0100 (CET) Mime-Version: 1.0 (Apple Message framework v609) In-Reply-To: <200402162245.12552.xzilla@users.sourceforge.net> References: <200402161343.12924.josh@agliodbs.com> <0645171A-60E0-11D8-B930-000A95EB456A@dotgeek.org> <200402162245.12552.xzilla@users.sourceforge.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <6364EB85-612D-11D8-8347-000A95EB456A@dotgeek.org> Content-Transfer-Encoding: quoted-printable From: David Costa Subject: Re: News Feed: PHP/Postgresql Advocacy Date: Tue, 17 Feb 2004 10:40:57 +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/155 X-Sequence-Number: 3726 On Feb 17, 2004, at 4:45 AM, Robert Treat wrote: > Wow, very cool David. Thank you! I am far from an XML expert but with so many friends on the=20 php pear development team it was just a 7 hours job :D > This is something we have talked about having before, > and we seem so close now I think we need to find a way to make it=20 > happen. > David, I noticed your news feed points to us19 rather than the main=20 > server... > just curious if there was any reason why? Egoism ;) ?? Kidding of course. I am not sure how this might effect the load on the main=20 www.postgresql.org for one. if someone adds the rss feed to his site, he might hit the server=20 every hour or every 30 minutes. Many news aggregators, which are now=20 default in a number of CMS like Postnuke, Drupal, Phpnuke, Slashcode do that=20 and you need to be careful if you have some limits on the server traffic. The second reason is because this is not something official and I=20 didn't want to bother anyone. > I am thinking if we could set up > www.postgresql.org/news.rss we could make that a public news feed that=20 > folks > could pull from. Sure, I am ready anytime but I would like to further explain: I am=20 currently parsing the news from our mirror, adding the news on the=20 database and then I manipulate the news for the feed. This is not the normal way=20 to do it. Assuming that the news are already in a database, one of my=20 scripts might not be required on the official site. Secondly, I think we need to provide a number of feeds aka news and a=20 feed for each of the main mailing lists. > It would also be included in the mirror system if someone > needed to pull a local feed (though it would be slightly delayed).=20=20= =20 > The only > question I would have is how does this fit in with the web code=20 > rewrite / > translation stuff? I am not sure. For the time being you can use our "alpha" feed url.=20 Talking about advocacy, I think that the feeds are a great tool. The second easy to implement feature is the ip to country. This will=20 display, on the download page, something like this " We detected that=20 you are from $country" example http://www.php.net/my.php Advantage? this will enhance the overall browsing and download=20 experience. Visitors in Austria will hit the local mirror with a better=20 performance and less load on the main box. Eventually I am not suggesting a quick adoption of these tools. I will=20 keep working on these features and if there is an interest for official=20 adoption, I am here to help as always. All the best, David Costa > Robert Treat > > On Monday 16 February 2004 19:27, David Costa wrote: >> Hello Everyone :) >> >> It was a long day but I managed to finalise a newsfeed from the >> 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 >> are a tremendous tool. O'Reilly on lamp is using this extensively >> http://www.onlamp.com/ to aggregate news from several sources. They >> would certainly add some news from postgresql and I am sure that many >> 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 >> postgresql.org news anytime using our raw feed at >> http://www.dotgeek.org/pgnews/news.rss >> >> The news are first parsed, then stored on a postgresql database in our >> server. For the feed I used PHP, Pear XML_Serializer, and a custom RSS >> parser. >> >> On the next few days we will move on as planned adding a column at >> 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=20 >> an >> official adoption, all yours, not urgent thou. >> >> 1:25 AM here, time to go home. I will keep you posted on my Advocacy >> initiatives, hope you don't mind ;) >> >> All the best, >> Regards >> David Costa >> >> >> >> >> ---------------------------(end of=20 >> broadcast)--------------------------- >> TIP 9: the planner will ignore your desire to choose an index scan if=20 >> your >> joining column's datatypes do not match > > --=20 > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL