PostgreSQL vs. SQLite vs. Citus

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


PostgreSQL

SQLite

Citus

Favorites

377

Favorites

66

Favorites

2

Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 7.2K
  • 83.4K
  • 3.74K
  • 5.58K
  • 60.7K
  • 3.65K
  • 1.66K
  • 37

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

Why do you like SQLite?

Why do you like Citus?

Cons about this tool

Customers

Integrations

Latest News

PostgreSQL rocks, except when it blocks: Understandi...
9.3.21
9.4.16
orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite
How the Citus distributed database rebalances your data
Database sharding explained in plain English
Citus Cloud Retrospective for 12/14/2018


Interest Over Time


Get help choosing one of these