Hi List, To approach this question from another direction:
Why was this Pragma deprecated (temp_store_directory)? Aside from the possibility of it disappearing in future builds (or current builds built without deprecateds), are there any problems I should anticipate in using it for these purposes? Thanks, Jonathan Hi Kevin, Yep, Item 5.0 was the one I was looking at, but as best I can tell there is no OS-agnostic way of doing it except the PRAGMA. But the pragma has been deprecated so I was wondering what the new, post-deprecation, OS-agnostic solution. Cheers, Jonathan On 11/08/2016 15:42, Kevin O'Gorman wrote: > On Wed, Aug 10, 2016 at 6:50 AM, Jonathan Moules < > jonathan-li...@lightpear.com> wrote: > >> Hi List, >> I'm using Python's sqlite3 library to access a SQLite db. I'd like to >> set the location for the temporary databases in a platform agnostic fashion >> (*nix or Windows). >> >> This page - https://www.sqlite.org/tempfiles.html - gives a number of >> options, but the only good one I can see for using it via Python would be >> the PRAGMA. >> But the docs for PRAGMA temp_store_directory; ( >> https://www.sqlite.org/pragma.html#pragma_temp_store_directory ) say this >> is deprecated. >> >> So what's the recommended way to achieve this? >> >> >> Take a look at https://www.sqlite.org/tempfiles.html, specifically item > 5.0. which addresses this question. It varies a bit depending on your > environment, so there's no single answer. On my Linux system, I fiddle > with the SQLITE_TMPDIR environment variable. > > You might want to describe your environment so that folks with a similar > environment can respond more helpfully. > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
