I am currently looking into options of using a search engine for our project. I am using SS 3 and I need support for full text search, document indexing (PDF, DOC) and geospatial search.
Seems like there are a number of modules out there that support lucene, sphinx, solr and elasticsearch. If I understand right, then the FulltextSearch module aims to replace the former solr and sphinx modules. Can you give me an update of the current status and if I should use the FulltextSearch module or the older sphinx/solr modules? Does the module only support full text search or also geospatial search and search in documents (as Solr/spinx do)?
FTS module was aimed to replace it. But with SS3 and a lot of time-shortage, I have not updated this module.
Compared to Lucene-like modules, this is not the module you want anymore. I would advice to have a look at this module: https://github.com/wecodenl/silverstripe-lucene
It's fully SS3 compatible and is way faster than the FTS module I made.
In summary, this module is deprecated for SS3+ (until I feel like upgrading it)
However, we need advanced search capabilities for also Word and PDF documents' contents and even spatial searches. I was going to implement a module that uses SphinxSearch because I'm most familiar with SphinxSearch and it seems very fast and optimised for searching relational databases and even spatial things. We need to search a PostgreSQL/PostGIS database and not MySQL so the standard search function doesn't seem advanced enough.
How would I go about this? I was looking at extending DataExtension like the FulltextSearchable class does and then writing my own Controller class as well. Seems like it is doable. Any gotchas you can point out would be much appreciated.