Did you know that Sphinx and Manticore Search configs allow you to do scripting by using shebang syntax? Here is an example of how useful it can be in some cases:
Imagine you have 3 tables with identical structure that you would like to index into 3 indexes one per table. You can just make a php script which will do it and use it as a Manticore Search config instead of describing each source/index separately:
Just want to share an interesting trick on how to easily index something with Sphinx / Manticore Search for test purposes without need of populating database with a lot of data or doing smth like that. The below is a full Sphinx / Mantocore Search config which lets you build a 1M docs index consisting of random 3-char words and geo coordinates, an example of command to build the index and an exampe of a sphinxql query which does search in the index. All you need is just any connection to any db (in this case ‘mysql -u root’ works).
If you want to start learning Manticore Search plain indexes or see how some its feature works the following simplest Manticoresearch configuration might be useful: It contains almost nothing, but only the things Manticoresearch cannot work without. Those are: Section “source” to fetch data from mysql. In this case we don’t even fetch real data from Read more about Minimal configuration to play with Manticore Search[…]