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. Ingres vs. Lovefield vs. Microsoft Azure Search

System Properties Comparison Fauna vs. Google Cloud Datastore vs. Ingres vs. Lovefield vs. Microsoft Azure Search

Editorial information provided by DB-Engines
NameFauna infopreviously named FaunaDB  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparisonIngres  Xexclude from comparisonLovefield  Xexclude from comparisonMicrosoft Azure Search  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 PlatformWell established RDBMSEmbeddable relational database for web apps written in pure JavaScriptSearch-as-a-service for web and mobile app development
Primary database modelDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Document storeRelational DBMSRelational DBMSSearch engine
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.70
Rank#146  Overall
#25  Document stores
#11  Graph DBMS
#71  Relational DBMS
#11  Time Series DBMS
Score6.94
Rank#63  Overall
#11  Document stores
Score5.75
Rank#74  Overall
#39  Relational DBMS
Score0.38
Rank#279  Overall
#129  Relational DBMS
Score7.39
Rank#61  Overall
#7  Search engines
Websitefauna.comcloud.google.com/­datastorewww.actian.com/­data-management/­ingres-sql-rdbmsgoogle.github.io/­lovefieldazure.microsoft.com/­en-us/­services/­search
Technical documentationdocs.fauna.comcloud.google.com/­datastore/­docsdocs.actian.com/­ingresgithub.com/­google/­lovefield/­blob/­master/­docs/­spec_index.mddocs.microsoft.com/­en-us/­azure/­search
DeveloperFauna, Inc.GoogleActian CorporationGoogleMicrosoft
Initial release201420081974 infooriginally developed at University Berkely in early 1970s20142015
Current release11.0, April 20172.1.12, February 2017V1
License infoCommercial or Open SourcecommercialcommercialcommercialOpen Source infoApache 2.0commercial
Cloud-based only infoOnly available as a cloud serviceyesyesnonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageScalaCJavaScript
Server operating systemshostedhostedAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
server-less, requires a JavaScript environment (browser, Node.js) infotested with Chrome, Firefox, IE, Safarihosted
Data schemeschema-freeschema-freeyesyesyes
Typing infopredefined data types such as float or datenoyes, details hereyesyesyes
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 infobut tools for importing/exporting data from/to XML-files availablenono
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLnoSQL-like query language (GQL)yesSQL-like query language infovia JavaScript builder patternno
APIs and other access methodsRESTful HTTP APIgRPC (using protocol buffers) API
RESTful HTTP/JSON API
.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
RESTful HTTP API
Supported programming languagesC#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
JavaScript.Net
C#
Server-side scripts infoStored proceduresuser defined functionsusing Google App Engineyesnono
TriggersnoCallbacks using the Google Apps EngineyesUsing read-only observersno
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoconsistent hashingShardinghorizontal partitioning infoIngres Star to access multiple databases simultaneouslynoneSharding infoImplicit feature of the cloud service
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationMulti-source replication using PaxosIngres Replicatornoneyes infoImplicit feature of the cloud service
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infousing Google Cloud Dataflownonono
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 ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyes infovia ReferenceProperties or Ancestor pathsyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infoSerializable Isolation within Transactions, Read Committed outside of TransactionsACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoMVCCyesyes
Durability infoSupport for making data persistentyesyesyesyes, by using IndexedDB or the cloud service Firebase Realtime Databaseyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyes infousing MemoryDBno
User concepts infoAccess controlIdentity management, authentication, and access controlAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)fine grained access rights according to SQL-standardnoyes infousing Azure authentication

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 FaunaDBGoogle Cloud DatastoreIngresLovefieldMicrosoft Azure Search
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

show all

Recent citations in the news

FaunaDB: An Introduction
8 April 2022, Built In

Fauna Adds Industry's First Real Time Streaming to its Serverless-Native Database
8 March 2022, Business Wire

Fauna Aims to Simplify Data Management for Developers
27 May 2022, thenewstack.io

Fauna Transactional Database Introduces Event Streaming
3 April 2022, InfoQ.com

CaliPopGen: A genetic and life history database for the fauna and flora of California | Scientific Data
5 July 2022, Nature.com

provided by Google News

Dig scoops up $34M to tackle the fragmented world of cloud data security
14 September 2022, TechCrunch

Oracle pays $23M to settle SEC bribery probe
27 September 2022, FierceTelecom

Healthcare interoperability and industry cloud: What to look for
1 September 2022, CIO

It's So Hot the Clouds Are Melting
20 July 2022, Gizmodo

VMware trots multi-cloud management, enhanced edge compute stack
30 August 2022, FierceTelecom

provided by Google News

Open source databases: What are they and why do they matter?
5 September 2022, The Register

Actian’s plan for the AI era
27 May 2022, Protocol

Actian Launches Ingres as a Fully-Managed Cloud Service
24 September 2021, Integration Developers

Actian Unveils Ingres NeXt Initiative at Actian Hybrid Data Conference 2021
25 May 2021, Business Wire

Neon nabs $30M to build a scalable cloud service for Postgres databases
26 July 2022, TechCrunch

provided by Google News

Google Lovefield Relational Query Engine
21 November 2014, iProgrammer

provided by Google News

Azure Virtual Desktop setup tutorial
22 December 2021, TechTarget

What is Microsoft Azure and How it works, Azure Cloud Services, Demystifying Cloud Series by Satyen Kumar
16 June 2022, satyenkumar.medium.com

Writing Simple REST Clients for Azure Search
20 July 2016, DZone

Microsoft announces the availability of Azure Search in UK
27 February 2017, MSPoweruser

What is Azure Purview? A look at its key features and benefits
26 April 2021, TechGenix

provided by Google News

Job opportunities

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

Planner III (20287838)
MROSD, Los Altos, CA

Fish Biologist
US Geological Survey, Kearneysville, WV

Senior Developer
Leasecake, Winter Park, FL

Interpretive Student Aide II
East Bay Regional Park District, Oakland, CA

Staff Software Engineer
Indeed, New York, NY

Staff Software Engineer
Indeed, United States

Staff Software Engineer
Indeed, Seattle, WA

Software Engineer I
Principal Financial Group, Des Moines, IA

Staff Software Engineer
Indeed, Austin, TX

Database Developer
COMPQSOFT, Elizabeth City, NC

Intelligence Analyst
CACI, Dahlgren, VA

Systems Analyst
Teradyne Infotech, Farmington Hills, MI

SOFTWARE ENGINEER
University of Washington, Seattle, WA

Database Specialist
McCall Communications Consulting LLC, Elizabeth City, NC

Call Center Representative/Sales
Etech, Dallas, TX

Pre-K Teacher (Montessori)
Willow Montessori Academy, Dallas, TX

Azure Cloud Application Architect
Nebraska Furniture Mart, Omaha, NE

Azure Cloud Application Architect
Nebraska Furniture Mart, Remote

Software Engineer 2
Microsoft, Redmond, WA

Data Engineer (Remote)
JLL, Chicago, IL

Sr. Software Engineer
Tek Ninjas, Chicago, IL

jobs by Indeed



Share this page

Featured Products

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.

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now 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!

Present your product here