Cassandra vs Heroku Postgres: What are the differences?
Cassandra: A partitioned row store. Rows are organized into tables with a required primary key. 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; Heroku Postgres: Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL. Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
Cassandra belongs to "Databases" category of the tech stack, while Heroku Postgres can be primarily classified under "PostgreSQL as a Service".
"Distributed" is the top reason why over 96 developers like Cassandra, while over 27 developers mention "Easy to setup" as the leading cause for choosing Heroku Postgres.
Cassandra is an open source tool with 5.27K GitHub stars and 2.35K GitHub forks. Here's a link to Cassandra's open source repository on GitHub.
According to the StackShare community, Cassandra has a broader approval, being mentioned in 342 company stacks & 240 developers stacks; compared to Heroku Postgres, which is listed in 74 company stacks and 39 developer stacks.