SQLite Forum

How to change sqlite3_temp_directory in windows to change temporary file location
Login

How to change sqlite3_temp_directory in windows to change temporary file location

(1) By Pratik (pratik074) on 2021-09-28 19:05:27 [link] [source]

As per this URL: https://sqlite.org/tempfiles.html

we can change the value of sqlite3_temp_directory to change the location of where sqlite create temporary files. Can someone tell me how I can do this in windows? Should I create new environment variable and assign folder path?

(2) By Larry Brasfield (larrybr) on 2021-09-28 19:17:47 in reply to 1 [source]

You need to study "Name Of The Folder Holding Temporary Files", carefully.

In my opinion, if you are going to takeover that decision, you may as well do it decisively rather than indirectly via an environment variable.

Please note that these comments do not constitute any condonation contravening the cautions mentioned in the above-linked doc page.