Adding .db support to pkg_tools

[Joerg Sonnenberger]

On Mon, May 12, 2008 at 08:47:53AM -0700, Jeremy Chadwick wrote:
> Secondly, the following FAQ entry and documentation from Mozilla is of
> concern, specifically the last paragraph of the FAQ entry, since there
> is ongoing work in the ports collection to support parallel building,
> which would surely use fork() or locks):

I don't think this is applicable.

> Thirdly, there is the concern of disk space.  There are a substantial
> number of users who have FreeBSD on embedded systems or systems with
> little or no space, who use binary packages (pkg_add -r), which of
> course still makes use of /var/db/pkg.  SQLite DBs grow over time, and
> don't shrink in size unless you use auto-vacuum mode or execute the
> VACUUM query:

It is trivial to recreate the database, so I don't think this is a
concern either. I should point again that it will result in a
non-trivial increase in size.

> Fourthly, it doesn't sound as if storage SQLite databases on an NFS
> mount is a good idea, and I've a feeling some people have /var NFS
> mounted (diskless systems for example):

Same applies to BDB and basically anything that depends on fcntl to
work. Basically, as long as you have /var per host (you don't share
/var, do you?), it will just work as the *local* locks are working. The
problem with NFS comes form the fact that multiple hosts might not share
them.

Joerg