Re: searchable book database

From: Miguel Vaz <pagongski(at)gmail(dot)com>
To: Eduardo <emorras(at)xroff(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: searchable book database
Date: 2010-08-20 17:55:47
Message-ID: AANLkTimWf=8kRJ-XcpfBc76pqatv7WC-eYcR=_Yp61Yy@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you all for your replies. I already had read about Lucene in its
general flavour and eventually caught up about it being used with zend
framework, but it seems theres a lot more out there.

Will plan the second option. Have the books as files and build some
search/index/hash/super-power-ninja engine to do all the hard work behind
the scenes and only deliver the pretty bits to the users.

This wont be merely a search and find project, as it will have the search,
find, analyse/treat results, etc. and then display analysis.

Apache Solr..nice one, seems very interesting. Has an API also, that maybe
will allow me to plug to the Flex side of the interface.

Again, than you all for the great information.

MV

On Fri, Aug 20, 2010 at 12:09 PM, Eduardo <emorras(at)xroff(dot)net> wrote:

> On Thu, 19 Aug 2010 20:35:50 +0100
> 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
>
> Don't knopw if that's what you need but you can setup a DocManager
> site. Check it at
> http://wiki.docmgr.org/index.php/DocMGR_-_Document_Management and see
> if it fills your needs.
>
> HTH
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wang, Mary Y 2010-08-20 21:10:37 Could not Store French Accent Marks Correctly in Postgres
Previous Message Sam Nelson 2010-08-20 15:12:52 Re: Warm Standby Weirdness