MySQL vs. PostgreSQL vs. Cassandra

Get help choosing one of these



Hacker News, Reddit, Stack Overflow Stats

  • 1.11K
  • 8.42K
  • 543K
  • 8.36K
  • 8.16K
  • 93.1K
  • -
  • 30
  • 15.4K

GitHub Stats

Description

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.

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

Ask a Question

Pros

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?

    Cons

    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?

    Companies

    What companies use MySQL?
    2621 companies on StackShare use MySQL
    What companies use PostgreSQL?
    2299 companies on StackShare use PostgreSQL
    What companies use Cassandra?
    300 companies on StackShare use Cassandra

    Integrations

    What tools integrate with MySQL?
    76 tools on StackShare integrate with MySQL
    What tools integrate with PostgreSQL?
    87 tools on StackShare integrate with PostgreSQL
    What tools integrate with Cassandra?
    19 tools on StackShare integrate with Cassandra

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

    • 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
    • SQLite - A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine

    See all alternatives to MySQL

    Latest News

    MySQL @ FOSSASIA, 2018
    Using dbdeployer in CI tests
    Archiving MySQL Tables in ClickHouse
    PostgreSQL rocks, except when it blocks: Understandi...
    9.3.21
    9.5.11
    Cassandra Load Testing with Groovy
    Using Instaclustr and Cassandra with Kong
    Cassandra Query Language


    Interest Over Time


    Get help choosing one of these