I am working on home automation projects, and my daily queries required 1000 per second,
Previously i use firebase realtime, where i got almost 10 GB data transfer on daily basis for 1000 connected devices,
So this option seems very costly for us.
Please help me to choose cheap and been option for my project.
You can use a free trial for AWS? For MySQL I believe there are a max of 100 connections. You can also use TinyWebDB instead in forms of objects so data is compact and more easily retrieved.