Archive | Sphinx RSS feed for this section

[How To] Live index updates in Sphinx search

TweetSphinx search engine can index huge databases with ease and speed. However, when new data (in database or the configured data source) comes in, there is no point in re-indexing everything again and waste our CPU cycles and other resources. Sphinx offers live (almost real time) index updates using a technique called as main+delta scheme. [...]

Read full story · Comments { 7 }

SQL data source in Sphinx

TweetThese days I am getting more and more into Sphinx and falling in love with it . In this post we will see how to make use of SQL data source to create indexes. Sphinx has inbuilt support for MySQL and PostgreSQL databases. The drivers for these databases can connect to the database using its [...]

Read full story · Comments { 1 }

Sphinx search engine and PHP (Part 2 – Searching from PHP)

TweetIn earlier post we saw how to install and configure sphinx. We also created an index for sphinx to search from. Now let us see how to search the index from a php script. Sphinx comes with a PHP implementation of searchd client API. You can find it at api/sphinxapi.php in the root of the [...]

Read full story · Comments { 10 }

Sphinx search engine and PHP (Part 1 – Installation and Indexing)

TweetIn the two part series we will see how to install sphinx, prepare the index and then search the index from our php scripts. Shpinx is a free open source SQL full-text search engine and for those who might confuse it with the Great Sphinx of Giza,  Sphinx is the acronym for SQL Phrase Index. [...]

Read full story · Comments { 17 }