Data Logger .csv or sql?

Other Hardware Home Automation
1

HI there ,

I am currently working on a temperature logging project on a TTGO-T-Display. I am using the SPIFFS to store my data, and the intention is to grab 12 months of data and pass that on to display on a web page as a graph, with a realtime, daily, monthly function.

My problem has been while i'm using the .csv format, some of the data is corrupt? or is displaying funny characters.

I was thinking this might be because of using .CSV / .txt format and that the SQL might clean this up and make it easier to analyse the data.

So my question is which format is best on a SPIFFS system, on a datalogger that logs every five minutes..

Many thanks for any help
Andy

2

Either CSV or SQL is going to be saved as text so from the point pf view of it being corrupted there is no difference

What you need to identify and fix is the underlying cause of the problem. By the way, the use of SPIFFS is deprecated in favour of LittleFS

1 Like
3

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.