from d6e, after hearing the ridiculous reverse replicator plan

use redis to cache supabase reads

optimistic updates?

use a local in-memory store of the db

[c] hmm seems complicated. keeping things in sync will be a pain. still better than firebase reverse replicator tho lol