PostgreSQL vs. SQLite vs. RocksDB

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


PostgreSQL

SQLite

RocksDB

Favorites

395

Favorites

70

Favorites

8

Hacker News, Reddit, Stack Overflow Stats

  • 8.36K
  • 7.33K
  • 89.7K
  • 3.74K
  • 6.9K
  • 62.8K
  • 326
  • 28
  • 132

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 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.

Pros about this tool

Pros
Why do you like PostgreSQL?

Pros
Why do you like SQLite?

Pros
Why do you like RocksDB?

Cons about this tool

Cons
No Cons submitted yet for PostgreSQL
Cons
Cons
No Cons submitted yet for RocksDB
Cta desktop@2x

Companies

2160 Companies Using PostgreSQL
242 Companies Using SQLite
4 Companies Using RocksDB

Integrations

PostgreSQL Integrations
SQLite Integrations
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
  • Microsoft SQL Server - A relational database management system developed by Microsoft
  • MariaDB - An enhanced, drop-in replacement for MySQL

See all alternatives to PostgreSQL

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
All things RocksDB at Percona Live Europe 2017


Interest Over Time


Get help choosing one of these
Cta desktop@2x