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

Send array of checkboxes to GET form in Laravel

I need to implement multiple choice and it is something like this:
0
votes
1 answer

ThinkingSphinx indexing ActsAsTaggable Model.tag_counts

In order to assign tags, users of my software search their existing tags (which is populated in an autocomplete). I want to index this search in Sphinx so the tag search is ultra responsive. I have seen posts on how to index a Model's tags with…
jnarowski
  • 113
  • 3
0
votes
1 answer

Indexing Euro (€) and Lb (£) in Sphinx

These don't seem to index, even when I explicitly add them to my charset_table: charset_table=... U+20AC->U+20AC, U+00A3->U+00A3 I even tried mapping them to the dollar sign U+0024->U+0024, U+20AC->U+0024, U+00A3->U+0024 Yet in each case they are…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

Best Practice to go from sphinx db to somewhat complex golang struct

I am trying to convert a sphinx query via MySQL into a golang struct and am having a hard time. It seems like this should be a common sort of problem, but so far I'm stuck converting it to a map or parsing output myself. Specifically, I have a…
Matt C
  • 29
  • 3
0
votes
1 answer

Sphinx for recognizing Digits

Because I don't want 15.50 to index as 15 50 I made a # of additions to the Exceptions file in my Sphinx Configuration file e.g. 1.50 => 1.50 However that gets quickly out of hand. I tried doing as a regexp instead…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Is there a way to add zone_weights() in Sphinx?

I successfully managed to use field_weights in Sphinx to get the relevance I needed. However my fields are actually inclusive of several html tags (e.g. and ). I need those in one field because of some other config work I am…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
3 answers

how can i query where clause using between date in sphinx

I have this query: select * from tabel where last_purchase_categories = 'flight' and last_purchase_date between '2016-10-23 11:06:47' and '2016-10-23 11:06:49'; it is didnt work in sphinx. i use fulltext search using mysql query browser. do…
Erik Mega
  • 75
  • 4
0
votes
1 answer

Is there a way to return the field_weights values?

When I run a SphinxQL query I can request the Weight() Select ID,Weight(),Title from Index_A where MATCH('@(Title,Description) London') Which returns the weight that Sphinx assigned each match however when I add field_weights to the query: Select…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Combine field_weights with ORDER by in Sphinx

I seem to have had my question answered on how to order results by relevance using OPTION field_weights. However I'm finding it does not work when using an ORDER by in the same SphinxQL Query e.g. Select * from Items where MATCH('@(Listing_Title)…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Select Union in SphinxQL?

Is it possible to do any sort of Union using SphinxQL? I want to return one set of results containing two queries and in order of the query. A simple example would be: Select Author from idx_jobs where MATCH('@(Author) Steinbeck') Union Select…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

How to select columns in sql query of source in sphinx

I'm using sphinx indexer to create a dictionary based on documents in my mysql db, but I can't limit the source's sql query to selected columns. This is the command I use indexer --buildstops dict.txt 1000 --verbose --print-queries --dump-rows…
forste
  • 1,103
  • 3
  • 14
  • 33
0
votes
1 answer

How to implement Shinx voice recognition api in android

I want to implement Sphinx voice recognition API in my program that run on Android.
Mojiiz
  • 7,898
  • 6
  • 26
  • 25
0
votes
0 answers

Sphinx Index/Replace Curly Apostrophes

I asked this previously as a Regex question yet the issue appears to be Sphinx as even the correct Regex set-up failed in Sphinx. So: Is there a way to convert curly apostrophes in the index to straight ones? I have tried: Exceptions.text: ’ =>…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
0 answers

Regex Curly Apostrophes (Sphinx specific?)

I made a basic regexp_filter in Sphinx to remove apostrophes: regexp_filter=(\w+)\'s=>\1 However discovered it is not working on curly apostrophes e.g. books’s even if I do (\w+)[\'’]s Because sphinx uses a vanilla text editor for it's…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Search over multiple indexes

I've got three tables in my DB organization | id | name | attribute_1 | attribute_2 | document | id | org_id | content | person | id | org_id | name | status | Relation between organization and document is 1:1. Organization may have only one…
Andrew Kotov
  • 3
  • 3
1 2 3
…
99 100