Re: [pgsql-advocacy] News Feed: PHP/Postgresql Advocacy

Wow, very cool David. 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 happen.
David, I noticed your news feed points to us19 rather than the main server...
just curious if there was any reason why? I am thinking if we could set up
www.postgresql.org/news.rss we could make that a public news feed that folks
could pull from. It would also be included in the mirror system if someone
needed to pull a local feed (though it would be slightly delayed). The only
question I would have is how does this fit in with the web code rewrite /
translation stuff?

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ü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

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL