How to create an index in Sphinx from a MySQL column?

Question

In Thinking Sphinx, the Ruby plugin, I can create a sphinx index from a db column. How can I do this without Thinking Sphinx, with the indexer function, or in Python?

EDIT: The column in question would be text.

Answer 1

If you using Thinking Sphinx look at generated indexer configuration (by default is /config/ENVIRONMENT.sphinx.conf), You can write this configuration with Python,

Use documentation or tutorial for Django.

Here I found some python API provided by Sphinx Technologies: http://code.google.com/p/sphinxsearch/source/browse/trunk/api/sphinxapi.py