Installing mosquitto on VPS and using it for IOT Project

[chinmay]

I am working on one IOT Project where I have to deploy 150 GPRS devices. I am planning to use VPS installed with Ubuntu 18.04 LTS and Installed with MQTT Broker and default client libraries. I am done till here. Now I have to move further in project & install python Paho MQTT library to act like client to store data into database. my question is how to store that data in mongo db and how to play further with topics? in order to get full fledged IOT application working?

[Tizian]

Hi chinmay,

Sounds great. For easy ways to store and handle data, have you tried using our other OS product Streamsheets?

You can connect Streamsheets to a MQTT Stream and create your individual logic to store the data in mongodb.

I have made a simple tutorial here:

[Beginner] How to use MongoDB functions

Basic MongoDB tasks: MONGO.STORE(); MONGO.QUERY(); MONGO.DELETE(); MONGO.COUNT(); MONGO.REPLACE() Using a database can be very convenient. A Streamsheet is good at processing data, but when it comes to storing a huge amount of data a database comes in handy. One of the many alternatives is the MongoDB. You can connect a MongoDB via a MongoDB Connector. If you don´t already have a MongoDB check out this very simple tutorial. https://docs.cedalo.com/tutorials/addons.html#mongodb Open the “Funct…

To download Streamsheets see:

Installation | Cedalo Platform

Get fast access to mongodb and connect it to Streamsheets here:

Add-Ons | Cedalo Platform

Thats maybe also a good way to play around with your topics and try out one or two things.

Hope that helps