PostgreSQL vs. Cassandra vs. HBase

Get help choosing one of these Get news updates about these tools


Favorites

405

Favorites

59

Favorites

13

Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 8.07K
  • 92.2K
  • -
  • 30
  • 15.3K
  • -
  • -
  • 6.29K

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 HBase?

Apache HBase is an open-source, distributed, versioned, column-oriented store modeled after Google' Bigtable: A Distributed Storage System for Structured Data by Chang et al. Just as Bigtable leverages the distributed data storage provided by the Google File System, HBase provides Bigtable-like capabilities on top of Apache Hadoop.

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

Ask a Question

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 HBase?
    Why do you like HBase?

    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 HBase?
    No Cons submitted yet for HBase
    Downsides of HBase?

    Companies

    What companies use PostgreSQL?
    2252 companies on StackShare use PostgreSQL
    What companies use Cassandra?
    295 companies on StackShare use Cassandra
    What companies use HBase?
    48 companies on StackShare use HBase

    Integrations

    What tools integrate with PostgreSQL?
    88 tools on StackShare integrate with PostgreSQL
    What tools integrate with Cassandra?
    17 tools on StackShare integrate with Cassandra
    What tools integrate with HBase?
    3 tools on StackShare integrate with HBase

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

    • 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.5.11
    9.6.7
    Cassandra Load Testing with Groovy
    Using Instaclustr and Cassandra with Kong
    Cassandra Query Language


    Interest Over Time


    Get help choosing one of these