Hello openHAB community,
I am currently working on a smart building project at my university in Stuttgart and would like to hear your thoughts and ideas about it.
The basic idea of the project is to integrate a poll application in the openHAB system. With an external application the students of the university can vote about values regarding the building ‘characteristics’, for example is it too hot (-> open window), too cold (-> turn on the heater), or too loud in the lecture room? This application should be connected to a database, where openHAB can pull out the results of the poll.
For the realization of the project, I am using a MySQL database. My plan for the external poll application is to create a webform which is connected to the database. It is mandatory that with each poll result, information like which building, room, lecture and professor is provided. So after the data is in the MySQL database, openHAB should be able to implement the data using the MySQL persistence. In the end, the poll results should be visualized in the HABpanel. A big question for me here is, how exactly can openHAB display the results graphically (e.g. in a pie chart) with just the raw data in the MySQL database as input?
I will document the progress of my project in this post. Feel free to comment your thoughts and ideas and you are welcome to ask me any questions about it.
Any advice will be appreciated.