SQLite vs. RethinkDB vs. Citus



Hacker News, Reddit, Stack Overflow Stats

  • 3.74K
  • 10.1K
  • 64.4K
  • 5.12K
  • 1.34K
  • 1.36K
  • 3.65K
  • 2.87K
  • 40

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 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.

What is Citus?

Citus is worry-free Postgres for SaaS. Made to scale out, Citus is an extension to Postgres that distributes queries across any number of servers. Citus is available as open source, as on-prem software, and as a fully-managed service.

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

Why do developers choose Citus?
Why do you like Citus?

Cons

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

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

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

Pricing

How much does SQLite cost?
How much does RethinkDB cost?
How much does Citus cost?
Citus Pricing

Companies

What companies use SQLite?
386 companies on StackShare use SQLite
What companies use RethinkDB?
51 companies on StackShare use RethinkDB
What companies use Citus?
15 companies on StackShare use Citus

Integrations

What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite
What tools integrate with RethinkDB?
3 tools on StackShare integrate with RethinkDB
What tools integrate with Citus?
14 tools on StackShare integrate with Citus

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

  • MySQL - The world's most popular open source database
  • 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

See all alternatives to SQLite

Latest News

orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite
The liberation of RethinkDB
How the Citus distributed database rebalances your data
Citus 7.2: Distributed Postgres w/ CTEs, complex sub...
Citus and pg_partman: Creating a scalable time serie...


Interest Over Time