You’ve set up Sphinx Search and everything seems to be running smooth. Now you have to put it to work. This is where the API comes into play! All the API does is it lets you communicate with the indexes you’ve created. Various programming languages are supported like: JAVA, Python, PHP and Ruby. (NOTE: The [...]
I’ve split the setting up of Sphinx Search in two parts. Please read Setting up Sphinx Search (Part 1) first. Lets look at a “real world” example setup: #The settings and SQL source for your index source blogposts { type = mysql sql_host = localhost sql_user = dbuser sql_pass = secret sql_db = dbname sql_port [...]
So far, I’ve introduced Sphinx search and told you how to install Sphinx search. The next step would be to get it running. This is almost as simple as installing it, but a little bit more work. This is only a very basic configuration setup. I might at a later stage introduce you to some [...]
Now that you have been introduced to Sphinx Search, its time to set it up or install it. It is extremely simple. Just have a look at the guide for Debian, to give you an idea: sudo apt-get update sudo apt-get dist-upgrade sudo apt-get install build-essential sudo apt-get install libmysqlclient15-dev tar xvzf sphinx-0.9.8-rc2.tar.gz cd sphinx-0.9.8-rc2/ [...]
Full text search is usually not a nicety, but often a necessity. To search a database text field by simply doing a normal SQL query could often result in a slow query, which is NOT GOOD. Now, you might not always have a need for full text search, specially if you have a smallish data [...]