Announce: Search PostgreSQL related resources

Started by Oleg Bartunovover 22 years ago11 messageshackersgeneral
Jump to latest
#1Oleg Bartunov
oleg@sai.msu.su
hackersgeneral

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable archive of
mailing lists (a'la fts.postgresql.org), russian documentation and
WIKI for online documentation, tips, etc.

We are welcome your feedback and comments. We need design solution, icons.

This project is hosted at
Sternberg Astronomical Institute, Moscow University and supported
by Russian Foundation for Basic Research and Delta-Soft LLC.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#2Dave Cramer
pg@fastcrypt.com
In reply to: Oleg Bartunov (#1)
hackersgeneral
Re: [HACKERS] Announce: Search PostgreSQL related resources

connection failed :(

Dave
On Mon, 2004-01-05 at 09:49, Oleg Bartunov wrote:

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable archive of
mailing lists (a'la fts.postgresql.org), russian documentation and
WIKI for online documentation, tips, etc.

We are welcome your feedback and comments. We need design solution, icons.

This project is hosted at
Sternberg Astronomical Institute, Moscow University and supported
by Russian Foundation for Basic Research and Delta-Soft LLC.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Dave Cramer
519 939 0336
ICQ # 1467551

#3Glenn Wiorek
gwiorek@jmlafferty.com
In reply to: Oleg Bartunov (#1)
hackersgeneral
Re: [HACKERS] Announce: Search PostgreSQL related resources

connection failed :(

Dave

I had no problem accessing it - very nice and responsive ! Great job Oleg
and Teodor.

-- Glenn

----- Original Message -----
From: "Dave Cramer" <pg@fastcrypt.com>
To: "Oleg Bartunov" <oleg@sai.msu.su>
Cc: <pgsql-general@postgresql.org>; "Pgsql Hackers"
<pgsql-hackers@postgresql.org>
Sent: Monday, January 05, 2004 9:51 AM
Subject: Re: [HACKERS] Announce: Search PostgreSQL related resources

connection failed :(

Dave
On Mon, 2004-01-05 at 09:49, Oleg Bartunov wrote:

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search

system on

postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian,

english)

but more languages could be added. We plan to add searchable archive of
mailing lists (a'la fts.postgresql.org), russian documentation and
WIKI for online documentation, tips, etc.

We are welcome your feedback and comments. We need design solution,

icons.

Show quoted text

This project is hosted at
Sternberg Astronomical Institute, Moscow University and supported
by Russian Foundation for Basic Research and Delta-Soft LLC.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Dave Cramer
519 939 0336
ICQ # 1467551

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#4Marek Lewczuk
newsy@lewczuk.com
In reply to: Dave Cramer (#2)
hackersgeneral
Re: [HACKERS] Announce: Search PostgreSQL related resources

Dave Cramer wrote:

connection failed :(

works for me... :-) (poland)

#5Oleg Bartunov
oleg@sai.msu.su
In reply to: Marek Lewczuk (#4)
hackersgeneral
Re: [HACKERS] Announce: Search PostgreSQL related resources

On Mon, 5 Jan 2004, Marek Lewczuk wrote:

Dave Cramer wrote:

connection failed :(

works for me... :-) (poland)

We have small downtime because of upgrading server software, so this may
be a reason for the problem. We're in stage of optimizing crawler because
some sites are very-very ugly, for example, our crawler have discovered
2 millions URLs on http://ems-hitech.com/pgmanager/ ! 99.99 % of URLs are
just 404 (document not found), but server does return 200 code )\:)
So we have to explicitly exclude these pages. btw, archives.postgresql.org
doesn't returns modification date in header. This prevent crawler to
optimize downloading process. So, there are many problems, but we hope
soon we'll tune crawling process. I estimate average time to refresh index
about 1 week.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#6Oliver Elphick
olly@lfix.co.uk
In reply to: Oleg Bartunov (#1)
hackersgeneral
Re: Announce: Search PostgreSQL related resources

On Mon, 2004-01-05 at 14:49, Oleg Bartunov wrote:

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable archive of
mailing lists (a'la fts.postgresql.org), russian documentation and
WIKI for online documentation, tips, etc.

We are welcome your feedback and comments. We need design solution, icons.

Could I suggest a filter to limit results in foreign languages. For
example, I am unable to benefit from pages written in Russian; I would
like to exclude them from the search, but I see no means of doing that.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And thou shalt love the LORD thy God with all thine
heart, and with all thy soul, and with all thy might."
Deuteronomy 6:5

#7Rajesh Kumar Mallah
mallah@trade-india.com
In reply to: Oleg Bartunov (#1)
hackersgeneral
Re: Announce: Search PostgreSQL related resources

Hi,

Could you please tell how the "did you mean " feature
was implemented when the serach term has a typo.

The search engine is good .

Regds
mallah.

Oleg Bartunov wrote:

Show quoted text

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable archive of
mailing lists (a'la fts.postgresql.org), russian documentation and
WIKI for online documentation, tips, etc.

We are welcome your feedback and comments. We need design solution, icons.

This project is hosted at
Sternberg Astronomical Institute, Moscow University and supported
by Russian Foundation for Basic Research and Delta-Soft LLC.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

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

#8Chris Mair
list@1006.org
In reply to: Oleg Bartunov (#1)
hackersgeneral
Re: [HACKERS] Announce: Search PostgreSQL related resources

http://www.pgsql.ru/
We are welcome your feedback and comments.

Very nice work!
I've just found docs I was looking for a long time :)

Bye, Chris.

#9Chris Mair
list@1006.org
In reply to: Oleg Bartunov (#1)
hackersgeneral
Re: Announce: Search PostgreSQL related resources

http://www.pgsql.ru/
We are welcome your feedback and comments.

Very nice work!
I've just found some docs I was looking for a long time :)

Bye, Chris.

#10Oleg Bartunov
oleg@sai.msu.su
In reply to: Rajesh Kumar Mallah (#7)
hackersgeneral
Re: [HACKERS] Announce: Search PostgreSQL related resources

On Tue, 6 Jan 2004, Rajesh Kumar Mallah wrote:

Hi,

Could you please tell how the "did you mean " feature
was implemented when the serach term has a typo.

it's based on trigrams similarity and words statistics.

The search engine is good .

Regds
mallah.

Oleg Bartunov wrote:

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable archive of
mailing lists (a'la fts.postgresql.org), russian documentation and
WIKI for online documentation, tips, etc.

We are welcome your feedback and comments. We need design solution, icons.

This project is hosted at
Sternberg Astronomical Institute, Moscow University and supported
by Russian Foundation for Basic Research and Delta-Soft LLC.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#11Richard Huxton
dev@archonet.com
In reply to: Oliver Elphick (#6)
hackersgeneral
Re: Announce: Search PostgreSQL related resources

On Monday 05 January 2004 19:05, Oliver Elphick wrote:

On Mon, 2004-01-05 at 14:49, Oleg Bartunov wrote:

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search

Just had reason to use it in anger.Seems to work very well indeed. Nice and
smooth. Good work, Oleg & Teodor (?)

--
Richard Huxton
Archonet Ltd