store
rqlite
store | rqlite | |
---|---|---|
2 | 112 | |
256 | 14,862 | |
- | 0.7% | |
2.5 | 9.9 | |
about 1 year ago | 8 days ago | |
Ruby | Go | |
MIT License | MIT License |
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.
store
-
A Critique of SQL, 40 Years Later
Cool! I do this, but I haven't seen anyone else do it. Is any of your code public?
I wrote about it at https://sive.rs/pg
and posted my SQL shopping cart at https://github.com/sivers/store
Please contact me if you'd like to share tips: https://sive.rs/contact
-
Single Dependency Stacks
Also:
https://sive.rs/pg2 - Simplify: move code into database functions
https://sive.rs/pg - PostgreSQL example of self-contained stored procedures
some linked examples: https://github.com/sivers/store/tree/master/store/functions
I like this idea in theory ... although it would cause me to need to know a lot more SQL, which is a powerful but hostile language :-/
I care about factoring stuff out into expressions / functions and SQL fails in that regard ...
https://www.scattered-thoughts.net/writing/against-sql/
It's hard to imagine doing this with a ton of duplication. I have written SQL by hand and there are probably more confusing corners than shell, which is saying a lot (and which I didn't have too hard a time learning)
rqlite
- The lightweight, easy-to-use, distributed relational database built on SQLite
-
CursusDB β A new scalable distributed document oriented database
Seems like you could do the same with rqlite [1], since SQLite supports JSON.
[1]: https://rqlite.io
-
Rqlite 8.0
rqlite[1] creator here, happy to answer any questions about rqlite, this latest release, and how it works.
[1] https://rqlite.io
-
Adding new database engine support
I found simple distributed RQlite https://github.com/rqlite/rqlite based on raft and sqlite. How hard is to add it?
- I'm All-In on Server-Side SQLite
-
So, you want to deploy on the edge?
rqlite[1] creator here, happy to answer any questions. rqlite also supports read-only nodes, which can also help with reads at the "edge". It probably wouldn't scale to 100s of nodes, it is an option.
"rqlite supports adding read-only nodes. You can use this feature to add read scalability to the cluster if you need a high volume of reads, or want to distribute copies of the data nearer to clients β but donβt want those nodes counted towards the quorum. These types of nodes are also known as non-voting nodes."
[1] https://rqlite.io/
[2] https://rqlite.io/docs/clustering/read-only-nodes/
- LiteFS Cloud: Distributed SQLite with Managed Backups
- Show HN: Rqlite, distributed DB built on SQLite, now runs on MIPS, RISC, PowerPC
- rqlite v7.19.0: the lightweight distributed relational database built on Go, Raft, and SQLite -- now runs on MIPS, PowerPC, and RISC
- rqlite v7.18: the lightweight distributed database built on Go, Raft, and SQLite -- now with new Unified HTTP endpoint for easy reads and writes
What are some alternatives?
ibis - the portable Python dataframe library
dqlite - Embeddable, replicated and fault-tolerant SQL engine.
bolt
litestream - Streaming replication for SQLite.
cockroach - CockroachDB - the open source, cloud-native distributed SQL database.
etcd - Distributed reliable key-value store for the most critical data of a distributed system [Moved to: https://github.com/etcd-io/etcd]
TinyGo - Go compiler for small places. Microcontrollers, WebAssembly (WASM/WASI), and command-line tools. Based on LLVM.
go-cache - An in-memory key:value store/cache (similar to Memcached) library for Go, suitable for single-machine applications.
groupcache - groupcache is a caching and cache-filling library, intended as a replacement for memcached in many cases.
budibase - Budibase is an open-source low code platform that helps you build internal tools in minutes π
Bedrock - Rock solid distributed database specializing in active/active automatic failover and WAN replication