esp32_arduino_sqlite3_lib

esp32_arduino_sqlite3_lib copied to clipboard

SD Card mount failure

1

Hiya, I have been trying to get your SQLite console demo code running most of today. I have an SD Card reader that I can mount and use without your...

bcookew

SQLite Database Disk Image is Malformed

2

i am using https://github.com/siara-cc/esp32_arduino_sqlite3_lib for store my data in SPIFFS of ESP32 but after some insertion of data i got error of SQLite Database Disk Image is Malformed .........................please give...

reshma26994

VACUUM result disk I/O error

10

Hi, I try to use "VACUUM" but i get this error disk I/O error. Other sqlite command work well. I use ESP32 and SPIFFS. i use the command sqlcommand="VACUUM"; "db_exec(db1,...

manouhihalid

Can i use it with IDF instead of arduino?

1

I know this has been asked before. But it's been some time. The installation steps talk about finding the esp folder inside the arduino folder.

tojacob

I saw a promise to have an exmple using sdFat lik: https://github.com/siara-cc/esp_arduino_sqlite3_lib/blob/master/examples/sqlite3_console_sd/sqlite3_console_sd.ino On ESP32, it would greatly improve the speed with large data. Many thanks

williamesp2015

Can anyone help me to set database timing using ntp server. Every time esp32 reboots sets to 1970-01-01 00:00:01

yashram96

LittleFS support ?

33

hey Arun and thanks for your awesome library :+1: I'm not sure I'm doing things properly, but I'm experiencing problems creating db files when using LittleFS as a substitute to...

tobozo

800 inserts/updates per second versus 22 inserts per second when adding "ON CONFLICT DO UPDATE"

11

Hi Arun, first of all thank you for this great library! I absolutely love it. I have used your "bulk_data_insert" example, adding "BEGIN TRANSACTION" / "END TANSACTION" and I am...

Fischkopppp

SQLite 2.3.0 - DELETE FROM [tablename] with many records results in I/O Error

6

I have been attempting to TRUNCATE a table in SQLite on an ESP32-WROVER-B using the SPIFFS library. Since TRUNCATE doesn't exist (u The execution fails with an I/O error on...

genotix

Cannot create a new table in an existing database file on SD card

6

I am following [the spi demo](https://github.com/siara-cc/esp32_arduino_sqlite3_lib/blob/master/examples/sqlite3_sdspi/sqlite3_sdspi.ino) and I have so far only modified the setup function ```c++ #include #include #include #include "SD.h" //many includes excluded for conciseness //provided functions excluded...

jojo2357