[sqlite] pragma temp_store_directory is deprecated, what is the alternative?

[Clemens Ladisch]

Simon Slavin wrote:
> both platforms use whatever the expected variable name was for that OS.

Unix:
1. #pragma temp_store_directory
2. getenv("SQLITE_TMPDIR")
3. getenv("TMPDIR")
4. /var/tmp
5. /usr/tmp
6. /tmp

Cygwin:
1. #pragma temp_store_directory
2. getenv("SQLITE_TMPDIR")
3. getenv("TMPDIR")
4. getenv("TMP")
5. getenv("TEMP")
6. getenv("USERPROFILE")
7. /var/tmp
8. /usr/tmp
9. /tmp

Windows:
1. #pragma temp_store_directory
2. GetTempPath(), which is documented to return:
   a. getenv("TMP")
   b. getenv("TEMP")
   c. getenv("USERPROFILE")
   d. the Windows directory


Regards,
Clemens