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
> portupgrade/portmaster 
> 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.

-- 
-Chuck

_______________________________________________
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"

Reply via email to