PostgreSQL vs. SQLite vs. Cassandra

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


PostgreSQL

SQLite

Cassandra

Favorites

392

Favorites

70

Favorites

57

Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 7.33K
  • 88.4K
  • 3.74K
  • 6.33K
  • 62.3K
  • -
  • 24
  • 14.9K

GitHub Stats

No public GitHub repository stats available

Description

What is PostgreSQL?

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

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.

Pros about this tool

Pros
Why do you like PostgreSQL?

Pros
Why do you like SQLite?

Pros
Why do you like Cassandra?

Cons about this tool

Cons
No Cons submitted yet for PostgreSQL
Cons
Cons

Companies

2110 Companies Using PostgreSQL
237 Companies Using SQLite
277 Companies Using Cassandra

Integrations

PostgreSQL Integrations
SQLite Integrations
Cassandra Integrations

Latest News

PostgreSQL rocks, except when it blocks: Understandi...
10.2
9.5.11
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