SQL Phrase Index

from Wikipedia, the free encyclopedia
sphinx
Basic data

developer Andrew Aksyonoff
Publishing year 2001
Current  version 3.1.1
( October 17, 2018 )
operating system unixoid system , Microsoft Windows
programming language C ++
category Search engine
License GNU General Public License, version 2
German speaking No
sphinxsearch.com

Sphinx is a full-text search engine published under the GNU General Public License (GPL, Version 2). However, there is also a commercial version for embedded systems . Sphinx shows its main advantages in the implementation of its own search engines for programs or web applications that have to process large amounts of data in a short time.

In principle, it is an independent engine, which, however, was designed to work specifically with SQL -based databases and script languages .

MySQL and PostgreSQL are currently supported as database systems . But there is also the possibility of saving the data via a pipe using a user-defined XML format.

In addition, the driver model was designed to be open so that additional database connections can be easily implemented.

Nativ are PHP , Python , Perl and Ruby support as a scripting language. SphinxSE is suitable for programming languages that do not have a Sphinx API and for cases in which the search is absolutely necessary via MySQL. SphinxSE is a storage engine that was implemented as a MySQL plug-in and uses Sphinx as a search backend . This also has the advantage that the search results can be processed further with MySQL.

Web links

Individual evidence

  1. ↑ sphinxsearch.com .
  2. ↑ a b Supported systems . (English, accessed on August 5, 2018).
  3. ↑ Compiling Sphinx from source . (English, accessed on August 5, 2018).
  4. ↑ License . (English, accessed on August 5, 2018).