DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Fauna vs. IBM Db2 Event Store vs. SQLite vs. SQream DB

System Properties Comparison Fauna vs. IBM Db2 Event Store vs. SQLite vs. SQream DB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFauna infopreviously named FaunaDB  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparisonSQLite  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.Distributed Event Store optimized for Internet of Things use casesWidely used embeddable, in-process RDBMSa GPU-based, columnar RDBMS for big data analytics workloads
Primary database modelDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Event Store
Time Series DBMS
Relational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.50
Rank#147  Overall
#26  Document stores
#13  Graph DBMS
#67  Relational DBMS
#13  Time Series DBMS
Score0.18
Rank#315  Overall
#2  Event Stores
#26  Time Series DBMS
Score101.91
Rank#10  Overall
#7  Relational DBMS
Score0.67
Rank#225  Overall
#105  Relational DBMS
Websitefauna.comwww.ibm.com/­products/­db2-event-storewww.sqlite.orgsqream.com
Technical documentationdocs.fauna.comwww.ibm.com/­docs/­en/­db2-event-storewww.sqlite.org/­docs.htmldocs.sqream.com
DeveloperFauna, Inc.IBMDwayne Richard HippSQream Technologies
Initial release2014201720002017
Current release2.03.46.1  (13 August 2024), August 20242022.1.6, December 2022
License infoCommercial or Open Sourcecommercialcommercial infofree developer edition availableOpen Source infoPublic Domaincommercial
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageScalaC and C++CC++, CUDA, Haskell, Java, Scala
Server operating systemshostedLinux infoLinux, macOS, Windows for the developer additionserver-lessLinux
Data schemeschema-freeyesyes infodynamic column typesyes
Typing infopredefined data types such as float or datenoyesyes infonot rigid because of 'dynamic typing' concept.yes, 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 indexesyesnoyesno
SQL infoSupport of SQLnoyes infothrough the embedded Spark runtimeyes infoSQL-92 is not fully supportedyes
APIs and other access methodsRESTful HTTP APIADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
ADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
.Net
JDBC
ODBC
Supported programming languagesC#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
C++
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresuser defined functionsyesnouser defined functions in Python
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoconsistent hashingShardingnonehorizontal and vertical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationActive-active shard replicationnonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesNo - written data is immutableyes infovia file-system locksyes
Durability infoSupport for making data persistentyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storageyesyes
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 controlfine grained access rights according to SQL-standardno

More information provided by the system vendor

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

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

More resources
Fauna infopreviously named FaunaDBIBM Db2 Event StoreSQLiteSQream DB
DB-Engines blog posts

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Recent citations in the news

Fauna Adds Declarative Tool to Update Namesake Database
1 July 2024, DevOps.com

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

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

Through comparative genomics, becoming tough as nails – or squirrels
30 January 2024, BioWorld Online

First Sydney fauna bridge debuts alongside connectivity database
7 September 2024, Transport for NSW

provided by Google News

Zero-latency SQLite storage in every Durable Object
26 September 2024, The Cloudflare Blog

How to install SQLite on Windows
20 October 2024, TheServerSide.com

SQLite will migrate from GNU Autotools to Autosetup, team warns of 'some build-level breakage'
24 October 2024, DevClass

SQLite Gets Into Vector Search
5 September 2024, iProgrammer

Intro to Node's built-in SQLite module
25 September 2024, InfoWorld

provided by Google News

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

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

Accelerated Databases In The Fast Lane
25 June 2020, The Next Platform

Chinese giant Alibaba leads investment round in Israel big-data startup
30 May 2018, The Times of Israel

SQream and Datatrend announce strategic partnership agreement
30 August 2018, Geospatial World

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

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

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here