• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[SOLVED] Storing data on a (remote) database
#2
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.
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply


Messages In This Thread
RE: Database storage - by Armin@netPI - May-28th-2019, 07:22 AM
RE: Database storage - by MGharat - May-28th-2019, 08:42 AM
RE: Database storage - by patrick - May-28th-2019, 09:35 AM
RE: Database storage - by Armin@netPI - May-28th-2019, 09:41 AM
RE: Database storage - by MGharat - May-28th-2019, 10:39 AM
RE: Database storage - by Armin@netPI - May-28th-2019, 11:33 AM
RE: Database storage - by MGharat - May-28th-2019, 11:59 AM
RE: Database storage - by Armin@netPI - May-28th-2019, 01:27 PM
RE: Database storage - by patrick - May-28th-2019, 03:09 PM
RE: Database storage - by MGharat - May-29th-2019, 02:12 PM
RE: Database storage - by Armin@netPI - May-29th-2019, 02:57 PM

Possibly Related Threads...
Thread Author Replies Views Last Post
  Getting data from AllenBradley PLC MarcoMedina 3 16 February-26th-2020, 11:53 AM
Last Post: Armin@netPI
Information [INFO] - InfluxDB - Time series database under Windows patrick 0 68 May-28th-2019, 02:10 PM
Last Post: patrick
  Fetch data from S7 PLC Profibus DP MGharat 3 38 March-14th-2019, 11:21 AM
Last Post: Armin@netPI
  Secomea Remote Acccess ballesj 1 158 May-15th-2018, 12:42 PM
Last Post: Armin@netPI
  IBM sensor data historian and analytics engine for the netPi AlexKoeMuc 0 88 November-28th-2017, 01:39 PM
Last Post: AlexKoeMuc

Forum Jump:


Users browsing this thread: 1 Guest(s)