DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

Sphinx


Sphinx is a standalone full-text search engine whose goal is to provide fast and relevant full-text search functionality. It is built to integrate with SQL databases, and to provide easy access via scripting languages, but it can be used directly without an SQL database.[05]

Source Code
https://github.com/sphinxsearch/sphinx[02]
Country of Origin
US
Start Year
2001
Project Types
Commercial, Open Source
Written in
C++
Supported Languages
C, Java, Perl, PHP, Python, Ruby
Operating Systems
AIX, BSD, Linux, macOS, Solaris, Windows
Licenses
GPL v2, Proprietary

The Sphinx search daemon can be accessed via:

  • SphinxQL, Sphinx's implementation of the MySQL network protocol that uses a subset of SQL.
  • SphinxAPI, Sphinx's native search API, provided in PHP, Perl, Python, Ruby, and Java.
  • Through MySQL server using SphinxSE, a storage engine component.

Sphinx provides two indexing backends:

  • Disk: supports online full-text index rebuilds, but online updates can only be done to attribute data.
  • Realtime: also allow online full-text updates.

Sphinx can use the following types of data sources to load disk indexes:

  • MySQL
  • PostgreSQL
  • MSSQL
  • ODBC databases
  • TSV/XML files
  • Can also work with custom source drivers.

The name of Sphinx refers to SQL Phrase Index.

Database Entry

Sphinx


Sphinx is a standalone full-text search engine whose goal is to provide fast and relevant full-text search functionality. It is built to integrate with SQL databases, and to provide easy access via scripting languages, but it can be used directly without an SQL database.

The Sphinx search daemon can be accessed via:

  • SphinxQL, Sphinx's implementation of the MySQL network protocol that uses a subset of SQL.
  • SphinxAPI, Sphinx's native search API, provided in PHP, Perl, Python, Ruby, and Java.
  • Through MySQL server using SphinxSE, a storage engine component.

Sphinx provides two indexing backends:

  • Disk: supports online full-text index rebuilds, but online updates can only be done to attribute data.
  • Realtime: also allow online full-text updates.

Sphinx can use the following types of data sources to load disk indexes:

  • MySQL
  • PostgreSQL
  • MSSQL
  • ODBC databases
  • TSV/XML files
  • Can also work with custom source drivers.

The name of Sphinx refers to SQL Phrase Index.[05]

History[06]


Andrew Aksyonoff is the original author.

Data Model


Citations

6 sources
  1. Sphinx | Open Source Search Engine sphinxsearch.com
  2. GitHub - sphinxsearch/sphinx: Sphinx search server · GitHub github.com
  3. Documentation | Sphinx sphinxsearch.com
  4. Sphinx (search engine) - Wikipedia wikipedia.org
  5. Sphinx | Open Source Search Server sphinxsearch.com
  6. Sphinx 3.0.1 released « full-text diary | Sphinx | Open Source Search Server sphinxsearch.com
Revision #17 Last Updated: