Arun (Arundale Ramanathan)
Arun (Arundale Ramanathan)
I changed the above default page size so you could download the latest master branch if you would like to try it out. The database would have to be created...
Hi, You might try using LITTLEFS as mentioned here: https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/50#issuecomment-916045739 but it could be because how SQLite handles it internally: So when you create a table with a primary key...
@savejeff I will add this issue to the README if you know many people use it. But I am not sure if it is a limitation since I have not...
You are right.. PRIMARY KEY AUTOINCREMENT is an overkill only for esp32 and it does not matter much for desktop applications. ROWID is an internal sort of less documented thing....
@davidtheITguy This is working now after implementing the code changes from @winkelict and @savejeff Thanks to all of you for the support!
Hi, Thank you for pointing this out and the PR. I will check if there is any other impact.
8 seconds sounds quite high for a 40 row table on LITTLEFS, unless the row length is huge and all rows are updated.
I think the issue you are facing is unusual so need more info or a reproducible sample to suggest further opinion.
@BackInFiveMinutes I am having trouble loading the data onto the board, so unable to test what you have provided. It may help to try using Prepared Statements instead of plain...
@trianglesis Have you tried setting the PRAGMA page_size=512 just before you do CREATE TABLE? There have been issues reported about doing VACUUM because of limited memory.