Sqlite3 and SPIFFS could not write after 100 times insert
for example:
When I change this partition table
nvs, data, nvs, 0x9000, 0x5000,
otadata, data, ota, 0xe000, 0x2000,
app0, app, ota_0, 0x10000, 0x150000,
app1, app, ota_1, 0x160000,0x150000,
spiffs, data, spiffs, 0x2B0000,0x150000,
Sqlite3 and SPIFFS could not write after 100 times insert for example: When I change this partition table nvs, data, nvs, 0x9000, 0x5000, otadata, data, ota, 0xe000, 0x2000, app0, app, ota_0, 0x10000, 0x150000, app1, app, ota_1, 0x160000,0x150000, spiffs, data, spiffs, 0x2B0000,0x150000,
into this
nvs, data, nvs, 0x9000, 0x5000, otadata, data, ota, 0xe000, 0x2000, app0, app, ota_0, 0x10000, 0x150000, spiffs, data, spiffs, 0x160000,0x150000,
sqlite3_step return SQLITE_DONE but it's not actual DONE!
I wrote a small burner test here (platformio) https://github.com/phamminhkhac/esp32_arduino_sqlite3_lib/tree/master/examples/sqlite3_spiffs_burner