esp32-idf-sqlite3

esp32-idf-sqlite3 copied to clipboard

Hi, I use Linux Ubuntu & ESP-IDF 5.3.1 I get error when build : /home/liia/.espressif/tools/xtensa-esp-elf/esp-13.2.0_20240530/xtensa-esp-elf/bin/../lib/gcc/xtensa-esp-elf/13.2.0/../../../../xtensa-esp-elf/bin/ld: esp-idf/main/libmain.a(main.cpp.obj):(.literal.app_main+0x84): undefined reference to `sqlite3_open' /home/liia/.espressif/tools/xtensa-esp-elf/esp-13.2.0_20240530/xtensa-esp-elf/bin/../lib/gcc/xtensa-esp-elf/13.2.0/../../../../xtensa-esp-elf/bin/ld: esp-idf/main/libmain.a(main.cpp.obj): in function `app_main': /home/liia/sac_nw_v10/main/main.cpp:238:(.text.app_main+0x1e8): undefined reference to `sqlite3_open'...

hmaLiiAtech

Parser Stack Overflow

2

I am getting the above error when trying to create a trigger, this only seems to be the case with complex queries. For example CREATE TRIGGER delete_oldest_logs AFTER INSERT ON...

AdamHeavens

I slightly modified sqlite3 for working with idf v5.2.1 **1. DIR: components/esp32-idf-sqlite3** > esp32.c add : #include > CMakeLists.txt change : PRIV_REQUIRES console spiffs spi_flash) add spi_flash **2. DIR :...

prime571113