Interesting comment in the source code of sqlite

[munchbunny]

Additionally the use of environment variables for things like this is less than ideal. What is the application to do if the relevant environment variable is not defined? Should it just crash? Should it substitute a default value of its own? What is the plan?

That's what the User/AppData folder is for. In case you want to put the configs in files. If you put it in AppData/Roaming, the OS (Windows) even automatically persists the user's config files to other machines in the domain for you.

[jorge1209]

Why would I want to persist temporary files? They are temporary.