Either would have the generic disadvantages of:
- Dataset can't exceed available memory
- The general disadvantages of NoSQL vs SQL around queries, transactions, etc, if you're expecting relational type functionality
From my understanding, they do support sharding
There are also managed solutions that implement Redis with partial flash storage. Redis Enterprise and AWS ElastiCache both do this.
From what I saw, people think two times before doing `truncate table` but not that much with `FLUSHALL` in redis...
Also, I don't really see where the usecase would be as a permanent datastore compared to something like postgres.
It is more about writing backends generally, but in it he uses Redis as a primary database and walks through durability and scalability.