DB-EnginesInstaclustr banner English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT
AWS Marketplace

DBMS > Microsoft SQL Server vs. MongoDB vs. MySQL vs. Percona Server vs. PostgreSQL

System Properties Comparison Microsoft SQL Server vs. MongoDB vs. MySQL vs. Percona Server vs. PostgreSQL

Editorial information provided by DB-Engines
NameMicrosoft SQL Server  Xexclude from comparisonMongoDB  Xexclude from comparisonMySQL  Xexclude from comparisonPercona Server  Xexclude from comparisonPostgreSQL  Xexclude from comparison
DescriptionMicrosofts relational DBMSOne of the most popular document storesWidely used open source RDBMSEnhanced drop-in replacement for MySQL based on XtraDB or TokuDB storage engines with improved performance and additional diagnostic and management features.Based on the object relational DBMS Postgres infoDeveloped as objectoriented DBMS, gradually enhanced with 'standards' like SQL
Primary database modelRelational DBMSDocument storeRelational DBMS infoKey/Value like access via memcached APIRelational DBMSRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.
Additional database modelsDocument store
Key-value store
Document store
Key-value store
Key-value storeDocument store
Key-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1212.54
Rank#3  Overall
#3  Relational DBMS
Score332.73
Rank#5  Overall
#5  Document stores
Score1312.61
Rank#2  Overall
#2  Relational DBMS
Score2.11
Rank#95  Overall
#47  Relational DBMS
Score372.36
Rank#4  Overall
#4  Relational DBMS
Websitewww.microsoft.com/­en-us/­sql-serverwww.mongodb.comwww.mysql.comwww.percona.com/­software/­mysql-database/­percona-serverwww.postgresql.org
Technical documentationdocs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentationdocs.mongodb.com/­manualdev.mysql.com/­docwww.percona.com/­docs/­wiki/­start.htmlwww.postgresql.org/­docs/­manuals
Purchase software

Buy it now at Amazon Webservices Marketplace

Buy it now at Amazon Webservices Marketplace

MongoDB: MongoDB Atlas
Jetware: MongoDB 3.4

Buy it now at Amazon Webservices Marketplace

Buy it now at Amazon Webservices Marketplace

EnterpriseDB Corporation: Postgres Plus Cloud Database Basic (HVM)
DeveloperMicrosoftMongoDB, IncOracle infosince 2010, originally MySQL AB, then SunPerconaPostgreSQL Global Development Group infowww.postgresql.org/­developer
Initial release19892009199520081989 info1989: Postgres, 1996: PostgreSQL
Current releaseSQL Server 2016, June 20163.4.9, September 20175.7.19, July 20175.7.19-17, August 20179.6.5, August 2017
License infoCommercial or Open Sourcecommercial inforestricted free version is availableOpen Source infoAGPL version 3, commercial license availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infoGPL version 2Open Source infoBSD
Cloud-based infoOnly available as a cloud servicenonononono
Implementation languageC++C++C and C++C and C++C
Server operating systemsWindowsLinux
OS X
Solaris
Windows
FreeBSD
Linux
OS X
Solaris
Windows
LinuxFreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Data schemeyesschema-free infoAlthough schema-free, documents of the same collection often follow the same structureyesyesyes
Typing infopredefined data types such as float or dateyesyes infostring, integer, double, boolean, date, object_idyesyesyes
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.yesyesyes infospecific XML-type available, but no XML query functionality.
Secondary indexesyesyesyesyesyes
SQL infoSupport of (almost entire) SQL standard (DML, DDL and DCL statements)yesnoyes infowith proprietary extensionsyesyes infostandard with numerous extensions
APIs and other access methodsOLE DB
Tabular Data Stream (TDS)
ADO.NET
JDBC
ODBC
proprietary protocol using JSONADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
native C library
streaming API for large objects
ADO.NET
JDBC
ODBC
Supported programming languagesC++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Actionscript infoinofficial driver
C
C#
C++
Clojure infoinofficial driver
ColdFusion infoinofficial driver
D infoinofficial driver
Dart infoinofficial driver
Delphi infoinofficial driver
Erlang
Go infoinofficial driver
Groovy infoinofficial driver
Haskell
Java
JavaScript
Lisp infoinofficial driver
Lua infoinofficial driver
MatLab infoinofficial driver
Perl
PHP
PowerShell infoinofficial driver
Prolog infoinofficial driver
Python
R infoinofficial driver
Ruby
Scala
Smalltalk infoinofficial driver
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Ada
C
C#
C++
D
Eiffel
Erlang
Haskell
Java
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
C
C++
Delphi
Java infoJDBC
Perl
PHP
Python
Tcl
Server-side scripts infoStored proceduresTransact SQL and .NET languagesJavaScriptyes infoproprietary syntaxyesuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.
Triggersyesnoyesyesyes
Partitioning methods infoMethods for storing different data on different nodestables can be distributed across several files (horizontal partitioning); sharding through federationShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricno, but can be realized using table inheritance infofor each partition a subtable, inserts are controlled with triggers
Replication methods infoMethods for redundantly storing data on multiple nodesyes, but depending on the SQL-Server EditionMaster-slave replicationMaster-master replication
Master-slave replication
Master-master replication
Master-slave replication
XtraDB Cluster
Master-slave replication infoother methods possible by using 3rd party extensions
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency infocan be individually decided for each write operation
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesno infotypically not used, however similar functionality with DBRef possibleyes infonot for MyISAM storage engineyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoatomic operations within a single document possibleACID infonot for MyISAM storage engineACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infotable locks or row locks depending on storage engineyesyes
Durability infoSupport for making data persistentyesyes infooptionalyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoIn-memory storage engine introduced with MongoDB version 3.2yesno
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and rolesUsers with fine-grained authorization concept infono user groups or rolesUsers with fine-grained authorization concept infono user groups or rolesfine grained access rights according to SQL-standard
More information provided by the system vendor
Microsoft SQL ServerMongoDBMySQLPercona ServerPostgreSQL
Specific characteristicsMongoDB is the next-generation database that helps businesses transform their industries...
» more
Competitive advantagesBy offering the best of traditional databases as well as the flexibility, scale,...
» more
Typical application scenariosInternet of Things (Bosch, Silver Spring Networks) Mobile (The Weather Channel, ADP,...
» more
Key customersADP, Adobe, AstraZeneca, BBVA, Bosch, Cisco, CERN, Department of Veteran Affairs,...
» more
Market metrics20 million downloads (growing at thousands downloads per day). 2,000+ customers including...
» more
Licensing and pricing modelsMongoDB database server: Free Software Foundation’s GNU AGPL v3.0. Commercial licenses...
» 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.

3rd party products and services
3rd partiesDevart: Any SQL Server Tool you Need
» more

Progress DataDirect: Data connectivity across standard SQL and REST
» more
Studio 3T: The world's favorite IDE for working with MongoDB
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Progress DataDirect: Data connectivity across standard SQL and REST
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

MONYOG: Monitor standard & hosted MySQL database servers.
» more
Progress DataDirect: Data connectivity across standard SQL and REST
» more

We invite representatives of 3rd party vendors to contact us for presenting information about their offerings here.

More resources
Microsoft SQL ServerMongoDBMySQLPercona ServerPostgreSQL
DB-Engines blog posts

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

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

PostgreSQL moves up one rank at the expense of MongoDB
1 September 2016, Paul Andlinger

Oracle is the DBMS of the Year
5 January 2016, Paul Andlinger, Matthias Gelbmann

Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
2 November 2015, Paul Andlinger

show all

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

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

MySQL won the April ranking; did its forks follow?
1 April 2015, Paul Andlinger

Has MySQL finally lost its mojo?
1 July 2013, Matthias Gelbmann

show all

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

PostgreSQL moves up one rank at the expense of MongoDB
1 September 2016, Paul Andlinger

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Conferences and events

PASS Summit 2017
Seattle, Washington, USA, 31 October 2017 - 3 November 2017

MongoDB Europe 2017
London, United Kingdom, 8 November 2017

Percona Live Europe
Dublin, Ireland, 25-27 September 2017

Recent citations in the news

Best Practices for SQL Server Backup and Disaster Recovery
19 September 2017, SQL Server Pro

How to choose the right SQL Server on Azure deployment option
15 September 2017, TechTarget

Network Configuration of SQL Server Always On Availability Groups in Azure
4 September 2017, Database Journal

PowerShell for SQL Server Including SQL 2016: Automation. The new must have SQL skill! – Book
19 September 2017, DABCC.com

Microsoft launches data security technology for Windows Server, Azure
19 September 2017, Network World

provided by Google News

Southbank Software Introduces dbKoda, an Open Source Database Development Tool for MongoDB
13 September 2017, InfoQ.com

MongoDB ransacking starts again: Hackers ransom 26,000 ... - ZDNet
5 September 2017, ZDNet

MongoDB Installations Held Ransom Again - Infosecurity Magazine
6 September 2017, Infosecurity Magazine

Ticketing Giant Ticketek Migrates To MongoDB Atlas to Improve ...
5 September 2017, PR Newswire (press release)

Uptick in MongoDB Attacks up to 26,000 Asking for Ransomware
7 September 2017, CoinTelegraph

provided by Google News

Creating a simple cms with php and mysql
19 September 2017, SitePoint

Quest Software Releases New Platform to Tackle MySQL Open Source Environments
23 August 2017, Database Trends and Applications

Smart HMIs (from Maple Systems) now with MySQL database connectivity
14 September 2017, Design World Network

What you can get with Oracle MySQL Cloud Service
22 August 2017, TechTarget

How to add leading 0's in mysql?
13 September 2017, SitePoint

provided by Google News

VMware: The date is set, and replication has started
18 September 2017, DABCC.com

Learn details of the server management software market analysis
13 September 2017, WhaTech

Server Management Software Market Set for Rapid Growth and Trend by 2022
6 September 2017, satPRnews (press release)

Sizing Up Servers: Intel's Skylake-SP Xeon versus AMD's EPYC 7000 - The Server CPU Battle of the Decade?
13 July 2017, AnandTech

Critical MySQL Vulnerabilities Can Lead to Server Compromise
2 November 2016, Threatpost

provided by Google News

MyDiamo Expands Open Source Database Encryption Offerings to ...
19 September 2017, Markets Insider

VividCortex Announces Expanded PostgreSQL Performance ...
5 September 2017, PR Web (press release)

Crunchy Data Automates Security Compliance with DISA Security ...
22 August 2017, Benzinga

ClearDATA Expands AWS Service Delivery Portfolio - PR Newswire
22 August 2017, PR Newswire (press release)

2ndQuadrant Announces the Release of OmniDB: Lightweight and ...
22 August 2017, PR Newswire (press release)

provided by Google News

Job opportunities

Junior SQL Developer (remote)
Data Services Partners, Mission Viejo, CA

SQL Developer
Cybage Software Pvt. Ltd, Redmond, WA

Database Engineer
Concordis, Seattle, WA

SQL Architect
Pactera, Redmond, WA

T-SQL Analyst
Revenue Solutions, Inc., Harrisburg, PA

Senior DevOps Engineer/Automation Developer
Technologent, Las Vegas, NV

Java Springs - Software Engineer
APN Software Services Inc., Glen Allen, VA

Sr. Android Developer
MW Partners, Culver City, CA

Senior Automation Testers with PostGre and MongoDB
Radyant INC, Santa Clara, CA

Junior Java Software Engineer (AMRD2013)
Fortinet, Sunnyvale, CA

Report Data Engineer
Digicel, San Jose, CA

Systems Automation Engineer
Amazon Web Services, Inc., Herndon, VA

Junior Windows Administrator
Truno Retail Technology Solutions, Lubbock, TX

SR Software Developer / Tech Lead
Auzmor, Clive, IA

Linux Support Engineer
Amazon Web Services, Inc., Herndon, VA

MySQL Database Administrator
Karsun Solutions LLC, Herndon, VA

Senior Database Engineer
BigCommerce, San Francisco, CA

Sr. Systems Engineer
International Rescue Committee, New York, NY

MySQL Database Engineer
Bloomberg, New York, NY

Sr. MySQL DBA
IPsoft, New York, NY

Devops/Linux Admin
tanisha systems inc, Atlanta, GA

Software Developer-Django
US News & World Report, Washington, DC

Senior Node.js Developer
PSI Pax, Baltimore, MD

RESEARCH SCIENTIST ASSISTANT
University of Washington, Seattle, WA

Entry-Level Application Developer
Equifax, Atlanta, GA

jobs by Indeed




Share this page

Featured Products

Datastax logo

Datastax delivers Apache Cassandra as part of a database platform purpose built for IOT, Web and Mobile Apps. Download now.

Neo4j logo

Learn how to use Neo4j alongside Oracle RDBMS
for increased query speeds
& application performance.
Read the white paper.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

AllegroGraph logo

Semantic Graph Database Leader - Add The Power of Cognitive Probability Graphs - Unique Graph Visualizations - Free Download

Present your product here