1. CouchDB :
2. PostgreSQL :
PostgreSQL is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability. PostgreSQL was the first DBMS that implemented multi-version concurrency control (MVCC) feature.
Difference between CouchDB and PostgreSQL :
|1.||Developed by Apache Software Foundation and initially released in 2005.||Developed By PostgreSQL Global Development Group on 1989.|
|2.||It is native JSON – document store inspired by Lotus Notes, scalable from globally distributed server-clusters down to mobile phones.||It is widely used open source RDBMS.|
|3.||CouchDB is written in Erlang.||PostgreSQL is written in C languages.|
|4.||The primary database model for CouchDB is Document Store.||The primary database model for PostgreSQL is Relational DBMS.|
|5.||It does not supports SQL query language.||It supports SQL query language.|
|6.||Server operating systems for CouchDB are Android, BSD, Linux, OS X, Solaris and Windows.||Server operating systems for PostgreSQL are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows.|
|7.||It does not supports predefined data types.||It supports predefined data types such as string, integer, float or date.|
|8.||It does not support XML Format.||It supports XML Format.|
|9.||It support two replication methods – Master-master replication and Master-slave replication.||It support only one replication methods – Master-master replication.|
|10.||In CouchDB, partitioning can be done by Sharding.||In PostgreSQL, partitioning can be done by range, list and hash.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.