sqlite3 temp files

[Joshua Root]

On 2010-5-19 05:55 , Joshua Root wrote:
> Whenever a port is installed with registry2.0, a few files named like
> /private/var/tmp/etilqs_IP9NDJcYHrXhFa2 are created by sqlite. (You
> can't see them in the filesystem because it unlinks them; you have to
> use e.g. lsof.) If you install a lot of ports in one port(1) invocation,
> it can run out of fds. [1]
> 
> The files go away when the subinterpreter is deleted (which triggers an
> sqlite3_close() call). The way things work currently, it's not really
> possible to delete the subinterpreters for dependencies before all of
> them are installed.

I hacked around this limitation, so the immediate problem is fixed.
Still very interested if anyone knows how to make this stuff work right.

> It's meant to be possible to tell sqlite to use memory instead of
> temporary files using the temp_store pragma. I've tried setting this
> everywhere I can think of and it doesn't seem to stop the files being used.
> 
> Can anyone provide some help here?
> 
> - Josh
> 
> [1] <http://trac.macports.org/ticket/24857>