[anton96]

Very interesting.

This is leading me to think, using redis as the sole database is very tempting but the Ram requirement is making me think twice.

Wouldn’t there be a database like redis that only stores the latest data into memory and keeps the rest in an AOF file ?

[remote-dev]

Not to make this an ad, but you can actually do better with Redis Enterprise using Redis on flash (part of the flexible and annual plans). It stores hot data in RAM and "warm" data in flash. Here is a good 68s video on the subject: https://www.youtube.com/watch?v=hFQnhPstqLM