On Mon, Jul 27, 2015 at 12:28 PM, Richard Hipp <drh at sqlite.org> wrote: > On 7/27/15, Paolo Bolzoni <paolo.bolzoni.brown at gmail.com> wrote: >> I found the temp_store_directory, but it is deprecated. So I was wondering, >> what is the suggested alternative? > > Set the TEMP environment variable to the location of your temporary > storage area.
Thank you, I was wondering on this too. Can you please document this right at that pragma on the pragmas page "http://sqlite.org/pragma.html#pragma_temp_store_directory"; ? Does this work with the same environment variable name on both unix and windows? I'm asking because unix and windows programs each use different conventions for what environment variable to care about when determining the temporary directory, and these conventions differ on unix and windows, though I believe TEMP is the customary variable on windows (it comes from back when the DOS shell stored pipe data there). Tangentially related, is there a way to set a limit the size of temporary files sqlite3 will create, such as with a pragma or sqlite3_limit call? I've asked this already around 2015-05-18, but I don't think I've got an answer. -- Zsb?n Ambrus
