dqlite
edge-sql
Our great sponsors
| dqlite | edge-sql | |
|---|---|---|
| 32 | 2 | |
| 3,538 | 549 | |
| 1.5% | - | |
| 0.0 | 1.7 | |
| 8 days ago | over 2 years ago | |
| C | C | |
| GNU General Public License v3.0 or later | - |
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.
dqlite
- I'm All-In on Server-Side SQLite
-
SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s
I'd be curious for a similar tuning with Dqlite: https://github.com/canonical/dqlite
- Strong Consistency with Raft and SQLite
-
9 years of open-source database development: reviewing the designs
Anyone knows how the DB this is about, https://rqlite.io/, compares with https://dqlite.io/ by Canonical (both seem to be distributed versions of sqlite)?
- SQLite the only database you will ever need in most cases
-
Transcending Posix: The End of an Era?
For folks' context, the new tool that's being discussed in the thread mentioned by the parent here is litefs [0], as well as which you can also look at rqlite [1] and dqlite [2], which all provide different trade-offs (e.g. rqlite is 'more strongly consistent' than litefs).
[0]: https://github.com/superfly/litefs
-
SQLite is not a toy database
I presume you're familiar with https://github.com/canonical/dqlite (made by my employer) and https://github.com/rqlite/rqlite (unrelated)? How will mvsqlite compare to those?
-
GitDB, a distributed embeddable database on top of Git
Check out dqlite, it's sqlite but with a raft consensus to distribute changes through a log: https://dqlite.io/ You can link it in as a library too, it sounds like exactly what you want.
- Ask HN: Free and open source distributed database written in C++ or C
-
Fly.io Buys Litestream
https://dqlite.io/
I’m sure there’s more, those are just the ones I remember.
edge-sql
- Abusing AWS Lambda to Make an Aussie Search Engine
-
Serverless SQLite
edge-sql [1] allows arbitrary SQLite queries to be executed over an immutable external data set. The demo uses a Forex data set stored in Workers KV.
Client issued arbitrary queries is one of the use cases for GraphQL and publishing immutable data sets on the web is the main use case for Simon Wilson’s Datasette [2].
In-memory SQLite compiled to WASM works in the browser and Node.js too. In the future, we can expect proper ACID operations on any WASM runtime that supports fsync in WASI [3], a POSIX-like API.
What are some alternatives?
rqlite - The lightweight, distributed relational database built on SQLite
kine - Run Kubernetes on MySQL, Postgres, sqlite, dqlite, not etcd.
litestream - Streaming replication for SQLite.
better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.
boringproxy - Simple tunneling reverse proxy with a fast web UI and auto HTTPS. Designed for self-hosters.
Bedrock - Rock solid distributed database specializing in active/active automatic failover and WAN replication
mvsqlite - Distributed, MVCC SQLite that runs on FoundationDB.
SQLite - Official Git mirror of the SQLite source tree
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines
ipfs-cluster - Pinset orchestration for IPFS
Olric - Distributed in-memory object store. It can be used both as an embedded Go library and as a language-independent service.
torrent-net - Distributed search engines using BitTorrent and SQLite