esp32-idf-sqlite3
esp32-idf-sqlite3 copied to clipboard
siara-cc
Sqlite library for esp-idf (esp32) framework
I have successfully ran this on an ESP32-WROVER (IDF v3.3.1) with a SPIFFS partition. However, it does not appear to work on a FAT partition using VFS with wear leveling....
Hi, I've the new module ESP32-S3.I use this component in my project with ESP32, but I want to update it for the new target. I changed the Cmakelist with this...
Can't compile using idf.py. How to compile using idf.py instead of make Tried directly including, but the following result /main/sqlite3.c ../main/sqlite3.c: In function 'strftimeFunc': ../main/sqlite3.c:13957:27: warning: cast between incompatible function...
Platform: esp-idf 3.3-beta1-506-gebdcbe8c6-dirty Using either one of the following statements: ```sql INSERT INTO tableName (value) VALUES (12.00),(24.00),(36.00),(48.00),(60.00),(72.00),(84.00),(96.00); ``` ```sql INSERT INTO tableName (value) SELECT (12.00) UNION ALL SELECT (24.00) UNION...
if I execute a lot of inserts (800-6000) in a table I get the error 'database disk image is malformed'. This happens if the table has an Index, the table...
When i try to build with mongoose os (based on esp32 idf) i get this error ``` /data/fwbuild-volumes/2.17.0/apps/app1/esp32/build_contexts/build_ctx_640020291/src/esp32.c:122:1: error: missing initializer for field 'xCurrentTimeInt64' of 'sqlite3_vfs {aka struct sqlite3_vfs}' [-Werror=missing-field-initializers]...
Request sqlite for esp32 come with encrpytion for protection private database too. Thank you.
Hello Do the aggregation functions work for you? I'm using esp32-idf-sqlite3 library on SenseCAP Indicator D1 and I have a problem with aggregate functions. Normal select works without problem but...
by changing this in sqlite.c: #define SQLITE_MALLOC(x) malloc(x) #define SQLITE_FREE(x) free(x) #define SQLITE_REALLOC(x,y) realloc((x),(y)) to: #ifdef BOARD_HAS_PSRAM #define SQLITE_MALLOC(x) ps_malloc(x) #define SQLITE_FREE(x) free(x) #define SQLITE_REALLOC(x,y) ps_realloc((x),(y)) #else #define SQLITE_MALLOC(x) malloc(x)...
The latest stable **ESP-IDF** version is `5.1.1` so reading the issues and Pull Request I added the necessary changes for the code to support `5.X.X` and `4.X.X`. #17 I took...
