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

DBMS > Amazon DocumentDB vs. Firebird vs. Google Cloud Firestore vs. SingleStore vs. SwayDB

System Properties Comparison Amazon DocumentDB vs. Firebird vs. Google Cloud Firestore vs. SingleStore vs. SwayDB

Editorial information provided by DB-Engines
NameAmazon DocumentDB  Xexclude from comparisonFirebird  Xexclude from comparisonGoogle Cloud Firestore  Xexclude from comparisonSingleStore infoformer name was MemSQL  Xexclude from comparisonSwayDB  Xexclude from comparison
DescriptionFast, scalable, highly available, and fully managed MongoDB-compatible database serviceFirebird is an open source RDBMS forked from Borland's InterBaseCloud Firestore is an auto-scaling document database for storing, syncing, and querying data for mobile and web apps. It offers seamless integration with other Firebase and Google Cloud Platform products.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 typeAn embeddable, non-blocking, type-safe key-value store for single or multiple disks and in-memory storage
Primary database modelDocument storeRelational DBMSDocument storeRelational DBMSKey-value store
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.88
Rank#124  Overall
#22  Document stores
Score19.02
Rank#30  Overall
#18  Relational DBMS
Score6.46
Rank#54  Overall
#9  Document stores
Score4.11
Rank#70  Overall
#38  Relational DBMS
Score0.00
Rank#387  Overall
#61  Key-value stores
Websiteaws.amazon.com/­documentdbwww.firebirdsql.orgfirebase.google.com/­products/­firestorewww.singlestore.comswaydb.simer.au
Technical documentationaws.amazon.com/­documentdb/­resourceswww.firebirdsql.org/­en/­reference-manualsfirebase.google.com/­docs/­firestoredocs.singlestore.com
DeveloperFirebird FoundationGoogleSingleStore Inc.Simer Plaha
Initial release20192000 infoAs fork of Borland's InterBase201720132018
Current release5.0.1, August 20248.5, January 2024
License infoCommercial or Open SourcecommercialOpen Source infoInitial Developer's Public Licensecommercialcommercial infofree developer edition availableOpen Source infoGNU Affero GPL V3.0
Cloud-based only infoOnly available as a cloud serviceyesnoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++C++, GoScala
Server operating systemshostedAIX
FreeBSD
HP-UX
Linux
OS X
server-less infoFirebird Embedded Server
Solaris
Unix
Windows
hostedLinux info64 bit version required
Data schemeschema-freeyesschema-freeyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyesno
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.nononono
Secondary indexesyesyesyesyesno
SQL infoSupport of SQLnoyesnoyes infobut no triggers and foreign keysno
APIs and other access methodsproprietary protocol using JSON (MongoDB compatible)ADO.NET
C/C++ API
JDBC infoJaybird
ODBC
OLE DB
Android
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
Cluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
MongoDB API
ODBC
Supported programming languagesGo
Java
JavaScript (Node.js)
PHP
Python
C
C#
C++
Delphi
Java
JavaScript infoNode.js
Lua
Perl
PHP
Python
Ruby
Go
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
Bash
C
C#
Java
JavaScript (Node.js)
Python
Java
Kotlin
Scala
Server-side scripts infoStored proceduresnoPSQLyes, Firebase Rules & Cloud Functionsyesno
Triggersnoyesyes, with Cloud Functionsnono
Partitioning methods infoMethods for storing different data on different nodesnonenoneShardingSharding infohash partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-availability zones for high availability, asynchronous replication for up to 15 read replicasSource-replica replicationMulti-source replicationSource-replica replication infostores two copies of each physical data partition on two separate nodesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsno infomay be implemented via Amazon Elastic MapReduce (Amazon EMR)noUsing Cloud Dataflowno infocan define user-defined aggregate functions for map-reduce-style calculationsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityno infotypically not used, however similar functionality with DBRef possibleyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic single-document operationsACIDyesACIDAtomic execution of operations
Concurrency infoSupport for concurrent manipulation of datayesyes infoFeatures a multi-generational MVCC architecture, readers do not block writersyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyesyes 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.yesyes
User concepts infoAccess controlAccess rights for users and rolesUsers with fine-grained authorization conceptAccess rights for users, groups and roles based on Google Cloud Identity and Access Management. Security Rules for 3rd party authentication using Firebase Auth.Fine grained access control via users, groups and rolesno

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
Amazon DocumentDBFirebirdGoogle Cloud FirestoreSingleStore infoformer name was MemSQLSwayDB
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, 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

Unlock cost savings using compression with Amazon DocumentDB
25 October 2024, AWS Blog

Unlock the power of parallel indexing in Amazon DocumentDB
19 June 2024, AWS Blog

Reduce cost and improve performance by migrating to Amazon DocumentDB 5.0
15 April 2024, AWS Blog

Amazon DocumentDB zero-ETL integration with Amazon OpenSearch Service is now available
16 May 2024, AWS Blog

AWS announces Amazon DocumentDB zero-ETL integration with Amazon OpenSearch Service
16 May 2024, AWS Blog

provided by Google News

Firebird – Director, Operations & Production (UK)
24 May 2024, Music Business Worldwide

12 Top Open Source Databases to Consider
1 May 2024, TechTarget

1976 Pontiac Firebird Trans Am Is an All-Original Museum Piece, Looks Best in the Driveway
1 July 2024, autoevolution

Best Open Source Software List For Data Management In 2024
7 May 2024, Datamation

Albany Firebirds release 2024 roster, coaching staff list
25 April 2024, Arena Insider

provided by Google News

Google launches Firebase Genkit, a new open source framework for building AI-powered apps
14 May 2024, TechCrunch

NoSQL on the Cloud With Python
7 August 2020, Towards Data Science

Google Reveals Android Performance Tuner, Android GPU Inspector and Cloud Firestore
23 March 2020, Wccftech

Spring Boot Tutorial: Building Microservices Deployed to Google Cloud
26 March 2020, InfoQ.com

Google updates Firebase with new emulator and data analysis tools
27 October 2020, VentureBeat

provided by Google News

Third time was the charm for SingleStore in the cloud, CEO says
8 July 2024, The Register

SingleStore acquires BryteFlow to boost data ingestion capabilities
3 October 2024, InfoWorld

SingleStore Acquires BryteFlow ​​to Accelerate Adoption of Real-Time Analytics, GenAI
3 October 2024, Business Wire

SingleStore acquires BryteFlow to better digest ERP and CRM data
4 October 2024, Blocks & Files

Achieve near real-time analytics on Amazon DynamoDB with SingleStore
16 September 2024, AWS Blog

provided by Google News



Share this page

Featured Products

Milvus logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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

SingleStore logo

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

Neo4j logo

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

Present your product here