Re: [sqlite] Proper way to change temp directory

2011-11-21 Thread Don V Nielsen 
In Ruby (just for giggles), its

Dir.chdir('dir text') {|dir|
  # do your sort stuff here
}  # previous directory restored when logic block is completed




On Sun, Nov 20, 2011 at 3:50 AM, Yang Zhang  wrote:

> Cool beans, perhaps this should be added to the docs!
>
> On Sun, Nov 20, 2011 at 1:36 AM, Dan Kennedy 
> wrote:
> > On 11/20/2011 04:00 PM, Yang Zhang wrote:
> >>
> >> Out of curiosity, what's the proper way to change the temp directory
> >> (say, to avoid "Error: database or disk full" errors on vacuum, which
> >> I ran into)?  temp_store_directory has been working for me but it's
> >> deprecated and may be elided from builds.  Is the only option to
> >> recompile sqlite?  Thanks.
> >
> > On unix setting the TMPDIR environment variable works.
> >
> > On windows SQLite uses GetTempPath(). So perhaps setting
> > TMP or TEMP works there.
> >
> >
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> Yang Zhang
> http://yz.mit.edu/
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proper way to change temp directory

2011-11-20 Thread Yang Zhang 
Cool beans, perhaps this should be added to the docs!

On Sun, Nov 20, 2011 at 1:36 AM, Dan Kennedy  wrote:
> On 11/20/2011 04:00 PM, Yang Zhang wrote:
>>
>> Out of curiosity, what's the proper way to change the temp directory
>> (say, to avoid "Error: database or disk full" errors on vacuum, which
>> I ran into)?  temp_store_directory has been working for me but it's
>> deprecated and may be elided from builds.  Is the only option to
>> recompile sqlite?  Thanks.
>
> On unix setting the TMPDIR environment variable works.
>
> On windows SQLite uses GetTempPath(). So perhaps setting
> TMP or TEMP works there.
>
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Yang Zhang
http://yz.mit.edu/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proper way to change temp directory

2011-11-20 Thread Dan Kennedy 

On 11/20/2011 04:00 PM, Yang Zhang wrote:

Out of curiosity, what's the proper way to change the temp directory
(say, to avoid "Error: database or disk full" errors on vacuum, which
I ran into)?  temp_store_directory has been working for me but it's
deprecated and may be elided from builds.  Is the only option to
recompile sqlite?  Thanks.


On unix setting the TMPDIR environment variable works.

On windows SQLite uses GetTempPath(). So perhaps setting
TMP or TEMP works there.





___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Proper way to change temp directory

2011-11-20 Thread Yang Zhang 
Out of curiosity, what's the proper way to change the temp directory
(say, to avoid "Error: database or disk full" errors on vacuum, which
I ran into)?  temp_store_directory has been working for me but it's
deprecated and may be elided from builds.  Is the only option to
recompile sqlite?  Thanks.

-- 
Yang Zhang
http://yz.mit.edu/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users