MySQL vs. PostgreSQL vs. Cassandra

  • 1.11K
  • 8.54K
  • 554K
  • 8.36K
  • 8.46K
  • 97.3K
  • -
  • 32
  • 15.8K

What is MySQL?

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

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.
Why do developers choose MySQL?
Why do you like MySQL?

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

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

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

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?

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

What companies use MySQL?
3737 companies on StackShare use MySQL
What companies use PostgreSQL?
3275 companies on StackShare use PostgreSQL
What companies use Cassandra?
390 companies on StackShare use Cassandra
What tools integrate with MySQL?
81 tools on StackShare integrate with MySQL
What tools integrate with PostgreSQL?
93 tools on StackShare integrate with PostgreSQL
What tools integrate with Cassandra?
21 tools on StackShare integrate with Cassandra

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

  • MongoDB - The database for giant ideas
  • MariaDB - An enhanced, drop-in replacement for MySQL
  • Microsoft SQL Server - A relational database management system developed by Microsoft
  • SQLite - A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine

See all alternatives to MySQL

MariaDB 10.2.23 and MariaDB Connector/J 2.4.1 Now Av...
Obtaining an Active-Passive ProxySQL on FreeBSD
How to Perform Compatible Schema Changes in Percona ...
9.5.16
11.2
9.6.12
Cassandra Load Testing with Groovy
Using Instaclustr and Cassandra with Kong
Cassandra Query Language


Interest Over Time