Re: [sqlite] Setting temp location with Python
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
Re: [sqlite] Setting temp location with Python
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
Re: [sqlite] Setting temp location with Python
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. -- #define QUESTION ((bb) || (!bb)) /* Shakespeare */ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Setting temp location with Python
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? Thanks, Jonathan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
