SQLite Forum

Setting temp_store_directory on Windows in future proof way
Login
In order to control where files are written by SQLite, I have a requirement to be able to specify on Windows where any temporary files are written in a future proof way.

PRAGMA temp_store_directory is deprecated and so should not be used..... but there does not seem to be any alternative way specified in the documentation in order to specify the location for temporary files for SQLite on Windows.

What is the correct (non-deprecated) method to use on Windows to specify this?