From owner-freebsd-ports@FreeBSD.ORG Tue Nov 30 19:15:15 2010 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 4AC511065670 for ; Tue, 30 Nov 2010 19:15:15 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from asmtpout025.mac.com (asmtpout025.mac.com [17.148.16.100]) by mx1.freebsd.org (Postfix) with ESMTP id 2F8C58FC12 for ; Tue, 30 Nov 2010 19:15:14 +0000 (UTC) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=us-ascii Received: from cswiger1.apple.com ([17.209.4.71]) by asmtp025.mac.com (Sun Java(tm) System Messaging Server 6.3-7.04 (built Sep 26 2008; 64bit)) with ESMTPSA id <0LCP0090HPH90H50@asmtp025.mac.com> for freebsd-ports@freebsd.org; Tue, 30 Nov 2010 11:15:11 -0800 (PST) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=6.0.2-1010190000 definitions=main-1011300113 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15,1.0.148,0.0.0000 definitions=2010-11-30_10:2010-11-30, 2010-11-30, 1970-01-01 signatures=0 From: Chuck Swiger In-reply-to: <201011301858.11175.david@vizion2000.net> Date: Tue, 30 Nov 2010 11:15:09 -0800 Message-id: <500E66A0-FC50-4867-80E4-D188E45B3B83@mac.com> References: <201011301824.15550.david@vizion2000.net> <201011301841.35462.david@vizion2000.net> <3B286D1E-E7F8-4FF5-85E9-29309A8693C6@mac.com> <201011301858.11175.david@vizion2000.net> To: David Southwell X-Mailer: Apple Mail (2.1082) Cc: freebsd-ports@freebsd.org Subject: Re: Ports - installation & upgrade history X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 30 Nov 2010 19:15:15 -0000 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