SQLite vs. Cassandra vs. Citus

Get help choosing one of these Get news updates about these tools


SQLite

Cassandra

Citus

Favorites

67

Favorites

54

Favorites

2

Hacker News, Reddit, Stack Overflow Stats

  • 3.74K
  • 5.67K
  • 61.2K
  • -
  • 24
  • 14.4K
  • 3.65K
  • 1.84K
  • 37

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

Pros about this tool

Why do you like SQLite?

Why do you like Cassandra?

Why do you like Citus?

Cons about this tool

Customers

Integrations

Latest News

orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite
Using Instaclustr and Cassandra with Kong
Cassandra Query Language
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


Get help choosing one of these