Can you store the incoming data from the sensors in another location?

[gfield]

Hi, please excuse the newbie question.

I haven’t got anything set up just yet, but this is the situation. We will have 56 sensors around our property, and I need to have the data from those sensors stored on our NAS, perhaps in a CSV / JSON file.

Is this possible to do automatically? From the little that I understand - data by default is stored in the postgres DB, so is there a way to (using built in functionality), to have two funnels as to where the data will go? Or would we need to write a script to do this for us through the API / direct interaction with the DB?

I’m guessing that if I was to do it manually, then I would need to write an SQL script to grab the data, and put that into a format of my choice?

Thank you

[bconway]

There are many integration options available:

https://www.chirpstack.io/docs/chirpstack/integrations/index.html

None are enabled by default, including the PostgreSQL integration. That one’s probably your best bet for exporting to CSV, though.

[IoTThinks]

You may need to write a simple script to get the data from MQTT or Postgres and save to a text file.

[gfield]

Thank you for your reply @IoTThinks - please excuse my ignorance, but with an MQTT broker such as mosquitto, would my script interact with it via mosquitto’s API?

Also, @bconway / @IoTThinks - if I need to wipe data from my DB (we’re hosting network + app server on an EC2 instance, so space is a constraint) - can that only be done via interacting Postgres? And with that in mind - would it make more sense for me to use the Postgres vs an MQTT broker?

P.S: I do apologise for my ignorance - I’m trying to visualise things as we can’t physically set anything up at present

Thank you