DBMS > Drizzle vs. FeatureBase vs. Sphinx
System Properties Comparison Drizzle vs. FeatureBase vs. Sphinx
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Drizzle Xexclude from comparison||FeatureBase Xexclude from comparison||Sphinx Xexclude from comparison|
|Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.|
|Description||MySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.||Real-time database platform that powers real-time analytics and machine learning applications by simultaneously executing low-latency, high-throughput, and highly concurrent workloads.||Open source search engine for searching in data from different sources, e.g. relational databases|
|Primary database model||Relational DBMS||Relational DBMS||Search engine|
|Developer||Drizzle project, originally started by Brian Aker||Molecula and Pilosa Open Source Contributors||Sphinx Technologies Inc.|
|Current release||7.2.4, September 2012||2022, May 2022||3.5.1, February 2023|
|License Commercial or Open Source||Open Source GNU GPL||commercial||Open Source GPL version 2, commercial licence available|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||FreeBSD|
|Typing predefined data types such as float or date||yes||yes||no|
|Secondary indexes||yes||no||yes full-text index on all search fields|
|SQL Support of SQL||yes with proprietary extensions||SQL queries||SQL-like query language (SphinxQL)|
|APIs and other access methods||JDBC||gRPC|
|Supported programming languages||C|
|C++ unofficial client library|
Perl unofficial client library
Ruby unofficial client library
|Server-side scripts Stored procedures||no||no|
|Triggers||no hooks for callbacks inside the server can be used.||no||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding||Sharding||Sharding Partitioning is done manually, search queries against distributed index is supported|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no|
|Foreign keys Referential integrity||yes||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||yes||no|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes, using Linux fsync||yes The original contents of fields are not stored in the Sphinx index.|
|User concepts Access control||Pluggable authentication mechanisms e.g. LDAP, HTTP||no|
More information provided by the system vendor
Related products and services
|DB-Engines blog posts|
MySQL won the April ranking; did its forks follow?
The DB-Engines ranking includes now search engines The insideBIGDATA IMPACT 50 List for Q1 2023 Get Your Infrastructure Ready for Real-Time Analytics Emerging Big Data Vendors To Know In 2022 Gut-specific telomerase expression counteracts systemic aging in ... What Is a Structured Interview? Definition & Examples. provided by Google News The FAIR Cookbook - the essential resource for and by FAIR doers ... A Future Jewish President? The Pirate Bay was recently down for over a week due to a DDoS ... 7 Tips for Effective Communication with Chat AI Assistants Mark Hill: The future looks dim: Silicon Valley and the race to make ... provided by Google News
The insideBIGDATA IMPACT 50 List for Q1 2023
Get Your Infrastructure Ready for Real-Time Analytics
Emerging Big Data Vendors To Know In 2022
Gut-specific telomerase expression counteracts systemic aging in ...
What Is a Structured Interview? Definition & Examples.
provided by Google News
The FAIR Cookbook - the essential resource for and by FAIR doers ...
A Future Jewish President?
The Pirate Bay was recently down for over a week due to a DDoS ...
7 Tips for Effective Communication with Chat AI Assistants
Mark Hill: The future looks dim: Silicon Valley and the race to make ...
provided by Google News
Share this page