I'm working in a IoT project and my role is to provide APIs to allow devices to communicate with server/database. I have decided to use MySql for relational data like user details etc.. and MongoDb for other data like device data (Multi tenant data), and PHP Laravel framework for API development.
I just want to know if this is good combination of Language, Framework and Databases? if not then what is the good combination of Language, Framework and Database, as per my requirement.
As of now devices are limited but in future it may goes into thousands and can send data frequently (Once in a minute or once in 5 seconds). Most of the devices will be running on low power and memory, ex., Temperature, Humidity, Heart Beats sensors. Same time APIs will be used for web portal as well. End of the day Rest APIs will get used by Devices, WebPortal, MobileApp.
- Is it good to use MongoDb+MySql over other databases like PostgresSQL? or any other suggestions.
- Is it good to use two different platforms for API development, one for devices (MQTT+Mosquitto) and another for web portal and mobile app (Laravel). Or any suggestion to make this system better.
- What programming language would you suggest in open source?