PostgreSQL vs. SQLite vs. ToroDB



Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 8.43K
  • 95.9K
  • 3.74K
  • 10.1K
  • 64.8K
  • 2
  • 46
  • 0

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

ToroDB is an open source, document-oriented, JSON database that runs on top of PostgreSQL, providing storage and I/O savings and ACID semantics. ToroDB is MongoDB-compatible, so you can use Mongo clients to connect to it.

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

Pros

Why do developers choose PostgreSQL?
Why do you like PostgreSQL?

Why do developers choose SQLite?
Why do you like SQLite?

Why do developers choose ToroDB?
Why do you like ToroDB?

Cons

What are the cons of using PostgreSQL?
No Cons submitted yet for PostgreSQL
Downsides of PostgreSQL?

What are the cons of using SQLite?
Downsides of SQLite?

What are the cons of using ToroDB?
No Cons submitted yet for ToroDB
Downsides of ToroDB?

Pricing

How much does PostgreSQL cost?
How much does SQLite cost?
How much does ToroDB cost?
ToroDB Pricing

Companies

What companies use PostgreSQL?
3177 companies on StackShare use PostgreSQL
What companies use SQLite?
400 companies on StackShare use SQLite
What companies use ToroDB?
0 companies on StackShare use ToroDB

Integrations

What tools integrate with PostgreSQL?
90 tools on StackShare integrate with PostgreSQL
What tools integrate with SQLite?
15 tools on StackShare integrate with SQLite
What tools integrate with ToroDB?
1 tools on StackShare integrate with ToroDB

What are some alternatives to PostgreSQL, SQLite, and ToroDB?

  • MySQL - The world's most popular open source database
  • MongoDB - The database for giant ideas
  • MariaDB - An enhanced, drop-in replacement for MySQL
  • Microsoft SQL Server - A relational database management system developed by Microsoft

See all alternatives to PostgreSQL

Latest News

9.6.12
10.7
9.5.16
orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite


Interest Over Time