Arun (Arundale Ramanathan)

Another way is to create new DB after certain number of records and deleting older files. But this will create multiple DBs for reading.

Please see [here](https://github.com/siara-cc/sqlite_micro_logger_arduino/blob/fed1907a132d26c9dc83f72799d026f1edf4009a/examples/Uno_and_above/Uno_and_above.ino#L44) for an example. There is no issue of using both for the same handle because both read and write functions that are defined are expected to `seek`...

Read and write contexts are to be used independently. The functions that take read context as parameter do not know about any write context and vice versa. So any pending...

When `dblog_finalize()` is called, it writes to disk the page that is being written to and calls the flush function defined. So it should be possible to read it back....

> After I call finalize, do I need to init the db again? Yes dblog_read_init() for the read context. However, the file need not be closed as all the File...

Yes please use the update function to update column in record. This needs to be called with a read context after locating the record to be updated. Please note that...

Hi, have you installed the dependent SDFat library? https://github.com/siara-cc/esp_arduino_sqlite3_lib#dependencies--pre-requisites

Hi @mciezkowski , Aggregate functions should work if they don't violate the limitations of esp32. You could refer to this example although it is for the Arduino platform: https://github.com/siara-cc/esp32_arduino_sqlite3_lib/blob/master/examples/sqlite3_stackoverflow_users/sqlite3_stackoverflow_users.ino [One...

SPIFFS known to cause such problems. Can try LITTLEFS? https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/18

@Yukselzngn Hi, Sorry I was unable to reply earlier. There is not much to say from what you have mentioned. If you can post the stack trace or code or...