Hello i received a compiler error complaining about the use of ps_realloc((x),(y)) and ps_malloc(x) and i was able to fix it using these declarations instead in the sql;ite3.c :
// #define SQLITE_MALLOC(x) ps_malloc(x)
// #define SQLITE_REALLOC(x,y) ps_realloc((x),(y))
replaced with:
#include "esp_heap_caps.h"
#define SQLITE_MALLOC(x) heap_caps_malloc((x), MALLOC_CAP_SPIRAM)
#define SQLITE_REALLOC(x,y) heap_caps_realloc((x), (y), MALLOC_CAP_SPIRAM)
cheers,