Ports - installation & upgrade history
cswiger at mac.com
Tue Nov 30 19:15:15 UTC 2010
On Nov 30, 2010, at 10:58 AM, David Southwell wrote:
> Seems to me that a comprehensive record would be extremely useful on a local system. I am wondering how difficult it might be to collect data from applications such as:
> cvsup of ports tree
> changes to /var/db/ports
> changes to /usr/ports/distfiles
It's not difficult. The normal way people track changes to filesystems over time is by making backups (or snapshots, or other equivalents). The normal way people track process execution is accton / sa.
> The results could be held in a mysql database.
I suppose...MySQL isn't particularly efficient at dealing with large numbers of BLOBs, which is what importing filesystem-tree changes would probably become. You'd likely end up with a MySQL database which grows to be many orders of magnitude bigger than the size of /var/db/ports + whatever under /usr/ports.
Things like CVS or Subversion better understand how to represent the list of deltas representing the changes than MySQL does. Good backup software which understands dedup'ing, things like mbox format, etc can also track changes more efficiently than a naive method of keeping around a copy of every file every time it changes.
More information about the freebsd-ports