Re: [sqlite] Setting temp location with Python

2016-08-19 Thread Jonathan Moules
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

Re: [sqlite] Setting temp location with Python

2016-08-13 Thread 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

Re: [sqlite] Setting temp location with Python

2016-08-11 Thread Kevin O'Gorman
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 -