@siara-cc
I am encountering an I/O disk error when executing queries with a GROUP BY clause, especially when there is a large amount of data involved. After reviewing the issue list for the andrino library, I found that this problem has already been addressed and resolved, as detailed in https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/81. The resolution involved ensuring the creation of a temporary file if it was not created initially.
I kindly request that the same fix be implemented for the idf-sqlite3 library.
Additionally, I have noticed that the SQLite3 version in the idf-sqlite3 library is "3.25.2", which is significantly outdated compared to the version used in the andrino-sqlite3 library ("3.43.2"). Please update the SQLite3 version in the idf-sqlite3 library to the latest version.
Thank you for your attention to these matters. I look forward to your response.
@siara-cc I am encountering an I/O disk error when executing queries with a GROUP BY clause, especially when there is a large amount of data involved. After reviewing the issue list for the andrino library, I found that this problem has already been addressed and resolved, as detailed in https://github.com/siara-cc/esp32_arduino_sqlite3_lib/issues/81. The resolution involved ensuring the creation of a temporary file if it was not created initially.
I kindly request that the same fix be implemented for the idf-sqlite3 library.
Additionally, I have noticed that the SQLite3 version in the idf-sqlite3 library is "3.25.2", which is significantly outdated compared to the version used in the andrino-sqlite3 library ("3.43.2"). Please update the SQLite3 version in the idf-sqlite3 library to the latest version.
Thank you for your attention to these matters. I look forward to your response.