Re: On what we want to support: infrastructure?
От | Joshua D. Drake |
---|---|
Тема | Re: On what we want to support: infrastructure? |
Дата | |
Msg-id | 1163016755.27939.9.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: On what we want to support: infrastructure? (Ron Mayer <rm_pg@cheapcomplexdevices.com>) |
Ответы |
Re: On what we want to support: infrastructure?
|
Список | pgsql-advocacy |
> 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
В списке pgsql-advocacy по дате отправления: