Arun (Arundale Ramanathan)

I don't think callback can be called for empty result as per SQLite API. You could maintain a variable counter to check how many records or use SELECT COUNT(*) query...

Not sure whats wrong with SPIFFS. Since I had the ESP32 SDMMC breakout board handy, I tried it out with the Micro SD and it works fine:  Thanks for...

This library relies on the VFS layer of ESP32 for SPIFFS, SD_MMC and SD_SPI. I have not checked the code though to say that the problem is definitely not in...

> > C:\Users\dan\Documents\Arduino\libraries\Sqlite3Esp32\src\shox96_0_2.cpp:274:44: error: array subscript has type 'char' [-Werror=char-subscripts] You could overcome by changing the line to: `ol = append_bits(out, ol, c_95[(int)c_in], l_95[(int)c_in], state);` or wait for me to...

@mr-wiggle @jason7sc Please try now by cloning this repo.. I changed the config to just bare minimum and let SQLite used the defaults for most things. Also I have upgraded...

@mr-wiggle Thanks. I am not sure why UNIQUE wouldn't work for you. Also I created a release 2.2 which does not seem to show up on the Library Manager. I...

@mr-wiggle I will check what is going wrong.

This solution may solve your problems but I have not tried it: https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/21#issuecomment-586760311

I think you have index in your database and whenever insertion happens in table index also has to be updated. Thats probably why it is slow. To solve the problem...

@Rita-GE @GithubPatrick91 I will try on my side. Meanwhile, if you are trying to store sensor data, this library: https://github.com/siara-cc/sqlite_micro_logger_arduino is more suitable. It can both read and write SQLite...