1. Cassandra :
Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system. It was developed by Apache Software foundation and initially released on July 2008. Cassandra is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.
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 Cassandra and PostgreSQL :
|1.||Developed by Apache Software foundation and released on July 2008.||Developed By PostgreSQL Global Development Group on 1989.|
|2.||It is wide-column store based on ideas of BigTable and DynamoDB.||It is widely used open source RDBMS.|
|3.||Cassandra is written in Java languages.||PostgreSQL is written in C languages.|
|4.||The primary database model for Cassandra is Wide column store.||The primary database model for PostgreSQL is Relational DBMS.|
|5.||It has no Secondary database models.||It has Document store as Secondary database models.|
|6.||Server operating systems for Cassandra are BSD, Linux, OS X and Windows.||Server operating systems for PostgreSQL are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows.|
|7.||It does not support XML format.||It supports XML format.|
|8.||It supports Secondary indexing but in a restricted way, i.e., only equality queries, not always the best performing solution.||It supports Secondary indexing.|
|9.||It does not supports Server-side scripting.||It has user defined functions for Server-side scripts.|
|10.||It supports selectable replication factor method.||It supports Master-master replication method.|
|11.||In Cassandra, partitioning can be done Sharding.||In PostgreSQL, partitioning can be done by range, list and hash.|
|12.||It offers an API for user-defined Map/Reduce methods.||It does not offers an API for user-defined Map/Reduce method.|
|13.||Cassandra does not provides the concept of Referential Integrity. Hence, no Foreign Keys.||PostgreSQL provides the concept of Referential Integrity and have Foreign keys.|
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.
- Difference between SQLite and Cassandra
- Difference between Cassandra and CouchDB
- Difference Between Hadoop and Cassandra
- Difference between Cassandra and MySQL
- Difference between Cassandra and MongoDB
- Difference between Cassandra and MariaDB
- Difference between MS SQL Server and Cassandra
- Difference between Cassandra and Couchbase
- Difference between Cassandra and IBM Db2
- Difference between PouchDB and Cassandra
- Difference between HBase and Cassandra
- Difference between Derby and Cassandra
- Difference between Oracle and Cassandra
- Difference between Cassandra and Redis
- Difference between Teradata and Cassandra
- Difference between Neo4j and Cassandra
- Difference between Hive and Cassandra
- Difference between Firebase and Cassandra
- Difference between PouchDB and PostgreSQL
- Difference between MySQL and PostgreSQL
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.