mr-wiggle

(778) SQLITE_IOERR_WRITE when adding a table using UNIQUE or PRIMARY KEY on spiffs

21

I am having an issue where I cannot add tables using UNIQUE or PRIMARY KEY. This produces an disk i/o error. my DB file is on SPIFFS. I do not...

I've been trying to run some PRAGMA commands, but they all seem to be ignored. Specifically, what I'm trying to do is set ```PRAGMA journal_mode = MEMORY``` but after setting...