# Installing mosquitto on VPS and using it for IOT Project

**URL:** <https://forum.cedalo.com/t/installing-mosquitto-on-vps-and-using-it-for-iot-project/517>\
**Category:** Deployment\
**Created:** [March 18, 2022, 2:33pm UTC](https://forum.cedalo.com/t/installing-mosquitto-on-vps-and-using-it-for-iot-project/517 "2022-03-18T14:33:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chinmay](https://avatars.discourse-cdn.com/v4/letter/c/e8c25b/32.png) [@chinmay](https://forum.cedalo.com/u/chinmay)\
**Post date:** [March 18, 2022, 2:33pm UTC](https://forum.cedalo.com/t/installing-mosquitto-on-vps-and-using-it-for-iot-project/517/1 "2022-03-18T14:33:46Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Tizian](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.cedalo.com/tizian/32/33_2.png) [@Tizian](https://forum.cedalo.com/u/Tizian)\
**Post date:** [March 18, 2022, 3:11pm UTC](https://forum.cedalo.com/t/installing-mosquitto-on-vps-and-using-it-for-iot-project/517/2 "2022-03-18T15:11:26Z")

</div>

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](https://forum.cedalo.com/t/beginner-how-to-use-mongodb-functions/114):
>
> 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](https://docs.cedalo.com/tutorials/addons.html#mongodb) Open the “Funct…

To download Streamsheets see:

> **[Installation | Cedalo Platform](https://docs.cedalo.com/streamsheets/2.5/installation/)**
>
> Eclipse Mosquitto, Eclipse Streamsheets and the Cedalo Management Center are all available for Windows, Linux and macOS. In addition it also can be installed on a Raspberry Pi.

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

> **[Add-Ons | Cedalo Platform](https://docs.cedalo.com/streamsheets/2.5/addons/#mongodb)**
>
> Adding components to the Streamsheets architecture is possible. These can be Streamsheets specific plugins like OpenID or general useful additions to your IoT architecture like databases.

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

Hope that helps 🙂
