41
Projects, Designs, and Technical Stuff / Re: What is the 'go-to' MQTT broker software for local home setup
« Last post by selcuk on Today at 12:20:23 pm »The auth plugins only pull data about password and etc. from given tables. For a complete system with database and web interface, I think you should do your custom setup. I don't know a ready made solution.
For my project, I wrote a not-complex C application using libmosquitto and libpq. This app was a MQTT subscriber. There was a php web application as well. My app susbcribes to all topics of the devices so each sensor data arrives to it and then it stores them to database. Web app reads and writes only to database and it can read the saved sensor data any time user loads the page. In this scenario, you don't need and interaction between web pages and MQTT.
For my project, I wrote a not-complex C application using libmosquitto and libpq. This app was a MQTT subscriber. There was a php web application as well. My app susbcribes to all topics of the devices so each sensor data arrives to it and then it stores them to database. Web app reads and writes only to database and it can read the saved sensor data any time user loads the page. In this scenario, you don't need and interaction between web pages and MQTT.