Re: On what we want to support: infrastructure?

> > To refresh, here's the list of everything we might want to
> spend money on:
> >
> > 1. PostgreSQL.org infrastructure (servers, bandwidth,
> sysadmins, SSL, etc.)
> > (unlikely to need money, but if it does, the highest priority)
>
> There's one area regarding postgresql.org infrastructure that
> I think we could enhance that would benefit the community
> pretty greatly.
>
> Could the PostgreSQL infrastructure itself serve as an
> example of best practices and/or interesting use of
> PostgreSQL --- and have the source for the apps poswering
> postgresql.org be available on pgfoundry/gborg?
>
> I can think of a couple examples:
>
> * Is search on the postgresql web site or docs or mailing list
> archives powered by tsearch2 or some sgml indexing feature
> or some other postgresql cool feature I don't know about?
> Could it be? Could we see how it's done? I think the docs would
> be especially interesting if it indexes the sgml; and I think
> the mailing list archives are a pretty nice example of a fairly
> large scale search database.

This is being worked on right now.

> I've been asked why PostgreSQL.org's search apparently uses
> ASPSeek and ASPSeek's docs claim the supported database are
> "it can be mysql or oracle8 for now." (Though I've been told
> in postgresql.org's case it's actually backed by PG, that's
> not obvious anywhere.)

We have a special version of ASPSeek that works with Pg. Unfortunatly
the upstream maintainers didn't want our patches, if I understodd the
situation right. One of the reasons we are migrating off it.

> * I seem to recall a developer map somewhere. Was it generated
> by PostGIS? If not, note that pretty impressive maps can
> be generated from PostgreSQL/PostGIS like the links below [1,2,3]
> All of these are dynamically generated (change the mapxy or
> scale parameters if you don't believe me) from a 90GB postgresql
> database of individual road segments; and it works pretty well
> and IMHO would make a pretty nice demo and example of how to
> use that feature?

That could be a nice demo, yes.

> * Is the postgresql.org adserver powered by postgresql? That
> too would be interesting to many small site webmasters if
> the source were available.

I don't know. It would IMHO be much better to get rid of the ads and use
whatever little funding needed to replace that.

> * Is postgresql.org itself a database-backed web site? How
> about showing the source for that on pgfoundry as an
> example web site?

It is, but it uses a reasonably advanced static mirroring system. The
source is on gborg, project "pgweb".

//Magnus