sqlightning vs lumosql

sqlightning

SQLite3 ported to use LMDB instead of its original Btree code. See https://github.com/LumoSQL/LumoSQL for maintained fork. (by LMDB)

Suggest topics

Source Code

Suggest alternative

Edit details

lumosql

Official Github Mirror of the LumoSQL Database Project (https://lumosql.org/src/lumosql) (by LumoSQL)

Suggest topics

Source Code

Suggest alternative

Edit details

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

sqlightning		lumosql
	Project
4	Mentions	1
299	Stars	167
1.0%	Growth	1.8%
10.0	Activity	0.0
over 4 years ago	Latest Commit	9 months ago
C	Language	C
-	License	GNU General Public License v3.0 or later

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.

sqlightning

Posts with mentions or reviews of sqlightning. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-10-04.

SQLite: QEMU All over Again?
11 projects | news.ycombinator.com | 4 Oct 2022
Show HN: Lldap, a Simplified LDAP Server
6 projects | news.ycombinator.com | 11 Jul 2022

I'm guessing you mean "and the software is fast enough", because OpenLDAP itself has been the world's fastest distributed database for over a decade, and nothing else even comes close.
Since you built on top of SQLite, then you're already at least an order of magnitude slower. You could speed it up a bit by using SQLightning, which replaces SQLite's Btree engine with OpenLDAP's.
https://github.com/LMDB/sqlightning
Sqlightning: SQLite3 ported to use LMDB instead of its original Btree code
1 project | news.ycombinator.com | 3 Apr 2022
SQLite B-Tree Module
2 projects | news.ycombinator.com | 3 Apr 2022

This has been shared without context but I guess the 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 fit in 2/3 of a page it wasn't really useful as a general purpose replacement of SQLite's internal b-tree implementation.

lumosql

Posts with mentions or reviews of lumosql. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-10-04.