Offline Data logging within ctrlX and save in uSD card

[Mr_Wonder_Why]

Hi, I would like to create an architecture where i can constantly overwrite and log the updated data(within 1,000 hours) in the uSD card in csv format.  Since this datalogging has to be done offline, does that mean we need to have our own SQL database software in ctrlX? Or is there any other way to do this?

P/S: I have attached the image below showing my architecture in node red which transfers ctrlX data to HeidiSQL database(database software from my laptop device)

[nickH · Accepted solution]

Hi @Mr_Wonder_Why , 

you got multiple options to store the data on the ctrlX CORE (or better on a μSD connected to ctrlX CORE). 

1. You can log your data to a csv file on a μSD. 
   • This post in the forum might help you a bit: Node-Red Datalayer to CSV on USB
2. You can use a Data Base App from the ctrlX Store (InfluxDB) 
   
   • ctrlX AUTOMATION - InfluxDB App in the ctrlX Store 
   • How to to get started with the InfluxDB App and Node Red (+Grafana App): IIoT: Use ctrlX CORE as a monitoring platform using InfluxDB and Grafana
3. You can build your own Data Base App (for example including an open source data base)
   • One example: Mongo DB in ctrlX OS 
   • Second example: PostgreSQL on ctrlX CORE

To send the data over the network to some database (like you did with your laptop) is also possible. 

Best regards, 

Nick