LMDB/sqlightning
View on GitHub ↗ ★ 337 C
SQLite3 ported to use LMDB instead of its original Btree code. See https://github.com/LumoSQL/LumoSQL for maintained fork.
16 mentions on Hacker News by 11 people: 2 stories, 14 comments · first 2015-09-01 · latest 2026-01-07
20082026
-
…their code was without it. I.e., getting a 22x speedup by replacing SQLite's btree code with LMDB https://github.com/LMDB/sqlightning
comment by hyc_symas · 2026-01-07 · in Databases in 2025: A Year in Review -
https://github.com/LMDB/sqlightning https://github.com/LumoSQL/LumoSQL
comment by acrispino · 2022-10-05 · in SQLite: QEMU All over Again? -
…could speed it up a bit by using SQLightning, which replaces SQLite's Btree engine with OpenLDAP's. https://github.com/LMDB/sqlightning But yes, it's obvious your aim is to provide bare minimum LDAP functionality for people who were only…
comment by hyc_symas · 2022-07-14 · in Show HN: Lldap, a Simplified LDAP Server -
Have you seen SQLightning and/or LumoSQL? * https://github.com/LMDB/sqlightning * https://github.com/LumoSQL/LumoSQL SQLightning was the initial project combining SQLite3 with an LMDB backend. It seemed to be more an…
comment by justinclift · 2022-06-12 · in The Winamp Skin Museum is powered by a SQLite3 database with 1.2GB of metadata -
…SQLite team is starting to modularize the btree code in order to facilitate work like SQLightning: https://github.com/LMDB/sqlightning At the time SQLightning greatly improved SQLite performance but due to LMDB's requirement to have keys…
comment by plq · 2022-04-03 · in SQLite B-Tree Module -
…code, resulting in a smaller/faster footprint for SQLite itself. Proof of concept was done here https://github.com/LMDB/sqlightning A new team has picked this up and carried it forward https://github.com/LumoSQL/LumoSQL Generally, unless…
comment by hyc_symas · 2020-06-14 · in SQLite as an Application File Format (2014) -
Can this be made into a back end for sqlite? edit example like this: https://github.com/LMDB/sqlightning
comment by snissn · 2020-05-24 · in DuckDB: SQLite for Analytics -
…small database. There is even a version of SQLite that used LMDB as the underlying storage engine: https://github.com/LMDB/sqlightning .
comment by isaachier · 2018-11-11 · in LMDB – Lightning Memory-Mapped Database Manager -
…SQLite's Btree engine with LMDB makes the SQLite footprint smaller, faster, and more reliable too. https://github.com/LMDB/sqlightning
comment by hyc_symas · 2018-11-09 · in Design Review: Key-Value Storage -
…on its own. (Needs the transaction log support to provide reliability.) LMDB blows it away. https://github.com/LMDB/sqlightning
comment by hyc_symas · 2018-10-01 · in UnQLite – An Embeddable NoSQL Database Engine -
I wonder if they got the inspiration from https://github.com/LMDB/sqlightning
comment by bluecarbuncle · 2018-08-30 · in LiteTree: SQLite with Branches -
I'm surprised there wasn't more investigation of SQLite and LMDB: https://github.com/LMDB/sqlightning The performance there shows either little to no performance difference, up to substantial speed increases.
comment by adekok · 2017-11-08 · in Work on SQLite4 has concluded -
…over 500k-1m records to be expected. That being said, if they're partial to sqlite, SQLightning ( https://github.com/LMDB/sqlightning ) looks pretty interesting (SQLite with an LMDB backend). edit: To clarify, these weren't particularly…
comment by chjj · 2016-06-19 · in We’re pretty happy with SQLite and not urgently interested in a fancier DBMS -
…on BDB - yes, it's a joke. I've run it, and the performance is pretty awful. But we do far better. https://github.com/LMDB/sqlightning There are many positive and negative lessons in software design to be learned from Berkeley DB. It…
comment by hyc_symas · 2015-09-01 · in Berkeley DB: Architecture