Web Application for Oil Company needed to track Mona devices using MQTT. A brand new schema was built in Singlestore to manage entire application running on docket, and to ingest data from Moxa devices via MQTT and Kafka on site. Data can then be exported into a S3 bucket and ingested into main Singlestore cluster for further analysis.
Spend more time on the schema design. We used DBSchema to model single store tables, however single store is not supported yet by that tool. We used Mysql and we just had to convert the schema.
