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
9
votes
0 answers

Sphinx error: unknown local index "INDEX_NAME" in search request

Im using Sphinx 0.9.9-release (r2117) and sphinxapi.php (http://code.google.com/p/sphinxsearch/source/browse/tags/REL_0_9_9_RC2/api/sphinxapi.php). When I testing searching in command shell: "search -i INDEX_NAME test" everything is perfect, but…
Adiasz
  • 1,624
  • 1
  • 12
  • 21
8
votes
3 answers

Thinking sphinx doesn't start - "Failed to start searchd daemon"

I try to start thinking sphinx on my server but it doesn't want to work. I do: $ rake thinking_sphinx:index && rake thinking_sphinx:start And i get: Generating Configuration to…
ExiRe
  • 4,727
  • 7
  • 47
  • 92
8
votes
2 answers

Fast, line-wise "grep -n" equivalent for Unix directory structure

I am trying to create a web interface for searching through a large number of huge configuration files (approx 60000 files, each one with a size between 20 KByte to 50 MByte). Those files are also updated frequently (~3…
knipknap
  • 5,934
  • 7
  • 39
  • 43
8
votes
3 answers

Rake task aborted, undefined method 'indexes' for Thinking Sphinx?

I have Sphinx and Thinking Sphinx 2.0.5 installed on my application and when I keep trying to run the command rake ts:index it gives me this error: rake aborted! undefined method `indexes' for # Is is talking about…
LearningRoR
  • 26,582
  • 22
  • 85
  • 150
8
votes
0 answers

Fuzzy Street Address Searches Using MySQL Fulltext (or sphinx?)

I have a database table full of addresses from Google Maps geocode responses. Google abbreviates all directions (West -> W, East -> E, etc). So if I enter an address like "100 West Pender Street" then the formatted address returned by Google Maps is…
emh
  • 1,279
  • 3
  • 15
  • 26
8
votes
3 answers

Among Lucene/Solr, Whoosh, Sphinx, Xapian which integrates best with python?

I am a newb coder in a startup and I am implementing search of documents in a directory in a web host. I am comparing Lucene/Solr, Whoosh, Sphinx and Xapian. Whoosh is natively python. But I want your opinions on it too. Which of these have mature…
Jesvin Jose
  • 22,498
  • 32
  • 109
  • 202
8
votes
5 answers

Any ideas why Thinking Sphinx Rake tasks are not running?

I'm finding that Thinking Sphinx sometimes errors out when I try to run its Rake tasks. Sometimes the tasks work fine, and sometimes I get errors like the one below. I'm running the tasks as a normal user, not root. Not using sudo. In the example…
Ethan
  • 57,819
  • 63
  • 187
  • 237
8
votes
1 answer

Create a filter in Sphinx with text/string value

I have Sphinx Search installed as my search engine and I'm trying to add a few extra features to the search using setFilter() and SetSelect() which should allow me to do WHERE/AND clauses. But whenever I try a search, it returns no results instead…
Roukmoute
  • 681
  • 1
  • 11
  • 26
8
votes
8 answers

How to query Sphinx for an exact matching phrase?

It seems that Sphinx is searching the documents word by word. I don't know how to search the documents for an exact phrase. I tried SPH_MATCH_ALL, SPH_MATCH_PHRASE but all search the documents word by word. I'm using it in my PHP application. How do…
Kevin Lee
  • 1,079
  • 6
  • 17
  • 34
8
votes
5 answers

Does Heroku support Thinking Sphinx?

I would like to know if Heroku supports Sphinx (and its gem Thinking Sphinx)
Ben Orozco
  • 4,361
  • 4
  • 33
  • 49
8
votes
4 answers

SQL - Give me 3 hits for each type only

I have some kind of impossible request :). I have a table where one of the columns is named type. I would like to SELECT 3 records for each type in that column. Is that possible? Note also that I'm using MySQL and Sphinx. UPDATE: Table structure id…
xpepermint
  • 35,055
  • 30
  • 109
  • 163
8
votes
1 answer

How to improve detection of sentences in Sphinx?

It is possible to search words in one sentence with Sphinx. For example, we have next text: Вася молодец, съел огурец, т.к. проголодался. Такие дела. If I search молодец SENTENCE огурец i find this text. If I search молодец SENTENCE…
Nick
  • 9,735
  • 7
  • 59
  • 89
8
votes
1 answer

Solr vs. Sphinx for spatial search

I'm tasked with choosing the fulltext search engine we're going to be using on an upcoming projects. Based on what I've read, I'm leaning toward Solr, but I'm a little concerned about spatial search. In addition to some other parameters (keywords,…
davidtbernal
  • 13,434
  • 9
  • 44
  • 60
8
votes
1 answer

Error when trying to kill processes -- "kill: pid: arguments must be process or job IDs"

I'm trying to kill Sphinx on my server so that I can restart it. I tried using this command to find the PID: ps ax | grep "searchd" Which printed out this: 1483 ? S 00:00 /usr/local/bin/searchd --config /path/to/sphinx.conf 1484 ? …
Nate
  • 26,164
  • 34
  • 130
  • 214
8
votes
1 answer

Sphinx warning preload: failed to open

I installed sphinx search service. For creating indexes I use next command: sudo searchd -c /etc/sphinxsearch/sphinx.conf After get warning message in terminal: using config file '/etc/sphinxsearch/sphinx.conf'... listening on 127.0.0.1:3322…
user3573738
1 2
3
…
99 100