SQLite vs. Cassandra vs. HBase

Get help choosing one of these



Hacker News, Reddit, Stack Overflow Stats

  • 3.74K
  • 10.1K
  • 64K
  • -
  • 33
  • 15.4K
  • -
  • -
  • 6.31K

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

Apache HBase is an open-source, distributed, versioned, column-oriented store modeled after Google' Bigtable: A Distributed Storage System for Structured Data by Chang et al. Just as Bigtable leverages the distributed data storage provided by the Google File System, HBase provides Bigtable-like capabilities on top of Apache Hadoop.

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

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

Companies

What companies use SQLite?
374 companies on StackShare use SQLite
What companies use Cassandra?
368 companies on StackShare use Cassandra
What companies use HBase?
62 companies on StackShare use HBase

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
What tools integrate with HBase?
3 tools on StackShare integrate with HBase

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

  • 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