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
8
votes
3 answers

undefined method `next_result' for Mysql2 (rails 3)

I used to use the second version of the software and had no problems. In my last application, I decided to use the latest "thinking-sphinx". I have a strange mistake. > NoMethodError in Adverts#index undefined method `next_result' for >…
user1466717
  • 779
  • 1
  • 10
  • 23
7
votes
2 answers

Full Text Search with Firebird and Delphi

I'm looking into implementing full text search on our Firebird database. Our requirements are: Every field in several tables should be indexed. When a result is found we should be able to find out the originating table. The index can be stored in…
norgepaul
  • 6,013
  • 4
  • 43
  • 76
7
votes
3 answers

MySQL 5.6 InnoDB Full Text Search

I realize that MySQL 5.6 is still in beta, but does anyone have experience using the new InnoDB FTS engine? How does it compare to something like Sphinx? Thanks Jason
Jason
  • 683
  • 2
  • 9
  • 14
7
votes
2 answers

Zend Lucene or sphinx?

I am building a system that has database operations that has millions of records.I am using Zend Framework in all part of my project.I wanted to use a search indexing technique but have you got any advice on this?which technique should i use? Thanks…
Hüseyin BABAL
  • 15,400
  • 4
  • 51
  • 73
7
votes
4 answers

Searching Techniques Recommendations

This is more of a theory question rather than practice. I'm working on a project which is quite a simple catalog of links. The whole model is similar to the Dmoz or Yahoo catalog, except that each entry has certain additional attributes. I have…
kovshenin
  • 31,813
  • 4
  • 35
  • 46
7
votes
2 answers

Spelling correction in Sphinx?

I was about to integrate the Sphinx-based search into the website, but I've found that there's no built support for spelling correction. Folks on the web suggest using pspell or other third-party libraries to get things done, but the problem is the…
htf
  • 1,503
  • 4
  • 15
  • 21
7
votes
1 answer

Enabling partial word matches in Sphinx?

I'm new to Sphinx and am trying to get it configured correctly. I want to allow partial word matching for all searches and do not want users to have to type in wildcard characters on their own. I'm wanting the search to function like on Amazon or…
Nate
  • 26,164
  • 34
  • 130
  • 214
7
votes
2 answers

update thinking sphinx index in ruby code

I have app, which run's on ubuntu 12.04, with nginx+passenger And in my method i try to rebuild sphinx index so: def update_sphinx_index Rails.application.load_tasks Rake::Task['ts:rebuild'].invoke redirect_to admin_mainpage_path …
brabertaser19
  • 5,678
  • 16
  • 78
  • 184
7
votes
1 answer

Sphinx: WARNING: Attribute count is 0: switching to none docinfo

I'm new to Sphinx and I can't seem to figure out what this warning is referring to or how to fix it. A google search didn't provide much information so I'm hoping a database guru here knows how to fix this. Thanks!
David Jones
  • 10,117
  • 28
  • 91
  • 139
6
votes
1 answer

How to scalably implement something like Google alerts?

The requirement is that we have a lot of saved searches, and when new documents come in, we want to be able to find which saved searches are matched by these new documents, and be able to notify the creators of these saved searches in real time. Is…
Gary Chang
  • 1,042
  • 12
  • 18
6
votes
4 answers

How can i install Sphinx for Mac Os Lion?

I want to install latest stable version of Sphinx (sphinxsearch.com) on Mac OS X Lion. What is a right way to do that?
ExiRe
  • 4,727
  • 7
  • 47
  • 92
6
votes
3 answers

Thinking sphinx fuzzy search?

I am implementing sphinx search in my rails application. I want to search with fuzzy on. It should search for spelling mistakes e.g if is enter search query charact*a*ristics, it should search for charact*e*ristics. How should I implement this
Pravin
  • 6,592
  • 4
  • 42
  • 51
6
votes
2 answers

Connecting to Sphinx from sql server linked server

I am trying to connect to Sphinx from SQL Server Management Studio as a Linked server. I tried the following query: EXEC master.dbo.sp_addlinkedserver @server=N'SPHINX_SEARCH', @srvproduct=N'', @provider=N'MSDASQL', @provstr=N'Driver={MySQL ODBC 8.0…
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
6
votes
3 answers

Fastest full text search today?

spoiler : This is just another Lucene vs Sphinx vs whatever, I saw that all other threads were almost two years old, so decided to start again.. Here is the requirement : data size : max 10 GB. rows : nearly billions indexing should be…
Shrinath
  • 7,888
  • 13
  • 48
  • 85
6
votes
2 answers

Thinking Sphinx Rake aborted, searchd is running while rebuilding or start/stop ts. Index works fine

When I invoke rake ts:rebuild RAILS_ENV=production, I get the following: (in /var/www/abc.com/public/abc/releases/20101008073517) ** Erubis 2.6.6 Stopped search daemon (pid 22531). Generating Configuration to…
Victor
  • 13,010
  • 18
  • 83
  • 146
1 2 3
…
99 100