MySQL vs. SQLite vs. Cassandra

  • 1.11K
  • 8.55K
  • 554K
  • 3.74K
  • 10.1K
  • 65.3K
  • -
  • 32
  • 15.8K
No public GitHub repository stats available

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

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

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!

Why do developers choose MySQL?
Why do you like MySQL?

Why do developers choose SQLite?
Why do you like SQLite?

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 SQLite?
Downsides of SQLite?

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

What companies use MySQL?
3730 companies on StackShare use MySQL
What companies use SQLite?
409 companies on StackShare use SQLite
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 SQLite?
16 tools on StackShare integrate with SQLite
What tools integrate with Cassandra?
21 tools on StackShare integrate with Cassandra

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

  • PostgreSQL - A powerful, open source object-relational database system
  • 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

See all alternatives to MySQL

Tungsten Clustering 6.0.5 and Tungsten Replicator 6....
How to Run and Configure ProxySQL 2.0 for MySQL Gale...
Django Authentication with a MySQL Database— Login, ...
orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite
Cassandra Load Testing with Groovy
Using Instaclustr and Cassandra with Kong
Cassandra Query Language


Interest Over Time