如何在redis中建模这个数据结构？

Question

I have two tables in mysql, tasks and users. How do I model it in redis ? which data structure to use ?

E.g.,

tasks
-------------------------------------------
id  name assigned_to cretead_at
-------------------------------------------
1   task1  1          2012-09-10 00:00:00
-------------------------------------------
2   task2  2          2013-09-11 00:00:00
--------------------------------------------


users
-------------------
id  name email 
-------------------
1   user1  [e-mail]          
--------------------
2   user2  [e-mail]          
-------------------

My requirement is, I have user id and wish to load all fields in to php array. I don't want to fetch single field like only name of user. I want to load users all info in php array for particular user id e.g.

$user[1] = array("name" => "user1", "email" => "[e-mail]");

It would be better if I could categories it under different sets like "users" and "tasks" instead of storing it in many keys.

Answer 1

Redis is a Key:Value storage system, so you can store (and get) value by key.

To store all data in a group by categories (user, taks, etc) you can use List. For example with phpredis:

// To store lset(key index value)
$redis->lSet('users', $user[$id]['id'], json_encode($user[$id]));
// To get lget(key, index)
$redis->lGet('users', $id)