SQL, scala, ioT and custom built dashboards

I love being a business intelligence solutions developer. I’ve been interested for the last few years in AI/ML and have been lucky enough to attend a few conferences on the subject.

I was just tasked with building out some custom dashboards that will display real-time data that is pushed from hundreds of ioT devices around the globe to a SQL database. From their the data is translated using scala software. It will then be sanitized from any traceable customer information and pushed into an AWS database (off-site). That way the dashboards I’m building will be able to access the data.

I’m planning on using PHP to encode the data into JSON and consume from there.

This is all new and I’m attempting to architect the schema and the flow of data, so this will end up becoming a multi-part post.

For now, the first step is to see if I can connect to a sql dB, encode it to JSON and consume it into a dashboard.

Looking at example dB’s here: https://dev.mysql.com/doc/index-other.html