After completing the other recipes in this chapter, this is the recipe where we actually get to see Sphinx doing something.
This recipe requires that we install and configure SphinxSE and the Sphinx daemon. See the previous recipes in this chapter for instructions.
In the previous recipe, we configured the Sphinx daemon to index and search a table called
documents in the
test database. For the purposes of this recipe and to match the previous recipe, we need to create this table with the following
CREATE TABLE command:
CREATE TABLE documents ( id SERIAL PRIMARY KEY, date_added TIMESTAMP, title VARCHAR(256), content TEXT );
We also need to add some example data to the table. The