Hi Umair, Did you try MongoDB. We are using MongoDB on a production environment and collecting data from devices like your scenario. We have a MongoDB cluster with three replicas. Data from devices are being written to the master node and real-time dashboard UI is using the secondary nodes for read operations. With this setup write operations are not affected by read operations too.
6 upvotes·1 comment·69.1K views
Don Bizzell
·
February 9th 2022 at 5:05PM
You might want to look at Yugabyte DB it is open source, scalable, and can do geographicly distributed clusters. Best of all it fully supports Postgress, so you may not have to change anything but a driver.