MySQL vs. SQLite vs. Riak

Get help choosing one of these



Hacker News, Reddit, Stack Overflow Stats

  • 1.11K
  • 8.54K
  • 543K
  • 3.74K
  • 10.1K
  • 64K
  • 1.45K
  • 553
  • 764

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

Riak is a distributed database designed to deliver maximum data availability by distributing data across multiple servers. As long as your client can reach one Riak server, it should be able to write data. In most failure scenarios, the data you want to read should be available, although it may not be the most up-to-date version of that data.

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 SQLite?
Why do you like SQLite?

Why do developers choose Riak?
Why do you like Riak?

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

Companies

What companies use MySQL?
3503 companies on StackShare use MySQL
What companies use SQLite?
374 companies on StackShare use SQLite
What companies use Riak?
18 companies on StackShare use Riak

Integrations

What tools integrate with MySQL?
76 tools on StackShare integrate with MySQL
What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite
What tools integrate with Riak?
4 tools on StackShare integrate with Riak

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

  • 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
Scaling Riak and Solr for Marketing Campaigns
How to Back Up Riak and Solr Data


Interest Over Time


Get help choosing one of these