Because MonsterMQ can store topic values directly in PostgreSQL\/Timescale, you can instantly create dashboards with Grafana! \ud83d\udcca<\/p>\n\n\n\n
Here\u2019s a simple example:<\/p>\n\n\n\n
\ud83d\udc49 Check out the live dashboard<\/a> <\/p>\n\n\n\n It\u2019s super easy to get started. Use the public available MonsterMQ at test.monstermq.com at port 1883. Just publish a JSON string to any topic under “Test”, like “Test\/Sensor1” with a payload like this: {“value”: 1}, and you\u2019ll see the value reflected in the Grafana dashboard in real time.<\/p>\n\n\n\n I\u2019m currently publishing temperature sensor values to the public broker from my home automation using automation-gateway.com<\/a>. Just that you see some values in the dashboard.<\/p>\n\n\n\n So, if you need a broker to store your IoT data directly into TimescaleDB without the need for any additional components, consider using MonsterMQ. It’s free and available at MonsterMQ.com. <\/p>\n\n\n\n Here is the exmaple docker-compose.yml file of the public availble test.monstermq.com broker:<\/p>\n\n\n\n Here is the MonsterMQ config.yml file:<\/p>\n\n\n\n Give it a try and let me know what you think!<\/p>\n\n\n\n #iot<\/strong> #mqtt<\/strong> #monstermq<\/strong> #timescale<\/strong> #postgresql<\/strong> #grafana<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" Because MonsterMQ can store topic values directly in PostgreSQL\/Timescale, you can instantly create dashboards with Grafana! \ud83d\udcca Here\u2019s a simple example: \ud83d\udc49 Check out the live dashboard It\u2019s super easy to get started. Use the public available MonsterMQ at test.monstermq.com … Continue reading services:\n timescale:\n image: timescale\/timescaledb:latest-pg16\n restart: unless-stopped\n ports:\n - \"5432:5432\"\n volumes:\n - \/data\/timescale:\/var\/lib\/postgresql\/data\n environment:\n POSTGRES_USER: system\n POSTGRES_PASSWORD: xxx\n monstermq:\n image: rocworks\/monstermq:latest\n restart: unless-stopped\n ports:\n - 1883:1883\n volumes:\n - .\/config.yaml:\/app\/config.yaml\n command: [\"+cluster\", \"-log INFO\"]\n pgadmin:\n image: dpage\/pgadmin4\n restart: unless-stopped\n environment:\n PGADMIN_DEFAULT_EMAIL: andreas.vogler@rocworks.at\n PGADMIN_DEFAULT_PASSWORD: xxx\n volumes:\n - \/data\/pgadmin:\/var\/lib\/pgadmin\/storage\n ports:\n - \"8080:80\"\n grafana:\n image: grafana\/grafana\n restart: unless-stopped\n ports:\n - 80:3000<\/code><\/pre>\n\n\n\nPort: 1883\nSSL: false\nWS: true\nTCP: true\n\nSessionStoreType: POSTGRES\nRetainedStoreType: POSTGRES\n\nSparkplugMetricExpansion:\n Enabled: true\n\nArchiveGroups:\n - Name: \"All\"\n Enabled: true\n TopicFilter: [ \"#\" ]\n RetainedOnly: false\n LastValType: POSTGRES\n ArchiveType: NONE\n - Name: \"Test\"\n Enabled: true\n TopicFilter: [ \"Test\/#\" ]\n RetainedOnly: false\n LastValType: NONE\n ArchiveType: POSTGRES\n\nPostgres:\n Url: jdbc:postgresql:\/\/timescale:5432\/monster\n User: system\n Pass: xxx<\/code><\/pre>\n\n\n\n