SQLite vs. Cassandra vs. RethinkDB



Hacker News, Reddit, Stack Overflow Stats

  • 3.74K
  • 10.1K
  • 64.8K
  • -
  • 32
  • 15.7K
  • 5.12K
  • 1.34K
  • 1.37K

GitHub Stats

No public GitHub repository stats available

Description

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.

What is RethinkDB?

RethinkDB is built to store JSON documents, and scale to multiple machines with very little effort. It has a pleasant query language that supports really useful queries like table joins and group by, and is easy to setup and learn.

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

Pros

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

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

Why do developers choose RethinkDB?
Why do you like RethinkDB?

Cons

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

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

What are the cons of using RethinkDB?
No Cons submitted yet for RethinkDB
Downsides of RethinkDB?

Companies

What companies use SQLite?
400 companies on StackShare use SQLite
What companies use Cassandra?
384 companies on StackShare use Cassandra
What companies use RethinkDB?
51 companies on StackShare use RethinkDB

Integrations

What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite
What tools integrate with Cassandra?
21 tools on StackShare integrate with Cassandra
What tools integrate with RethinkDB?
3 tools on StackShare integrate with RethinkDB

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

  • MySQL - The world's most popular open source database
  • PostgreSQL - A powerful, open source object-relational database system
  • MongoDB - The database for giant ideas
  • MariaDB - An enhanced, drop-in replacement for MySQL

See all alternatives to SQLite

Latest News

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
The liberation of RethinkDB


Interest Over Time