May-28th-2019, 07:22 AM
(This post was last modified: June-12th-2019, 06:37 AM by Armin@netPI.)
Well Madhumati,
if I hear "data storage" under long term conditions I am always concerned about the durability of the default SD card memory we use in netPI. It is a NAND Flash based of type MLC and by its very nature of design it has limited program/erase write cycles (3000 p/e by the way per block). So the question is how many data does this customer want to store on the SD card per day? Examinations about the SD cards durability were topic of another thread.
You say "to export the database to a server" ... of which type of server is this? Can the database server be defined/setup still or is it set already?
I am asking because I would not recommend SQlite but a time series database like InfluxDB instead. See here a comparison.
So the server should run InfluxDB and there is Node-RED influxdb node available to write to InfluxDB from local netPI to the remote database. So there is no need to store data locally which is good for the SD card.
if I hear "data storage" under long term conditions I am always concerned about the durability of the default SD card memory we use in netPI. It is a NAND Flash based of type MLC and by its very nature of design it has limited program/erase write cycles (3000 p/e by the way per block). So the question is how many data does this customer want to store on the SD card per day? Examinations about the SD cards durability were topic of another thread.
You say "to export the database to a server" ... of which type of server is this? Can the database server be defined/setup still or is it set already?
I am asking because I would not recommend SQlite but a time series database like InfluxDB instead. See here a comparison.
So the server should run InfluxDB and there is Node-RED influxdb node available to write to InfluxDB from local netPI to the remote database. So there is no need to store data locally which is good for the SD card.
„You never fail until you stop trying.“, Albert Einstein (1879 - 1955)