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 <pagong...@gmail.com> > > 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 <emor...@xroff.net> wrote: > >> On Thu, 19 Aug 2010 20:35:50 +0100 >> Miguel Vaz <pagong...@gmail.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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > > -- Filip Rembiałkowski JID,mailto:filip.rembialkow...@gmail.com http://filip.rembialkowski.net/
