From: Robert Treat <xzilla@users.sourceforge.net>
To: David Costa <geeks@dotgeek.org>, <pgsql-www@postgresql.org>
Subject: Re: [pgsql-advocacy] News Feed: PHP/Postgresql Advocacy
Date: Mon, 16 Feb 2004 22:45:12 -0500
User-Agent: KMail/1.5
Cc: "Marc G.Fournier" <scrappy@postgresql.org>,
	"Dave Page" <dpage@vale-housing.co.uk>
References: 
 <Pine.LNX.4.44.0402141213130.12759-100000@hosting.commandprompt.com>
	<200402161343.12924.josh@agliodbs.com>
	<0645171A-60E0-11D8-B930-000A95EB456A@dotgeek.org>
In-Reply-To: <0645171A-60E0-11D8-B930-000A95EB456A@dotgeek.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200402162245.12552.xzilla@users.sourceforge.net>

Wow, very cool David.  This is something we have talked about having before=
,=20
and we seem so close now I think we need to find a way to make it happen.=
=20
David, I noticed your news feed points to us19 rather than the main server.=
..=20
just curious if there was any reason why?  I am thinking if we could set up=
=20
www.postgresql.org/news.rss we could make that a public news feed that folk=
s=20
could pull from.  It would also be included in the mirror system if someone=
=20
needed to pull a local feed (though it would be slightly delayed).   The on=
ly=20
question I would have is how does this fit in with the web code rewrite /=
=20
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=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
> 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

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