DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Fauna vs. Google Cloud Datastore vs. Lovefield vs. MariaDB

System Properties Comparison Fauna vs. Google Cloud Datastore vs. Lovefield vs. MariaDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFauna infopreviously named FaunaDB  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparisonLovefield  Xexclude from comparisonMariaDB  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.Automatically scaling NoSQL Database as a Service (DBaaS) on the Google Cloud PlatformEmbeddable relational database for web apps written in pure JavaScriptMySQL application compatible open source RDBMS, enhanced with high availability, security, interoperability and performance capabilities. MariaDB ColumnStore provides a column-oriented storage engine and MariaDB Xpand supports distributed SQL.
Primary database modelDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Document storeRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS infowith OQGraph storage engine
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.70
Rank#149  Overall
#26  Document stores
#12  Graph DBMS
#72  Relational DBMS
#12  Time Series DBMS
Score7.10
Rank#62  Overall
#11  Document stores
Score0.37
Rank#288  Overall
#132  Relational DBMS
Score104.91
Rank#13  Overall
#9  Relational DBMS
Websitefauna.comcloud.google.com/­datastoregoogle.github.io/­lovefieldmariadb.com infoSite of MariaDB Corporation
mariadb.org infoSite of MariaDB Foundation
Technical documentationdocs.fauna.comcloud.google.com/­datastore/­docsgithub.com/­google/­lovefield/­blob/­master/­docs/­spec_index.mdmariadb.com/­kb/­en/­library
DeveloperFauna, Inc.GoogleGoogleMariaDB Corporation Ab (MariaDB Enterprise),
MariaDB Foundation (community MariaDB Server) infoThe lead developer Monty Widenius is the original author of MySQL
Initial release2014200820142009 infoFork of MySQL, which was first released in 1995
Current release2.1.12, February 201710.9.4, November 2022
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache 2.0Open Source infoGPL version 2, commercial enterprise subscription available
Cloud-based only infoOnly available as a cloud serviceyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SkySQL (The Ultimate MariaDB Cloud): The first and only DBaaS to bring the full power of MariaDB Platform to the cloud, combining powerful enterprise features and world-class support with unrivaled ease of use and groundbreaking innovation.
Implementation languageScalaJavaScriptC and C++
Server operating systemshostedhostedserver-less, requires a JavaScript environment (browser, Node.js) infotested with Chrome, Firefox, IE, SafariFreeBSD
Linux
Solaris
Windows infoColumnStore storage engine not available on Windows
Data schemeschema-freeschema-freeyesyes infoDynamic columns are supported
Typing infopredefined data types such as float or datenoyes, details hereyesyes
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.nononoyes
Secondary indexesyesyesyesyes
SQL infoSupport of SQLnoSQL-like query language (GQL)SQL-like query language infovia JavaScript builder patternyes infowith proprietary extensions
APIs and other access methodsRESTful HTTP APIgRPC (using protocol buffers) API
RESTful HTTP/JSON API
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languagesC#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
JavaScriptAda
C
C#
C++
D
Eiffel
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresuser defined functionsusing Google App Enginenoyes infoPL/SQL compatibility added with version 10.3
TriggersnoCallbacks using the Google Apps EngineUsing read-only observersyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoconsistent hashingShardingnoneseveral options for horizontal partitioning and Sharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationMulti-source replication using PaxosnoneMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infousing Google Cloud Dataflownono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on type of query and configuration infoStrong Consistency is default for entity lookups and queries within an Entity Group (but can instead be made eventually consistent). Other queries are always eventual consistent.Immediate Consistency
Foreign keys infoReferential integrityyesyes infovia ReferenceProperties or Ancestor pathsyesyes infonot for MyISAM storage engine
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infoSerializable Isolation within Transactions, Read Committed outside of TransactionsACIDACID infonot for MyISAM storage engine
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyes, by using IndexedDB or the cloud service Firebase Realtime Databaseyes infonot for in-memory storage engine
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyes infousing MemoryDByes infowith MEMORY storage engine
User concepts infoAccess controlIdentity management, authentication, and access controlAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)nofine grained access rights according to SQL-standard
More information provided by the system vendor
Fauna infopreviously named FaunaDBGoogle Cloud DatastoreLovefieldMariaDB
Specific characteristicsMariaDB is the most powerful open source relational database – modern SQL and JSON...
» more
Competitive advantagesMariaDB has many features unavailable in other open source relational databases....
» more
Typical application scenariosWeb, SaaS and Cloud operational/transactional applications that require high availability,...
» more
Key customersDeutsche Bank, DBS Bank, Nasdaq, Red Hat, ServiceNow, Verizon and Walgreens Featured...
» more
Market metricsMariaDB is the default database in the LAMP stack supplied by Red Hat and SUSE Linux,...
» 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 partiesNavicat for MariaDB provides a native environment for MariaDB database management and development.
» more

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

More resources
Fauna infopreviously named FaunaDBGoogle Cloud DatastoreLovefieldMariaDB
DB-Engines blog posts

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

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

show all

Recent citations in the news

How Fauna looks to advance serverless database technology
23 November 2022, TechTarget

Built-for-purpose databases tackle new-era enterprise challenges
28 November 2022, VentureBeat

insideBIGDATA Latest News – 11/21/2022
21 November 2022, insideBIGDATA

ShellBank - New DNA toolkit and database set to disrupt the illegal marine turtle trade
24 November 2022, WWF

FaunaDB: An Introduction
8 April 2022, Built In

provided by Google News

The Seven Scariest Cloud Attack Paths - Security
15 November 2022, DevPro Journal

5 operations every cloud architect should automate
28 November 2022, InfoWorld

What Is a Customer Data Platform & Who Needs One?
26 November 2022, BizTech Magazine

Google and Oracle Cloud Servers Struggle in Heatwave
20 July 2022, Gizmodo

Crypto Analyst Explains Why Chainlink ($LINK 'Has the Potential to 50X to 100X'
26 November 2022, CryptoGlobe

provided by Google News

How to Install and Set Up MariaDB on Ubuntu 22.04 - MUO
21 November 2022, MakeUseOf

Certified Power Solutions Prepares to Plow Through Snowstorms with MariaDB SkySQL Cloud Database
15 November 2022, businesswire.com

mariadb vs. MySQL
12 September 2022, Database Journal

10 Best SQL Editor Tools in the Market
18 November 2022, Built In

MariaDB, Qlik team up to encourage migration from older databases
9 September 2022, SiliconANGLE News

provided by Google News

Job opportunities

Early-Career Natural Resources Scientist
Geosyntec Consultants, Inc., Austin, TX

Natural Resources Technician
State of Idaho, Boise, ID

Botanist - Nellis Air Force Base, Nevada
Colorado State University, Nellis AFB, NV

Researcher I
Cherokee Federal, Gainesville, FL

Fish Production Scientist I
Muckleshoot Indian Tribe, Auburn, WA

GIS Platform Datastore Manager
National Geographic Society, Remote

Data Scientist II - Product Analytics
Policygenius, New York, NY

Software Engineer
Ford Motor Company, Dearborn, MI

Staff Backend Software Engineer- Data Collection
Indigo, Remote

Data Engineer III
Policygenius, New York, NY

Call Center Representative
Etech, Dallas, TX

First Line Cloud Infrastructure
smartTrade, New York, NY

Entry Level JAVA Developer
A. Duie Pyle, Inc, West Chester, PA

System Administrator
Sapiens Software, Remote

DevOps Engineer - Remote
TradeCentric, United States

Jr. Web Developer, DC Ops & Logistics
Victoria's Secret, Reynoldsburg, OH

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Present your product here