How to store array in Redis hashes?

Question

I'm very new to Redis, and looking to see if its possible to do. Imagine I'm receiving data like this:

{ "account": "abc", "name": "Bob", "lname": "Smith" } { "account": "abc", "name": "Sam", "lname": "Wilson" } { "account": "abc", "name": "Joe"} 

And receiving this data for another account:

{ "account": "xyz", "name": "Bob", "lname": "Smith" }  { "account": "xyz", "name": "Sam", "lname": "Smith"} 

I would like to keep this data in Redis in similar format:

abc:name ["Bob", "Sam", "Joe"] abc:lname ["Smith", "Wilson", Null] 

And for xyz:

xyz:name["Bob", "Sam"] xyz:lname["Smith", "Smith"] 

So the question is what data types should I use to store this Redis?

Answer 1

If your goal is to check if Bob is used as a name for the account abc the solution should be something like:

Sample Data

{ "account": "abc", "name": "Bob", "lname": "Smith" } { "account": "abc", "name": "Sam", "lname": "Wilson" } { "account": "abc", "name": "Joe"} 

Do this (using a redis set):

SADD abc:name Bob Sam Joe SADD abc:lname Wilson Smith 

You'll then be able to check if Bob is used as a name for the account abc, with:

SISMEMBER abc:name Bob > true 

To retrieve all values of a field use SMEMBERS:

SMEMBERS abc:name > ["Bob", "Sam", "Joe"] 

Note:

• The key name here is under the [account]:[field] format. Where [account] can be abc, xyz and so on and field can be name, lname ...

• If you don't want unique value, for instance:

  abc:name ["Bob", "Sam", "Joe", "Bob", "Joe"]

  then you should use a list instead