SQLite vs. Cassandra vs. InfluxDB

Get help choosing one of these



Hacker News, Reddit, Stack Overflow Stats

  • 3.74K
  • 10.1K
  • 64K
  • -
  • 33
  • 15.4K
  • 798
  • 136
  • 1.24K

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

InfluxDB is a scalable datastore for metrics, events, and real-time analytics. It has a built-in HTTP API so you don't have to write any server side code to get up and running. InfluxDB is designed to be scalable, simple to install and manage, and fast to get data in and out.

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

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

Companies

What companies use SQLite?
374 companies on StackShare use SQLite
What companies use Cassandra?
368 companies on StackShare use Cassandra
What companies use InfluxDB?
135 companies on StackShare use InfluxDB

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

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

  • 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
A Deep Dive into InfluxDB


Interest Over Time


Get help choosing one of these