In our previous articles we provide detailed descriptions along with pros and cons of some of the most popular and widely used database management systems. We discussed, MYSQL, MS SQL Server, MongoDB and Postgres DB. In this article we are going to present comparison of these four famous database systems in tabular. Readers can view the comparison matrix and decide what type of Database Management System suffices their database application development needs.
Postgres
MySQL
MongoDB
MS SQL SERVER
Database Type
Object Relational Database Model
RDBS, widely used in LAMP suit.
JSON Type Database schema instead of traditional SQL based queries.
Microsoft’s proprietary DBMS
Developed By
Postgre SQL Global Development Group
Oracle
MongoDB Inc
Microsoft
License Type
Open source
Open source
Open source
Commercial
First Release
1989
1995
2009
1989
Programmed in
C
C and C++
C++
C++
Database Model
Relational
Relational
Document Store
Relational
Query Mechanism
SQL Based
JSON Type Query Mechanism (NoSQL)
SQL Based
SQL Based
Concurrent Processing
Allows Concurrent Processing
Allows Concurrent Processing
Allows Concurrent Processing
Allows Concurrent Processing
Server Side Scripting
User Defined Functionalities
Allows Server side scripting
JavaScript Scripting language
.NET Languages and Transact SQL
Replication Topologies
Master-Slave Topology
Master-Master,
Master-Slave,
MySQL Cluster Topology
Master-Slave Topology
Dependent on database edition
Language Support
Perl, Python, Tcl, .Net, C, C++
Java
Ada, C, C#, C++, D, Java
Objective-C,
OCaml, Perl, Eiffel, Erlang, Haskell
PowerShell, Prolog, Python, PHP, Perl, Ruby, Smattalk, Scala, Matlab, Lua, Lisp, JavaScript, Java, Go, Groovy, Heskell, C++, C#, ColdFusion, Clojure, Erlang, Dart, Delphi,  C, ActionScript  
.NET, Java, Python, PHP, Visual Basic, Ruby
Portioning Mechanism
Not Supported but Table Inheritance can be used to achieve the purpose.
MySQL Cluster based horizontal partitioning
Sharding Partitioning
Horizontal Partitioning with table spanning several files but no sharding

Comparison Matrix for popular DBMS
Conclusion
All the four major databases have been compared on the basis of several attributes in the comparison matrix. It is now up to the programmer to choose the database system that suits the application being developed.