MySQL vs. SQLite vs. RocksDB



Hacker News, Reddit, Stack Overflow Stats

  • 1.11K
  • 8.53K
  • 547K
  • 3.74K
  • 10.1K
  • 64.4K
  • 326
  • 30
  • 163

GitHub Stats

No public GitHub repository stats available

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

RocksDB is an embeddable persistent key-value store for fast storage. RocksDB can also be the foundation for a client-server database but our current focus is on embedded workloads. RocksDB builds on LevelDB to be scalable to run on servers with many CPU cores, to efficiently use fast storage, to support IO-bound, in-memory and write-once workloads, and to be flexible to allow for innovation.

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

Pros

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

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

Why do developers choose RocksDB?
Why do you like RocksDB?

Cons

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

Companies

What companies use MySQL?
3586 companies on StackShare use MySQL
What companies use SQLite?
386 companies on StackShare use SQLite
What companies use RocksDB?
9 companies on StackShare use RocksDB

Integrations

What tools integrate with MySQL?
77 tools on StackShare integrate with MySQL
What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite
No integrations listed yet

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

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

Latest News

MySQL @ FOSSASIA, 2018
Using dbdeployer in CI tests
Archiving MySQL Tables in ClickHouse
orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite
All things RocksDB at Percona Live Europe 2017


Interest Over Time