PostgreSQL vs. Cassandra vs. RocksDB



Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 8.16K
  • 93.5K
  • -
  • 32
  • 15.4K
  • 326
  • 30
  • 155

GitHub Stats

Description

What is PostgreSQL?

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

What is Cassandra?

Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.

What is RocksDB?

RocksDB is an embeddable persistent key-value store for fast storage. RocksDB can also be the foundation for a client-server database but our current focus is on embedded workloads. RocksDB builds on LevelDB to be scalable to run on servers with many CPU cores, to efficiently use fast storage, to support IO-bound, in-memory and write-once workloads, and to be flexible to allow for innovation.

Want advice about which of these to choose?Ask the StackShare community!

Pros

Why do developers choose PostgreSQL?
Why do you like PostgreSQL?

Why do developers choose Cassandra?
Why do you like Cassandra?

Why do developers choose RocksDB?
Why do you like RocksDB?

Cons

What are the cons of using PostgreSQL?
No Cons submitted yet for PostgreSQL
Downsides of PostgreSQL?

What are the cons of using Cassandra?
Downsides of Cassandra?

What are the cons of using RocksDB?
No Cons submitted yet for RocksDB
Downsides of RocksDB?

Companies

What companies use PostgreSQL?
3026 companies on StackShare use PostgreSQL
What companies use Cassandra?
369 companies on StackShare use Cassandra
What companies use RocksDB?
8 companies on StackShare use RocksDB

Integrations

What tools integrate with PostgreSQL?
87 tools on StackShare integrate with PostgreSQL
What tools integrate with Cassandra?
19 tools on StackShare integrate with Cassandra
No integrations listed yet

What are some alternatives to PostgreSQL, Cassandra, and RocksDB?

  • MySQL - The world's most popular open source database
  • MongoDB - The database for giant ideas
  • Microsoft SQL Server - A relational database management system developed by Microsoft
  • MariaDB - An enhanced, drop-in replacement for MySQL

See all alternatives to PostgreSQL

Latest News

PostgreSQL rocks, except when it blocks: Understandi...
9.4.16
9.5.11
Cassandra Load Testing with Groovy
Using Instaclustr and Cassandra with Kong
Cassandra Query Language
All things RocksDB at Percona Live Europe 2017


Interest Over Time


Get help choosing one of these