Re: On what we want to support: infrastructure?

> 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 something that is kind of being worked on right now. You will be
able to submit a keyword that will return docs based on the keyword.
Versus a fuzzy search.

>
> 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.)

Yes it is using PostgreSQL, but we are moving to 8.2 with PHP +
GIN/Tsearch to do our new search engine.

>
> * 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 would be very, very cool. To automatically generate maps of all the
contributors. You up for the task, we could use a volunteer :) (never
suggest unless you can do ;))

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

This is going away entirely soon.

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

The entire PostgreSQL -WWW project can be downloaded now from gborg.

Sincerely,

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate