[smush]

Complete conjecture, I am not the GP.

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?

[siscia]

You could have a look into RediSLQ (RediSLQ.com) which is a redis module that embed SQLite, giving crazy fast performance.

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.

[smush]

I'm pleased you took the time to send this little targeted advert my way. I will be glad to check out that repo.

[siscia]

Thanks! Any feedback is welcome!

[bruce_one]

Some silly feedback on typos:

> 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 :-)

[turtlebits]

FYI the SSL cert has expired on whoever is hosting your download link (plasso.com)

[siscia]

Thanks! Indeed you should not have see that link! Can you point me where did you clicked?

The correct link is the following now: https://payhip.com/RediSQL

Passo got acquired and shutdown...

[SoreGums]

On mobile there is a "Buy Now" button at the top of the screen that goes to plasso. https://imgur.com/a/XYD9slH

[siscia]

The correct URL is https://redisql.com

[e12e]

It looks like an interesting project - but I'm not sure I understand how it's better than a ram backed sqlite instance. It forces/let's you use the Redis protocol to connect rather than embedding?

[siscia]

It allow you to access the same dataset from different processes (possible also with SQLite) and machines.

[svnpenn]

> RediSLQ

> rediSQL

why different spelling