https://connect.hyland.com/t5/nuxeo-forum/how-is-full-text-managed-in-a-default-nuxeo-setup/m-p/327341#M14342 <P>Let's say I have a setup where I use PostgreSQL or Oracle, and store my binary files on the file system and not in the SQL database. How is the full text search managed? Is it using Lucene or a specific library?</P> Thu, 04 Aug 2011 15:39:59 GMT Roland_Benedett 2011-08-04T15:39:59Z https://connect.hyland.com/t5/nuxeo-forum/how-is-full-text-managed-in-a-default-nuxeo-setup/m-p/327341#M14342 <P>Let's say I have a setup where I use PostgreSQL or Oracle, and store my binary files on the file system and not in the SQL database. How is the full text search managed? Is it using Lucene or a specific library?</P> Thu, 04 Aug 2011 15:39:59 GMT https://connect.hyland.com/t5/nuxeo-forum/how-is-full-text-managed-in-a-default-nuxeo-setup/m-p/327341#M14342 Roland_Benedett 2011-08-04T15:39:59Z https://connect.hyland.com/t5/nuxeo-forum/how-is-full-text-managed-in-a-default-nuxeo-setup/m-p/327342#M14343 <P>The Nuxeo repository (VCS) extracts the full text content from the binary files (stored through the Binary Manager) and from the metadata (stored in the SQL database) and indexes this in the database through its native full text indexing capabilities (called <A href="http://www.postgresql.org/docs/9.0/static/textsearch.html">Full Text Search</A> in PostgreSQL or <A href="http://download.oracle.com/docs/cd/B28359_01/text.111/b28303/quicktour.htm">Oracle Text</A> in Oracle, and something else in other databases).</P> <P>So there is no requirement for an external library, and we don't have the classic issues when using a Lucene index: in Nuxeo full text indexing is fully transactional and you can hot-backup it with the database built-in tools.</P> Thu, 04 Aug 2011 16:07:47 GMT https://connect.hyland.com/t5/nuxeo-forum/how-is-full-text-managed-in-a-default-nuxeo-setup/m-p/327342#M14343 Thierry_Delprat 2011-08-04T16:07:47Z