Arun (Arundale Ramanathan)

Have you tried using Prepared Statement to insert the records?

Hi, thank you for the suggestion. The question of allocating from PSRAM came up before this, but there does not seem to be a transparent way of doing this. There...

Please see the example webquery in this repo. Using the prepare statement and step sqlite api functions, you could form such strings as above: ``` while (sqlite3_step(res) == SQLITE_ROW) {...

I am unable to spend time on what you are trying to achieve, but it looks like just by fiddling with the code in different ways you will be able...

@simkard69 @Fischkopppp I guess the purpose is to fix the page size. So I think having an empty database pre-created and copied whenever needed is the way to go.

Hi, not sure what is causing this, but please check this out: https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/50#issuecomment-916045739

Thanks a lot for sharing your experience @mr-wiggle !! Does it work for you @tobozo ? If not I will try and get back to you.

I have not been able to create the LITTLEFS since last week to figure out the above issue. I get the following when trying to create LittleFS using ESP32 Sketch...

@tobozo I noticed that. But I am using the release you have pointed to. Not sure how it is using `mklittlefs` from esp8266 folder.

@tobozo I am using a ESP-WROOM-32. Your suggestion did change it from esp8266 to esp32 folder, but the rest are still the same: ``` Chip : esp32 Using partition scheme...