Create entry

Postgres vs. Cassandra

Postgres Cassandra + Add column
Category
More
Description Relational Database System Second Generation Distributed Database
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
License
Operating system
Programming language
Database
Website www.​postgresql.​org cassandra.​apache.​org
Multilingual content Yes ?
Database model
Query language
Transactions Yes Yes
Unicode Yes Yes
Referential integrity Yes No
Price rating ★★★★★ ★★☆☆☆
WYSIWYG-Editor No ?
Standard compliance Yes Yes
Sharding No Yes
Replication Yes Yes
Map and reduce No Yes
Revision control Yes Yes
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Horizontal scalable Yes Yes
Integrity model
Software distribution ?
Full text search Yes No
Preference (78% global votes) (0% global votes)
Object-Relational Mapping (ORM) Yes ?
Documentation level ★★★★★ ★★★★☆
Lines of code 733 k ?
TTL for entries No Yes
Conditional entry updates Yes Yes
Composite keys Yes Yes
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes ?
Compression Yes Yes
Real time analytics Yes ?
Creation Date 1989 ?
Community Driven Good ?
Shared nothing architecture Yes Yes
Web interface Yes ?
Data encryption Yes ?
Secondary Indexes Yes Yes
Embeddable No Yes
Geospatial Indexes Yes No
Locking model
Data storage
Replication mode
Native driver
Cloud platform support ?
Online backup Yes ?
Data types
Partial Index Yes ?
Function Based Index Yes ?
Log Yes ?
Download www.​postgresql.​org/​download/​ ?
Query Cache Yes ?
Ease of use ★★★★☆ ?
In-Place Update Yes ?
Free for commercial use Yes ?
Sorts Yes ?
Tuneable write concerns Yes ?
Open Source Yes Yes
Triggers Yes ?
Perfomance ★★★★★ ?
Materialized Views Yes ?
Spring Data Support Yes ?
Geospatial Yes ?
Text Analytics Yes ?
Server Side Java Script Yes ?
JSON Yes ?
Stored Procedure Yes ?
Free edition Yes ?
SQL Queries Yes ?
Network datatype Yes ?
CLI` Yes ?
But can you use it on a cold rainy night in stoke? Yes ?
Does your boss understand it? Yes ?
Memory minimum ? 8 GB
Value size max. ? 2 GB
Graph support ? Yes
+ Add row ++
Postgres Cassandra
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    darker
    = better
    Legend
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.

Type
Review
Comment