Info on the use of temp files can be found here https://www.sqlite.org/tempfiles.html
Anything integral to integrity is always put on disk, so SQLITE_TEMP_STORE shouldn't be affecting integrity. -----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, March 12, 2019 10:37 AM To: [email protected] Subject: [sqlite] Apparent power fail data loss in embedded use - SQLite newbie ... SQLite is configured to use “temp files always in memory”, which is suspicious for a power fail problem, but I don’t know what the temp files are used for. ... Might the memory only “temp files” be an issue? What does (did) SQLite use those for? If the transaction/rollback file or similar, it could obviously be an issue, but that doesn’t make sense to me. ... Ted _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
