You have plenty other FTS options: postgres has built-in FTS (tsearch), and
if you need something more lightweight than Solr, you can use Sphinx.
2010/8/20 Miguel Vaz
>
> Thank you all for your replies. I already had read about Lucene in its
> general flavour and eventually caught up about it
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
On Thu, 19 Aug 2010 20:35:50 +0100
Miguel Vaz 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 (na
...@postgresql.org] On Behalf Of Sandeep Srinivasa
Sent: Thursday, August 19, 2010 10:11 PM
To: Miguel Vaz
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] searchable book database
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
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 wrote:
>
> Hi,
>
> I need to make a d
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 an
