From: | fabrizio(dot)ermini(at)sysdat(dot)it |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Request for thoughts... |
Date: | 2001-02-23 17:51:19 |
Message-ID: | 3A96B127.6977.CB6B9F@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm thinking of starting a little project of mine, that would have, as
core functionality, the capability of doing general substring search
(thru regexp) on a large number of records (say hundreds of
thousands), using a free-text field as key.
I know that this is not exactly what SQL DB are built for. However, I
would like to use PG as the "container" of this data, possibly
coupling it with a web interface (PHP).
There's anybody that would like to share some thought/discussion
about what tecniques could be used to realize this in the most
efficient way?
Some other specification:
*Researches should be made on 1 or 2 fields, containing generic
text
*The clause of the search should be a generic regexp (I'm not
talking of a free text search)
Thank you in advance for any hint, and my best regards to all...
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Fabrizio Ermini Alternate E-mail:
C.so Umberto, 7 faermini(at)tin(dot)it
loc. Meleto Valdarno Mail on GSM: (keep it short!)
52020 Cavriglia (AR) faermini(at)sms(dot)tin(dot)it
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-23 18:04:46 | Re: Date difference in seconds |
Previous Message | Ewald Geschwinde | 2001-02-23 17:51:06 | timestamp in logfile |