sqlite3 temp files

[Joshua Root]

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.

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>