8 ms·

I hardly ever comment, but this is a really cool idea. Could you elaborate a little more? (On technical aspects, not political obstacles.)

smush 8y ago
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 8y ago
  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 https://github.com/RedBeardLab/rediSQL Full disclaimer, I am the author.
  - smush 8y ago
    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 8y ago
      Thanks! Any feedback is welcome!
      - turtlebits 8y ago
        FYI the SSL cert has expired on whoever is hosting your download link (plasso.com)
        siscia 8y ago
        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 https://payhip.com/RediSQL Passo got acquired and shutdown...
        SoreGums 8y ago
        On mobile there is a "Buy Now" button at the top of the screen that goes to plasso. https://imgur.com/a/XYD9slH https://imgur.com/a/XYD9slH
      - bruce_one 8y ago
        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 :-)
  - svnpenn 8y ago
    > RediSLQ > rediSQL why different spelling
  - e12e 8y ago
    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 8y ago
      It allow you to access the same dataset from different processes (possible also with SQLite) and machines.
  - siscia 8y ago
    The correct URL is https://redisql.com https://redisql.com

smush 8y ago

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 8y ago
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 https://github.com/RedBeardLab/rediSQL Full disclaimer, I am the author.
- smush 8y ago
  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 8y ago
    Thanks! Any feedback is welcome!
    - turtlebits 8y ago
      FYI the SSL cert has expired on whoever is hosting your download link (plasso.com)
      - siscia 8y ago
        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 https://payhip.com/RediSQL Passo got acquired and shutdown...
        SoreGums 8y ago
        On mobile there is a "Buy Now" button at the top of the screen that goes to plasso. https://imgur.com/a/XYD9slH https://imgur.com/a/XYD9slH
    - bruce_one 8y ago
      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 :-)
- svnpenn 8y ago
  > RediSLQ > rediSQL why different spelling
- e12e 8y ago
  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 8y ago
    It allow you to access the same dataset from different processes (possible also with SQLite) and machines.
- siscia 8y ago
  The correct URL is https://redisql.com https://redisql.com