Why didn't you use Redis instead of storing in the database?

Redis is a high-performance in-memory data store, ideally suited for caching, queues, and fast data operations requiring low latency. However, for long-term storage and ensuring data integrity, it is generally preferable to use a database.

Reasons not to use Redis instead of a database:

• Data durability: Redis stores data in memory, and without persistence settings, data can be lost in case of a crash.
• Transactional and consistency: Relational databases provide ACID properties, which are important for financial and critical systems.
• Complex queries: Databases support complex queries, indexes, and relationships between data, which Redis does not fully provide.
• Data volume: Redis is limited by RAM size, while databases can handle larger volumes on disk.

Thus, Redis is often used as a supplement to a database to speed up access to frequently requested data but does not fully replace it in systems where reliability and complex storage logic are important.