DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Google Cloud Firestore vs. Memcached vs. Microsoft SQL Server

System Properties Comparison Google Cloud Firestore vs. Memcached vs. Microsoft SQL Server

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameGoogle Cloud Firestore  Xexclude from comparisonMemcached  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparison
DescriptionCloud 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.In-memory key-value store, originally intended for cachingMicrosofts flagship relational DBMS
Primary database modelDocument storeKey-value storeRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score10.03
Rank#49  Overall
#8  Document stores
Score24.64
Rank#33  Overall
#4  Key-value stores
Score944.96
Rank#3  Overall
#3  Relational DBMS
Websitefirebase.google.com/­products/­firestorewww.memcached.orgwww.microsoft.com/­en-us/­sql-server
Technical documentationfirebase.google.com/­docs/­firestoregithub.com/­memcached/­memcached/­wikidocs.microsoft.com/­en-US/­sql/­sql-server
DeveloperGoogleDanga Interactive infooriginally developed by Brad Fitzpatrick for LiveJournalMicrosoft
Initial release201720031989
Current release1.6.15, March 2022SQL Server 2019, November 2019
License infoCommercial or Open SourcecommercialOpen Source infoBSD licensecommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud serviceyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++
Server operating systemshostedFreeBSD
Linux
OS X
Unix
Windows
Linux
Windows
Data schemeschema-freeschema-freeyes
Typing infopredefined data types such as float or dateyesnoyes
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.noyes
Secondary indexesyesnoyes
SQL infoSupport of SQLnonoyes
APIs and other access methodsAndroid
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
Proprietary protocolADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesGo
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
.Net
C
C++
ColdFusion
Erlang
Java
Lisp
Lua
OCaml
Perl
PHP
Python
Ruby
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresyes, Firebase Rules & Cloud FunctionsnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersyes, with Cloud Functionsnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingnonetables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationnone infoRepcached, a Memcached patch, provides this functionallityyes, but depending on the SQL-Server Edition
MapReduce infoOffers an API for user-defined Map/Reduce methodsUsing Cloud Dataflownono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayesnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesnoyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlAccess rights for users, groups and roles based on Google Cloud Identity and Access Management. Security Rules for 3rd party authentication using Firebase Auth.yes infousing SASL (Simple Authentication and Security Layer) protocolfine grained access rights according to SQL-standard

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
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

SQL Complete: An advanced IntelliSense-style code completion add-in for SSMS and Visual Studio. Write, beautify, refactor your SQL code and give your productivity a dramatic boost.
» more

Navicat for SQL Server gives you a fully graphical approach to 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
Google Cloud FirestoreMemcachedMicrosoft SQL Server
DB-Engines blog posts

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

show all

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

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

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

Google’s Cloud Firestore NoSQL database hits general availability
31 January 2019, TechCrunch

Google's Firebase app development platform gets updates and security boosts
11 May 2022, SiliconANGLE News

Google launches Cloud Firestore, a new document database for app developers
3 October 2017, TechCrunch

Compare Google Cloud Firestore and Firebase Realtime Database
9 August 2019, TechTarget

provided by Google News

How Pinterest Tuned Memcached for Big Performance Gains
16 May 2022, thenewstack.io

CISA Adds Zimbra Email Vulnerability to its Exploited Vulnerabilities Catalog
4 August 2022, The Hacker News

Business email platform Zimbra patches memcached injection flaw that imperils user credentials
16 June 2022, The Daily Swig

CISA: Threat actors exploiting multiple Zimbra flaws
17 August 2022, TechTarget

Google Releases Memorystore for Memcached into General Availability
9 March 2021, InfoQ.com

provided by Google News

SQL Server 2022: Here’s what you need to know
29 July 2022, TechRepublic

Datadog Extends Monitoring for Microsoft SQL Server and Microsoft Azure Database
17 August 2022, Datanami

SQL Server 2022 New Features
22 July 2022, Petri.com

Maintain Optimal SQL Server Performance
15 August 2022, Redmondmag.com

Couldn't connect to West Europe SQL Databases last week? Blame operator error
25 July 2022, The Register

provided by Google News

Job opportunities

Data Engineer
SQA Group, Remote

Software Engineer
Ink, Remote

Engineering Manager (Remote)
Andela, Boston, MA

Mobile Application Developer - Flutter
Safer School Solutions, LLC, Fort Lauderdale, FL

Full Stack Developer
Safer School Solutions, LLC, Remote

Senior .NET Engineer (Restaurant Operations)
OpenTable, New York, NY

Java Developer, Entry Level- Remote
Pure Integration - Consulting, Philadelphia, PA

Full Stack Developer
The Baltimore Banner, Baltimore, MD

Python Developer
Data Inc, Dallas, TX

Security Engineer
Notion, San Francisco, CA

SQL Server Database Administrator
VV Tech Solutions, Austin, TX

Data Base Administrator (DBA) Microsoft SQL Server
Colorado Access, Aurora, CO

SQL Server Developer
Retail Backbone, Remote

SQL Server Developer
Harvard University, Cambridge, MA

Jr. SQL Server Database Administrator
Xtivia Inc, Remote

jobs by Indeed



Share this page

Featured Products

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!

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

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

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here