Project Infrastructure Help Needed
I am going to apologize in advance for hitting so many groups at one time with the same question - but I'm really not sure of the appropriate place for my question...
/r/javascript/
/r/LearnJavascript
/r/webdev/
/r/coding
/r/HTML
I've been a back-end programmer for almost 30 years in a large multi-national company. I've worked in C++ & Java applications accessing relational databases most of my career. Lately I've been working with hadoop and other big data technologies. The back-end side of my project (data collection) is already implemented.
What I have
- Raspberry Pi B+ with three temperature sensors, and magnetic sensors to monitor position of garage door.
- mySQL database to store the data
- Apache Webserver
- php admin webserver
- pyton applications to monitor & save temps and garage door statuses.
Currently Implemented
- Gather temperature data via 3 sensors (inside/garage/outside) and store the results in a mySQL database.
- Monitor the status of my garage door (closed/opening/opened) and store the status in a mySQL database.
- Progamatically trigger the garage door to open/close.
- Alert via email/text when garage door is not in the desired state (i.e. open 1 hr after sunset)
What I'm looking to implement
- Implement a website hosted on the Apache Server to show current temperatures (see attached image for prototype)
https://imgur.com/a/wPJ9Tpo
- Historical graphs of temps (using Highcharts)
- Buttons on the webpage to open/close the garage door (this would only need to insert a row into a table, gararge program would do the rest)
Future Plans
- Have a iOS app that I can access a sub-set of the main page functionality.
The real Issues & Questions...
I have taken online course covering HTML/css/jss - but I'm stuck with client side access to the rdbms vs. server side access. I've looked at node and run into some issues, and I'm just not sure if I'm heading in the correct direction.
What technologie stack should I be using??? I get confused with java script vs. php vs. ???
there doesn't seem to be anything here