I hardly ever comment, but this is a really cool idea. Could you elaborate a little more? (On technical aspects, not political obstacles.)
Hydrating/deserializing data from Sqlite into types/objects and doing whatever goodness those need, then using Redis to make "updating the database" super fast (in memory after all) and let Redis write it back to Sqlite as there is IO/time/lull in traffic.
Kinda like how Epic Cache does its transaction journal flushing every X minutes?
It gives you a lot of interesting concepts like "lightweight databases" or push queries result into streams.
Here the GitHub repo: https://github.com/RedBeardLab/rediSQL
Full disclaimer, I am the author.
The correct link is the following now: https://payhip.com/RediSQL
Passo got acquired and shutdown...
> Carefully tested for correcteness and tuned for performance – never loose a bit.
correcteness -> correctness (slightly ironic :-) ) loose -> lose
> RediSQL inheritanve all the SQLite knobs and capabilities
inheritanve -> inherits
> RediSQL is written in Rust which provides more guarantess agains common bugs
agains -> against
> Only a very minor part of RediSQL is not releases as open source
releases -> released
Just fyi :-) Looks like a really interesting tool :-)
> rediSQL
why different spelling