LMDB VS RocksDB

Compare LMDB vs RocksDB and see what are their differences.

LMDB

Read-only mirror of official repo on openldap.org. Issues and pull requests here are ignored. Use OpenLDAP ITS for issues. (by LMDB)

RocksDB

A library that provides an embeddable, persistent key-value store for fast storage. (by facebook)
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
LMDB RocksDB
2 44
2,507 27,922
1.6% 1.2%
5.6 9.8
about 1 month ago 6 days ago
C C++
- GNU General Public License v3.0 only
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

LMDB

Posts with mentions or reviews of LMDB. We have used some of these posts to build our list of alternatives and similar projects.

RocksDB

Posts with mentions or reviews of RocksDB. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-05-13.
  • What is RocksDB (and its role in streaming)?
    3 projects | dev.to | 13 May 2024
    You can find details in official wiki in github https://github.com/facebook/rocksdb/wiki/Basic-Operations
  • How to choose the right type of database
    15 projects | dev.to | 28 Feb 2024
    RocksDB: A high-performance embedded database optimized for multi-core CPUs and fast storage like SSDs. Its use of a log-structured merge-tree (LSM tree) makes it suitable for applications requiring high throughput and efficient storage, such as streaming data processing.
  • Fast persistent recoverable log and key-value store
    3 projects | news.ycombinator.com | 24 Feb 2024
    [RocksDB](https://rocksdb.org/) isn’t a distributed storage system, fwiw. It’s an embedded KV engine similar to LevelDB, LMDB, or really sqlite (though that’s full SQL, not just KV)
  • The Hallucinated Rows Incident
    2 projects | dev.to | 23 Nov 2023
    To output the top 3 rocks, our engine has to first store all the rocks in some sorted way. To do this, we of course picked RocksDB, an embedded lexicographically sorted key-value store, which acts as the sorting operation's persistent state. In our RocksDB state, the diffs are keyed by the value of weight, and since RocksDB is sorted, our stored diffs are automatically sorted by their weight.
  • In-memory vs. disk-based databases: Why do you need a larger than memory architecture?
    3 projects | dev.to | 5 Sep 2023
    The in-memory version of Memgraph uses Delta storage to support multi-version concurrency control (MVCC). However, for larger-than-memory storage, we decided to use the Optimistic Concurrency Control Protocol (OCC) since we assumed conflicts would rarely happen, and we could make use of RocksDB’s transactions without dealing with the custom layer of complexity like in the case of Delta storage.
  • Local file non relational database with filter by value
    1 project | /r/Database | 17 Jun 2023
    I was looking at https://github.com/facebook/rocksdb/ but it seems to not allow queries by value, as my last requirmenet.
  • Rocksdb over network
    1 project | /r/programming | 20 May 2023
  • How RocksDB Works
    2 projects | news.ycombinator.com | 19 Apr 2023
    Tuning RocksDB well is a very very hard challenge, and one that I am happy to not do day to day anymore. RocksDB is very powerful but it comes with other very sharp edges. Compaction is one of those, and all answers are likely workload dependent.

    If you are worried about write amplification then leveled compactions are sub-optimal. I would try the universal compaction.

    - https://github.com/facebook/rocksdb/wiki/Universal-Compactio...

  • What are the advantages of using Rust to develop KV databases?
    2 projects | /r/rust | 22 Mar 2023
    It's fairly challenging to write a KV database, and takes several years of development to get the balance right between performance and reliability and avoiding data loss. Maybe read through the documentation for RocksDB https://github.com/facebook/rocksdb/wiki/RocksDB-Overview and watch the video on why it was developed and that may give you an impression of what is involved.
  • We’re the Meilisearch team! To celebrate v1.0 of our open-source search engine, Ask us Anything!
    14 projects | /r/rust | 8 Feb 2023
    LMDB is much more sain in the sense that it supports real ACID transactions instead of savepoints for RocksDB. The latter is heavy and consumes a lot more memory for a lot less read throughput. However, RocksDB has a much better parallel and concurrent write story, where you can merge entries with merge functions and therefore write from multiple CPUs.

What are some alternatives?

When comparing LMDB and RocksDB you can also consider the following projects:

SQLite - Unofficial git mirror of SQLite sources (see link for build instructions)

LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.

libmdbx - One of the fastest embeddable key-value ACID database without WAL. libmdbx surpasses the legendary LMDB in terms of reliability, features and performance.

sled - the champagne of beta embedded databases

Sophia - Modern transactional key-value/row storage library.

ClickHouse - ClickHouse® is a real-time analytics DBMS

upscaledb - A very fast lightweight embedded database engine with a built-in query language.

TileDB - The Universal Storage Engine

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured