Will k3s and rke2 w/sqlite honor SQLITE_TMPDIR env var?

kine doesn’t use temp tables for anything so I doubt it… why do you ask?

Even for a compact? We're (for reasons) stuck on a older version of RKE2/kine where compacts aren't happening properly (as I understand). As a workaround we're running

sqlite3 VACUUM

out of band and it appears to use

/var/tmp

as TMPDIR is not set in our environment. See https://www.sqlite.org/tempfiles.html

but we don’t explicitly set any of the temp dir pragmas or globals either so if there is something that would cause it to create a temp file it would just do as it does upstream

If kine isn't using any temp dir for anything then we're good to go I believe.

my understanding was that the vacuum uses a temporary database file that is in the same directory as the active database file so that the rename is atomic, but maybe thats not always the case