index example

example.txt

# creating an index:

127.0.0.1:6379> IDX.CREATE users TYPE HASH SCHEMA name STRING age INT32
OK

# running HASH commands while indexing them:

127.0.0.1:6379> IDX.INTO users HMSET user1 name "alice" age 24
OK
127.0.0.1:6379> IDX.INTO users HMSET user2 name "bob" age 19
OK

# seleting from the index using native redis commands:

127.0.0.1:6379> IDX.FROM users WHERE "name = 'alice'" HMGET $ age
1) 1) "24"

127.0.0.1:6379> IDX.FROM users WHERE "name = 'alice' AND age < 24" HMGET $ age
(empty list or set)

127.0.0.1:6379> IDX.FROM users WHERE "name IN ('alice','bob') AND age < 24" HMGET $ age
1) 1) "19"

127.0.0.1:6379> IDX.FROM users WHERE "name IN ('alice','bob') AND age < 24" HMGET $ age name
1) 1) "19"
   2) "bob"

127.0.0.1:6379> IDX.FROM users WHERE "name LIKE 'al%'" HGETALL $
1) 1) "name"
   2) "alice"
   3) "age"
   4) "24"