DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Fauna vs. Memcached vs. RocksDB vs. SingleStore vs. SQream DB

System Properties Comparison Fauna vs. Memcached vs. RocksDB vs. SingleStore vs. SQream DB

Editorial information provided by DB-Engines
NameFauna infopreviously named FaunaDB  Xexclude from comparisonMemcached  Xexclude from comparisonRocksDB  Xexclude from comparisonSingleStore infoformer name was MemSQL  Xexclude from comparisonSQream DB  Xexclude from comparison
DescriptionFauna provides a web-native interface, with support for GraphQL and custom business logic that integrates seamlessly with the rest of the serverless ecosystem. The underlying globally distributed storage and compute platform is fast, consistent, and reliable, with a modern security infrastructure.In-memory key-value store, originally intended for cachingEmbeddable persistent key-value store optimized for fast storage (flash and RAM)MySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table typea GPU-based, columnar RDBMS for big data analytics workloads
Primary database modelDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Key-value storeKey-value storeRelational DBMSRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Time Series DBMS
Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.55
Rank#151  Overall
#26  Document stores
#14  Graph DBMS
#71  Relational DBMS
#13  Time Series DBMS
Score18.08
Rank#32  Overall
#4  Key-value stores
Score3.41
Rank#86  Overall
#11  Key-value stores
Score5.38
Rank#62  Overall
#35  Relational DBMS
Score0.74
Rank#224  Overall
#103  Relational DBMS
Websitefauna.comwww.memcached.orgrocksdb.orgwww.singlestore.comsqream.com
Technical documentationdocs.fauna.comgithub.com/­memcached/­memcached/­wikigithub.com/­facebook/­rocksdb/­wikidocs.singlestore.comdocs.sqream.com
DeveloperFauna, Inc.Danga Interactive infooriginally developed by Brad Fitzpatrick for LiveJournalFacebook, Inc.SingleStore Inc.SQream Technologies
Initial release20142003201320132017
Current release1.6.27, May 20249.2.1, May 20248.5, January 20242022.1.6, December 2022
License infoCommercial or Open SourcecommercialOpen Source infoBSD licenseOpen Source infoBSDcommercial infofree developer edition availablecommercial
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SingleStoreDB Cloud: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities
Implementation languageScalaCC++C++, GoC++, CUDA, Haskell, Java, Scala
Server operating systemshostedFreeBSD
Linux
OS X
Unix
Windows
LinuxLinux info64 bit version requiredLinux
Data schemeschema-freeschema-freeschema-freeyesyes
Typing infopredefined data types such as float or datenononoyesyes, ANSI Standard SQL Types
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesyesnonoyesno
SQL infoSupport of SQLnononoyes infobut no triggers and foreign keysyes
APIs and other access methodsRESTful HTTP APIProprietary protocolC++ API
Java API
Cluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
MongoDB API
ODBC
.Net
JDBC
ODBC
Supported programming languagesC#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
.Net
C
C++
ColdFusion
Erlang
Java
Lisp
Lua
OCaml
Perl
PHP
Python
Ruby
C
C++
Go
Java
Perl
Python
Ruby
Bash
C
C#
Java
JavaScript (Node.js)
Python
C++
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresuser defined functionsnonoyesuser defined functions in Python
Triggersnononono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoconsistent hashingnonehorizontal partitioningSharding infohash partitioninghorizontal and vertical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationnone infoRepcached, a Memcached patch, provides this functionallityyesSource-replica replication infostores two copies of each physical data partition on two separate nodesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono infocan define user-defined aggregate functions for map-reduce-style calculationsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoyesACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesnoyesyes infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.yes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes
User concepts infoAccess controlIdentity management, authentication, and access controlyes infousing SASL (Simple Authentication and Security Layer) protocolnoFine grained access control via users, groups and roles
More information provided by the system vendor
Fauna infopreviously named FaunaDBMemcachedRocksDBSingleStore infoformer name was MemSQLSQream DB
Specific characteristicsSingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» more
Competitive advantagesSingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» more
Typical application scenariosDriving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» more
Key customersIEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» more
Market metricsCustomers in various industries worldwide including US and International Industry...
» more
Licensing and pricing modelsF ree Tier and Enterprise Edition
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesSpeedb: A high performance RocksDB-compliant key-value store optimized for write-intensive workloads.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Fauna infopreviously named FaunaDBMemcachedRocksDBSingleStore infoformer name was MemSQLSQream DB
DB-Engines blog posts

Redis extends the lead in the DB-Engines key-value store ranking
3 February 2014, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

Turbocharge Your Application Development Using WebAssembly With SingleStoreDB
17 October 2022,  Akmal Chaudhri, SingleStore (sponsor) 

Cloud-Based Analytics With SingleStoreDB
9 June 2022,  Akmal Chaudhri, SingleStore (sponsor) 

SingleStore: The Increasing Momentum of Multi-Model Database Systems
14 February 2022,  Akmal Chaudhri, SingleStore (sponsor) 

show all

Recent citations in the news

Utah Natural Heritage Program
12 June 2024, Utah Division of Wildlife Resources

Fauna Launches Distributed Document-Relational Database On Google Cloud Marketplace
21 March 2024, GlobeNewswire

Slicing the Gordian Knot: A leap to real-time systems of truth
3 February 2024, SiliconANGLE News

Fauna Adds Groundbreaking New Database Language and Seamless Developer Experience to Enterprise Proven ...
22 August 2023, Business Wire

CITES Trade Database surpasses 25 million trade transaction records
3 October 2023, Convention on International Trade in Endangered Species of Wild Fauna and Flora (CITES)

provided by Google News

Why DDoS Threat Actors Are Shifting Their Tactics
15 March 2024, Infosecurity Magazine

Intel Continues To Demonstrate The Importance Of Software Optimizations: Clear Linux + Xeon Max Benchmarks
23 October 2023, Phoronix

Why Redis beats Memcached for caching
14 September 2017, InfoWorld

Memcached DDoS: The biggest, baddest denial of service attacker yet
1 March 2018, ZDNet

What are memcached servers, and why are they being used to launch record-setting DDoS attacks?
6 March 2018, GeekWire

provided by Google News

Did Rockset Just Solve Real-Time Analytics?
25 August 2021, Datanami

Meta’s Velox Means Database Performance Is Not Subject To Interpretation
31 August 2022, The Next Platform

Linux 6.9 Drives AMD 4th Gen EPYC Performance Even Higher For Some Workloads
29 March 2024, Phoronix

Facebook's MyRocks Truly Rocks!
21 September 2020, Open Source For You

Power your Kafka Streams application with Amazon MSK and AWS Fargate | Amazon Web Services
10 August 2021, AWS Blog

provided by Google News

Building a Modern Database: Nikita Shamgunov on Postgres and Beyond
18 April 2024, Madrona Venture Group

SingleStore CEO sees little future for purpose-built vector databases
24 January 2024, VentureBeat

SingleStore Announces Real-time Data Platform to Further Accelerate AI, Analytics and Application Development
24 January 2024, Business Wire

SingleStore adds indexed vector search to Pro Max release for faster AI work – Blocks and Files
29 January 2024, Blocks and Files

SingleStore update adds new tools to fuel GenAI, analytics
24 January 2024, TechTarget

provided by Google News

I SQream, you SQream, we all SQream for … data analytics?
5 October 2023, Fierce Network

SQream Announces Strategic Integration for Powerful Big Data Analytics with Dataiku
9 February 2024, insideBIGDATA

SQream Joins Samsung Cloud Platform Ecosystem
26 July 2023, Datanami

GPU data warehouse startup SQream lands $39.4M funding round
24 June 2020, SiliconANGLE News

SQream Technologies raises $39.4 million for GPU-accelerated databases
24 June 2020, VentureBeat

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here