News Feed: PHP/Postgresql Advocacy

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ürgen Schönig.

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 
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 broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match