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

sphinxclient.h header is not found on debian

I'm trying to use the C client library of http://sphinxsearch.com in my project. It compiles fine on ubuntu using libsphinxclient-dev package However when I try to compile it on debian sid, it complains that the header sphinxclient.h is missing, and…
allan.simon
  • 3,886
  • 6
  • 35
  • 60
0
votes
1 answer

Why is this query in Sphinx failing?

I am using sphinx and in most normal use queries it returns results as expected. One query however refuses to do so. I am using the following query code: $cl = new SphinxClient(); $cl->SetServer( "localhost", 9312 ); $cl->SetMatchMode(…
William Cross
  • 61
  • 3
0
votes
1 answer

Thinking Sphinx groups/collections of results

I'm trying to do a search with TS in which the results are grouped by an attribute (in the example: category). A structure like this (doesn't have to be arrays): [[id: 1, name: this, category: foo] [id: 2, name: this, category: foo]], [[id:3, name:…
vicocas
  • 249
  • 2
  • 7
0
votes
1 answer

Sphinx search with int primary key

I'm trying add int primary key as a sql_field_string, when I'm rotate index I get message: WARNING: attribute 'purchase_id' not found - IGNORING my config: sp_purchases_source : sp_source_config { sql_query = \ SELECT…
mikhail
  • 482
  • 1
  • 3
  • 14
0
votes
1 answer

How should we implement search on MySQL with composite table?

We have a MySQL database, which has three tables: Objects Composite Tags +-----+-----+ +-----+-----+ +-----+-----+ | ID | Name| |ObjID|TagID| | ID | Name| +-----+-----+ …
John Hamilton
  • 125
  • 1
  • 9
0
votes
1 answer

yii 1 sphinx advanced settings

I use yii 1 and this extension All works fine, but I need some advanced settings. Table good has filed good_code. And in this field data stored like 00-00000361 00000006309 So I need when user type 361 (which relate to the first good) or…
YuriiChmil
  • 441
  • 1
  • 5
  • 18
0
votes
1 answer

sphinx field block operator error

I am creating a very complex Sphinx .cnf file on a very large MySql Table and in order to efficiently test it I have a test config I use on a smaller table. Once I get the behavior I expect/want I copy the new config content over to the working…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

thinking sphinx scope yielding unexpected results from range input

I have an active record scope that I am attempting to duplicate in a sphinx_scope: scope :active, -> (date) { where("DATE(?) BETWEEN active_date AND hide_date-1 ", date) } # between is inclusive This is close enough for government work, unless…
Tim Morton
  • 2,614
  • 1
  • 15
  • 23
0
votes
1 answer

Thinking sphinx without condition on array of id is not working

I am using ruby 1.9.3p392 rails 3.2.21 thinking sphinx 3.1.0 and Sphinx 2.2.4-id64-release user_index.rb file is :- ThinkingSphinx::Index.define :user, :with => :active_record do indexes first_name, :sortable => true indexes last_name indexes…
Shamsul Haque
  • 2,441
  • 2
  • 18
  • 20
0
votes
1 answer

Index website for import to CMS

I need to migrate a website to a new CMS. We do not have access the original site except via http://mysite.com. We currently have a variety of scripts that i). index the site and the ii). create some hierarchy and iii). scrape the unique content…
Simon
  • 5,158
  • 8
  • 43
  • 65
0
votes
1 answer

Using Both Elasticsearch and Sphinx

I have currently sphinx integrated in my website. Now i thought of integrating Elastic Search for some other Search features which i haven't yet built with sphinx. I thought to migrate to Elastic Search. But I do not want to change my previous…
user7339434
  • 95
  • 1
  • 1
  • 4
0
votes
1 answer

Searching $word with Sphinx (Thinking Sphinx)

I would like to search text for words prefiexed by $. Sample records (table with 3 rows): This is my string containing the $word special word. Again $word is here. My special $word must be found. Example RoR (thinking sphinx): MyModel.search…
xpepermint
  • 35,055
  • 30
  • 109
  • 163
0
votes
1 answer

Can we set GEO filters for distance search using Yii2-Sphinx?

I am using Yii2-sphinx extension and everything working fine. Now I am doing distance search using sphinx so i want to set latitude and longitude for a given postcode. How can I set those two filters for my index? As sphinx has an option to set…
Awais Mustafa
  • 151
  • 2
  • 9
0
votes
1 answer

Use wordforms or regexp in Sphinx to force a mutilword term to be a "word"

Is there a way to "force" Sphinx to index a term such as e.g. iphone 5 into a single-term? For various reasons I can't search for it as "iphone 5" or iphone near\1 5 I need to search for it as iphone 5. Naturally the way Sphinx works this means that…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

Yii2 Sphinx Left join not working

I have been trying to use Yii-Sphinx extension and its working fine when i used a simple query but when i try to use left join then it does not work. It returns the below error. I have tested many queries but not working. I am using Yii-Sphinx…
Awais Mustafa
  • 151
  • 2
  • 9
1 2 3
…
99
100