SQLite vs. Cassandra vs. ClustrixDB



Hacker News, Reddit, Stack Overflow Stats

  • 3.74K
  • 10.1K
  • 64K
  • -
  • 32
  • 15.4K
  • 224
  • 31
  • 0

GitHub Stats

No public GitHub repository stats available
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 ClustrixDB?

ClustrixDB is a scale-out SQL database built from the ground up with a distributed shared nothing architecture, automatic data redistribution (so you never need to shard), with built in fault tolerance, all accessible by a simple SQL interface and support for business critical MySQL features – replication, triggers, stored routines, etc.

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

Ask a Question

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

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

Pricing

How much does SQLite cost?
How much does Cassandra cost?
How much does ClustrixDB cost?

Companies

What companies use SQLite?
374 companies on StackShare use SQLite
What companies use Cassandra?
369 companies on StackShare use Cassandra
What companies use ClustrixDB?
0 companies on StackShare use ClustrixDB

Integrations

What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite
What tools integrate with Cassandra?
19 tools on StackShare integrate with Cassandra
No integrations listed yet

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

  • 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
Cassandra Load Testing with Groovy
Using Instaclustr and Cassandra with Kong
Cassandra Query Language


Interest Over Time


Get help choosing one of these