How is full text managed in a default Nuxeo setup?
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?
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 Full Text Search in PostgreSQL or Oracle Text in Oracle, and something else in other databases).
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.