redis

concepts

[https://medium.com/@stockholmux/from-sql-to-redis-chapter-1-145c82e4baa0|from sql to redis]

type hash for tables and rows

namespace:table:id

INCR gianoauth:realm:next_user_id => 1
HSET gianoauth:realm:user:1 id 1 username "scipio" name "Stefano Scipioni" password "hash"

add an INDEX with sets: collections of strings that are unordered and cannot contain duplicates

SADD gianoauth:realm:all-users gianoauth:realms:users:1

use multi exec to surround HSET and SADD

MULTI
HSET ...
HSET ...
SADD ...
EXEC

sorted set: like a set a sorted set only allows members without repeats, but also allows you to specify a score

ZADD gianoauth:realms:priceIndex 10.99 scipio

gui

fastoredis

server

sudo apt install -y redis-server redis-tools