{"id":994,"date":"2007-10-08T00:00:00","date_gmt":"2007-10-07T22:00:00","guid":{"rendered":"https:\/\/wwwneu.strehle.de\/tim\/weblog\/archives\/2007\/10\/08\/932\/"},"modified":"2007-10-08T00:00:00","modified_gmt":"2007-10-07T22:00:00","slug":"932","status":"publish","type":"post","link":"https:\/\/www.strehle.de\/tim\/weblog\/archives\/2007\/10\/08\/932\/","title":{"rendered":"Sphinx &#8211; Free open-source SQL full-text search engine"},"content":{"rendered":"<p>&#8222;<a href=\"http:\/\/www.sphinxsearch.com\/\" title=\"Sphinx - Free open-source SQL full-text search engine\">Sphinx<\/a> is a full-text search engine, distributed under GPL version 2.<\/p>\n<p>[&#8230;] Generally, it&#8217;s a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).&#8220;<\/p>\n<p>The largest installation has <a href=\"http:\/\/www.mysqlperformanceblog.com\/2007\/07\/23\/sphinx-going-beyond-full-text-search\/\" title=\"Sphinx: Going Beyond full text search | MySQL Performance Blog\">indexed over 1 billion records<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8222;Sphinx is a full-text search engine, distributed under GPL version 2. [&#8230;] Generally, it&#8217;s a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_share_on_mastodon":"0"},"categories":[1],"tags":[],"class_list":["post-994","post","type-post","status-publish","format-standard","hentry","category-weblog"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/comments?post=994"}],"version-history":[{"count":0,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/994\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/media?parent=994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/categories?post=994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/tags?post=994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}