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
0
votes
1 answer

Set Sphinx relevance ranking for RT index

How do I include a ranking type (such as SPH_RANK_NONE) in a Sphinx RT query? select id from my_index where match('hello') order by date limit 600 ; Also, is there a way to just set it once, for example, in the config file? Sphinx…
user984003
  • 28,050
  • 64
  • 189
  • 285
0
votes
0 answers

Stopword "_" in sphinx

I have records that come in as LastName_FirstName e.g. Smith_Bob so am unable to search for Smith or Bob independently. I tried add ing _ to my stopwords.txt file and re-rotating to no avail. Is there another way to force _ to be ignored?
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Sphinx Partial Word Searching with Underscored Titles.

Currently trying to use Sphinx to search through medicine names, and because of the way the US structure medical names its all medicine_type in the database, and there's no way of changing that going forward. If for instance I search medicine_type…
Jonah Hart
  • 35
  • 5
0
votes
1 answer

Converting MySQL to a Sphinx Search Platform

Currently working on an in-house search engine for over 12 GB / month of MySQL data. We currently have two tables, practice prescribing, and practice information. Both tables contain a column, practice number which identifies the practice…
Jonah Hart
  • 35
  • 5
0
votes
1 answer

Sort thinking sphinx by attribute AND @random?

So I'd like to be able to sort first by an attribute, and then amongst those with the same attribute value, sort randomly. As in: { :sort_mode => :extended, :order => "attribute DESC, @random ASC" } In my case the attribute is boolean, so I just…
Steven Ou
  • 393
  • 2
  • 13
0
votes
0 answers

Deploying Sphinx in Production

Once I have rotated my index, do I need to keep my original sphinx.cfg file on my production server? In other words is it used at all during sphinxql queries? Can I for security purposes (proprietary data) remove that file until I am ready to rotate…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Sphinx search query - condition for numbers in varchar column

I have items and list in which categories exists: id | name | categories(varchar) 1 | bike red | 2,5,18 2 | bike black | 4,7,13 With Sphinx I need to serach for example: bike AND only from category 5 Is any good way how search in column…
Poul D.
  • 59
  • 7
0
votes
0 answers

Sphinx Wildcard issue with periods

I have a query I use with wildcard for a field I call 'Nth' (#.#.#.#) Where MATCH('@(nth) (^"1.1.1*")') this works for #.#.#.* but fails (empty set) for #.#.* To my understanding it should work just the same way like does in Mysql. In other words…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

sphinxsearch postgres sphinx_select disable match section

I use sphinx for postgres and run this query SELECT id,weight FROM sphinx_select('sessionsearchsphinxidx','someword','', '', 0,50000,'ranker=wordcount') I want to use this method in case when no search query is defined. So in other words I want…
avalon
  • 2,231
  • 3
  • 24
  • 49
0
votes
1 answer

postgres sphinx search order

I have a postgres install with Sphinx and when I run query I want that most relevant records to be selected first. In other words, I want the following query first: query="word1 & word2 & word3" and then, if nothing selected, query="word1 | word2 |…
avalon
  • 2,231
  • 3
  • 24
  • 49
0
votes
2 answers

Good way to exclude records in SOLR or Elasticsearch

For a matchmaking portal, we have one requirement where in, if a customer viewed complete profile details of a bride or groom then we have to exclude that profile from further search results. Currently, along with other detail we are storing the…
Mohandoss
  • 35
  • 7
0
votes
1 answer

sphinxsearch merge indexes on different column names

If i have indexA which returns id, doc_id, attrA1, attrA2 and indexB with id, group_id, attrB1, attrB2, then is it possible to merge indexer --merge indexA indexB, so that the merged index will return id, doc_id, attrA1, attrA2, attrB1, attrB2?…
Novitoll
  • 820
  • 1
  • 9
  • 22
0
votes
1 answer

How do you install the old version of a Homebrew formula that doesn't exist in the current system?

I did my due diligence, and found that everything except the following was deprecated: brew install sphinx@1.4.13 Error: No available formula with the name "sphinx@1.4.13" ==> Searching for a previously deleted formula... Error: No previously…
Roderick
  • 2,383
  • 3
  • 20
  • 33
0
votes
2 answers

Sphinx exact match to column string

I thought that Match('^Word$') Would only find records that are exactly 'Word' However although this does work for single words it does not for mutliple: Match ('^Final Word$') Finds 'Final Word' and 'Final and Last Word'. as does Match ('^"Final…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

Query failed: connection to localhost:3306 failed in sphinx

I'm trying to use the sphinx api to grab some data from a mysql db, but I keep getting this error when I load it on my browser. Query failed: connection to localhost:3306 failed (errno=4, msg=). I had no luck when I tried changing the port…
steve
  • 3,878
  • 7
  • 34
  • 49
1 2 3
…
99 100