Objective:
The objective to be able to store list of json in Redis and to be able to manipulate it right in Redis itself.
Problem Statement
The problem is that manipulating a list of JSON has required us to bring all the data in the application before being able to do anything reasonable with it. For example, filtering list of JSON where JSON strings have a certain value against a certain JSON path and things like that. This has slowed the application capability and defied the purpose of having Redis.
Possible Solutions That We Are Considering
- We were thinking of using RedisJSON to support JSON natively in Redis but it doesn't seems to be meeting our requirement. Please correct me if I am wrong. [I am very much new to Redis.]
- The other solution that we are considering is Lua scripting on the Redis server itself or using a library like, scala-redis to execute Lua scripts on Redis.
Please suggest us on:
- If there is a better way to represent such a data in Redis?
- If RedisJSON or similar modules could solve our problem in their capacity?
- If we are right about using library like scala-redis?
Please let me know if this is the right place for this question or this question needs to be expressed in a better way.