O'Reilly logo

MariaDB Cookbook by Daniel Bartholomew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Searching with the Sphinx daemon and SphinxSE

After completing the other recipes in this chapter, this is the recipe where we actually get to see Sphinx doing something.

Getting ready

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 4399OS_09_documents.sql ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required