OTA and saving data to EEPROM, SPIFFS, and Excel

Abstract

The memory storage device for computers and microcontrollers is termed flash memory, which retains data when power is turned off. In contrast, data stored in RAM (random access memory) is lost when power is turned off. Flash memory is partitioned into several sections: application, OTA (over the air) updating, SPIFFS (Serial Peripheral Interface Flash File System), EEPROM (Electrically Erasable Programmable Read-Only Memory), Wi-Fi, and configuration information. A sketch is stored in application memory, and the variables created and manipulated in a sketch are stored in RAM. The opportunity to upload a sketch remotely with OTA and options for saving data in SPIFFS and EEPROM partitions of flash memory are outlined in this chapter. Saving data directly to a Microsoft Excel file, instead of using an SD card for data logging, is also described.