Stack Overflow
Stack Overflow

Questions tagged [sphinx]

Sphinx is a free software search engine for indexing database content. NOTE: For the Python documentation tool, use the [python-sphinx] tag.

Sphinx (SQL Phrase Index) is a standalone full-text search engine that provides efficient search functionality to third-party applications, especially SQL databases. This search engine was developed in 2001 by a Russian developer named Andrew Aksyonoff to guarantee a (1) good search quality, (2) performed at high speed (3) with a low resource consumption (Disk IO, CPU). It can be integrated with scripting languages such as Python and Java.

Sphinx is a free software search engine. It currently supports , , and ODBC-compliant databases as data sources natively. Other data sources can be indexed via a pipe in a custom format. It is distributed under the terms of the GNU General Public License version two or a proprietary license.

Starting from version 0.9.9, querying is possible using SphinxQL, a subset of SQL. Starting from version 1.10-beta, both incremental and batch indexing is supported.

Do not use this tag for the documentation tool written in Python; use for that.

External Resources

2436 questions
449
votes
7 answers

ElasticSearch, Sphinx, Lucene, Solr, Xapian. Which fits for which usage?

I'm currently looking at other search methods rather than having a huge SQL query. I saw elasticsearch recently and played with whoosh (a Python implementation of a search engine). Can you give reasons for your choice(s)?
dzen
  • 6,923
  • 5
  • 28
  • 31
329
votes
9 answers

Comparison of full text search engine - Lucene, Sphinx, Postgresql, MySQL?

I'm building a Django site and I am looking for a search engine. A few candidates: Lucene/Lucene with Compass/Solr Sphinx Postgresql built-in full text search MySQl built-in full text search Selection criteria: result relevance and…
Continuation
  • 12,722
  • 20
  • 82
  • 106
192
votes
5 answers

Choosing a stand-alone full-text search server: Sphinx or SOLR?

I'm looking for a stand-alone full-text search server with the following properties: Must operate as a stand-alone server that can serve search requests from multiple clients Must be able to do "bulk indexing" by indexing the result of an SQL…
knorv
  • 49,059
  • 74
  • 210
  • 294
71
votes
6 answers

Any reason not use PostgreSQL's built-in full text search on Heroku?

I'm preparing to deploy a Rails app on Heroku that requires full text search. Up to now I've been running it on a VPS using MySQL with Sphinx. However, if I want to use Sphinx or Solr on Heroku, I'd need to pay for an add-on. I notice that…
Ethan
  • 57,819
  • 63
  • 187
  • 237
48
votes
9 answers

how to check sphinx version?

I install a sphinx search engine a couple months ago, as time pass, I don't remember that sphinx version I installed. how to check my system sphinx version?
user285020
  • 2,913
  • 4
  • 22
  • 17
45
votes
6 answers

How to evaluate hosted full text search solutions?

What are the options when it comes to SaaS/hosted full text search? How should I evaluate the different options available? I'm looking for something that uses Lucene, solr, or sphinx on the backend, and provides a REST API for submitting documents…
James Cooper
  • 2,320
  • 2
  • 23
  • 23
41
votes
3 answers

Laravel: order by where in

I am using SphinxSearch to query some contents and have the ids of my objects that I want to query with MySQL. The array of my ids are sorted depending on their rank Sphinx gives. Thus, I would like to make a MySQL like so: SELECT * FROM table WHERE…
MPikkle
  • 1,977
  • 3
  • 13
  • 16
31
votes
8 answers

Full Text Searching with Rails

I've been looking into searching plugins/gems for Rails. Most of the articles compare Ferret (Lucene) to Ultrasphinx or possibly Thinking Sphinx, but none that talk about SearchLogic. Does anyone have any clues as to how that one compares? What…
Matt Grande
  • 11,964
  • 6
  • 62
  • 89
29
votes
4 answers

Guide to using Sphinx with PHP and MySQL

I'm looking for a complete guide to using Sphinx with PHP and MySQL. I'd like one that's a bit simpler and easygoing than the one provided on the site. I'm looking for a few concepts on how exactly it all works. I have a server with PHP, HTML,…
Julio
  • 6,182
  • 11
  • 53
  • 65
29
votes
8 answers

Why does configure say no C compiler found when GCC is installed?

I am trying to make Sphinx from source on a 32-bit CentOS 6 VPS. When I run this command: ./configure --prefix=/usr/local/sphinx I get this error output: checking build environment -------------------------- checking for a BSD-compatible…
Garry Pettet
  • 8,096
  • 22
  • 65
  • 103
26
votes
1 answer

using sphinx search with mongodb as datasource

We decided to use mongodb for some web application (instead of mysql) but want to stay with sphinx for indexing/searching all data stored in mongodb. as the mongodb object-id is a hash per default -- and we want to stay with this -- now there's one…
aurora
  • 9,607
  • 7
  • 36
  • 54
26
votes
3 answers

Connect to SphinxQL through Linux command-line

I am trying to connect to SphinxQL server through Linux command-line this way: > mysql -P 9306 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) My Sphinx config file has 2 listen entries: listen =…
snippetsofcode
  • 937
  • 2
  • 10
  • 10
21
votes
4 answers

Best way to deal with misspellings in a MySQL fulltext search

I have about 2000 rows in a mysql database. Each row is a max of 300 characters and contains a sentence or two. I use mysql's built in fulltext search to search these rows. I would like to add a feature so that typos and accidental mispellings are…
Travis
  • 213
  • 1
  • 2
  • 5
19
votes
4 answers

How does a full text search server like Sphinx work?

Can anyone explain in simple words how a full text server like Sphinx works? In plain SQL, one would use SQL queries like this to search for certain keywords in texts: select * from items where name like '%keyword%'; But in the configuration files…
0x4a6f4672
  • 27,297
  • 17
  • 103
  • 140
18
votes
6 answers

Pocketsphinx - Adding words and Improving accuracy

I've managed to finally build and run pocketsphinx (pocketsphinx_continuous). The problem I'm running into, is how to a improve accuracy. From what I understand, you can specify a dictionary file (-dict test.dic). So I took the default dictionary…
Mike6679
  • 5,547
  • 19
  • 63
  • 108
1
2 3
…
99 100