Re: searchable book database

From: Sandeep Srinivasa <sss(at)clearsenses(dot)com>
To: Miguel Vaz <pagongski(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: searchable book database
Date: 2010-08-20 05:11:15
Message-ID: AANLkTimjETavWXQzdYw8JCSADPhO_TFPML4VpsKiYM6p@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If you dont ever need to return the complete book text to a user (which
means, you only need the book text for your search indexes only), then keep
the text on file and use Apache Solr to index it.

regards
Sandeep

On Fri, Aug 20, 2010 at 1:05 AM, Miguel Vaz <pagongski(at)gmail(dot)com> wrote:

>
> Hi,
>
> I need to make a database of books. Several specific subject books that are
> to be searchable.
>
> Is it viable to have the complete book text on a database and search inside
> it? Or should i consider keeping only its metadata (name, author, filename,
> etc) on the DB, keep the book file on the HD and use some sort of
> search algorithm on the file? If you agree on the second option, what would
> you guys suggest for text file searching? Its for a web project, so how
> could i go about doing this? (PHP, python...)
>
> Thanks.
>
> MV
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2010-08-20 06:09:52 Re: searchable book database
Previous Message Greg Smith 2010-08-20 05:09:00 Re: Wiki on pgfoundry