PostgreSQL vs. SQLite vs. RocksDB

  • 8.36K
  • 8.45K
  • 97.3K
  • 3.74K
  • 10.1K
  • 65.3K
  • 326
  • 29
  • 186
No public GitHub repository stats available

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

RocksDB is an embeddable persistent key-value store for fast storage. RocksDB can also be the foundation for a client-server database but our current focus is on embedded workloads. RocksDB builds on LevelDB to be scalable to run on servers with many CPU cores, to efficiently use fast storage, to support IO-bound, in-memory and write-once workloads, and to be flexible to allow for innovation.

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

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

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

Why do developers choose RocksDB?
Why do you like RocksDB?

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

What companies use PostgreSQL?
3267 companies on StackShare use PostgreSQL
What companies use SQLite?
409 companies on StackShare use SQLite
What companies use RocksDB?
9 companies on StackShare use RocksDB
What tools integrate with PostgreSQL?
93 tools on StackShare integrate with PostgreSQL
What tools integrate with SQLite?
16 tools on StackShare integrate with SQLite
No integrations listed yet

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

  • 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

9.5.16
11.2
9.6.12
orchestrator 3.0.2 GA released: raft consensus, SQLite
Using Active Record migrations beyond SQLite
All things RocksDB at Percona Live Europe 2017


Interest Over Time