relational_redis is a stub for redis database to achieve relational database functionality coupled with a dashboard to display statistics such as CPU usage, commands per/sec, hits/sec etc.
relational_redis plays the role of an in-memory relational database.
- It uses rediSQL to translate SQL queries on the fly and imitate relational database functionality on redis(which is in fact a key-value pair storage).
- load_db.py is a utility script to seed a sqlite database into redis(for now the script assumes a single table in the database)
- conf.py can be used to set the database name and table name.
- data_generator was used to generate random data.
- Install redis.
- Install rediSQL.
- Install requirements with
pip install -r requirements.txt. - Run rediSQL either as a Docker container or as a module with the redis server.
- Configure database and table name in
conf.pyand runload_db.pyto seed the database into redis. - cd into
redis-stat/redis-stat/and runruby -Ilib bin/redis-stat --server - Run
python app.py - Visit localhost:63790 to see the dashboard displaying all statistics.
Run bash test.sh to test the whole project with a query.
