SphinxRT (Real Time Indexes) for CodeIgniter 2+

This library allows you to communicate with Sphinx via it's SphinxQL (SQL-esque) method of inserting, updating, deleting and searching. This library only works with with Real Time indexes but you technically could use it to search a normal Sphinx Index. This library makes use of the SphinxQL language over the SpinxAPI (this method has been proven that in-scale, the SphinxQL system works more efficiently and can handle more requests per second).

Currently Supported

There are several elements currently supported but to this is only to a basic level, more error-proofing and complex queries need to be added.

Requirements

• PHP 5.2+
• MySQLi Driver (Improved)
• Sphinx 2.0.1BETA+ (YOU MUST CONFIGURE SPHINX FIRST)

TODO

• Ability to Weight Columns
• Truncate/Clear whole index
• Search Across multiple indexes at once
• Ability to "group by"
• Ability to change ranking algorithm
• Pull back server statistics
• Delete items

Usage Example

Example of using insert:

    $this->sphinxrt->insert('example', array('a_id' => 5,
                                             'name' => 'Example'));

Example of using search:

    $result = $this->sphinxrt->search('example', array('search'     => 'my query',
                                                       'limit'      => 100,
                                                       'start'      => 0,
                                                       'where'      => array('is_active,=' => 1)));

Example of using update:

    $this->sphinxrt->update('example', array('a_id' => 5,
                                             'name' => 'Example'));

Notes

• You CAN'T use a column called "id", it's just not allowed
• Queries can't end with a ";" as it's not allowed - this isn't a database