From owner-freebsd-vuxml@FreeBSD.ORG Sun Aug 22 20:53:26 2004 Return-Path: Delivered-To: freebsd-vuxml@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 535E916A4CE; Sun, 22 Aug 2004 20:53:26 +0000 (GMT) Received: from fillmore.dyndns.org (port-212-202-50-15.dynamic.qsc.de [212.202.50.15]) by mx1.FreeBSD.org (Postfix) with ESMTP id 194A943D49; Sun, 22 Aug 2004 20:53:26 +0000 (GMT) (envelope-from eikemeier@fillmore-labs.com) Received: from dhcp-8.local ([172.16.0.8] helo=dhcp-10.local) by fillmore.dyndns.org with esmtp (TLSv1:DES-CBC3-SHA:168) (Exim 4.41 (FreeBSD)) id 1ByzL9-000MJT-T1; Sun, 22 Aug 2004 22:53:25 +0200 Date: Sun, 22 Aug 2004 22:53:26 +0200 Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v482) To: "Jacques A. Vidrine" From: Oliver Eikemeier In-Reply-To: <20040822192915.GA17478@madman.celabo.org> Message-Id: <50BEFF1D-F47D-11D8-8CAA-00039312D914@fillmore-labs.com> Content-Transfer-Encoding: 7bit User-Agent: KMail/1.5.9 cc: freebsd-vuxml@freebsd.org cc: ports@freebsd.org cc: Dan Langille Subject: Re: database tables for VuXML X-BeenThere: freebsd-vuxml@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Documenting security issues in VuXML List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 22 Aug 2004 20:53:26 -0000 Jacques A. Vidrine wrote: > The `ranges' table perhaps looks erm interesting. In this case, > I encoded each package version number into four 32-bit integers. > This allowed one to lookup an affected package completely in SQL. > However, the encoding I used may now be incorrect in some ways, since > pkg_install et al were recently changed to treat version numbers > differently. I can just donate some code that converts version numbers into arbitrary precision floting point numbers between zero and one. An alternate (and maybe easier to handle) form are hex strings which can simply compared with strcmp. >> description text not null, FWIIW, I would prefer to have a null description that is replaced by some dummy text when rendering. >> date_discovery date , That same here: don't assume a valid date (or map non-existing dates to 1970-1-1). The reason is that I want to have a form of `quick' entries, which are not fully reviewed. > I think this is also easier to > modify if we get new children of , e.g. the and > tags that are currently in the VuXML pre-1.2 DTD. Ehm, is the DTD somewhere available form review? And how about the csh-style braces / tags suggested in ? -Oliver