From owner-freebsd-ports@FreeBSD.ORG Fri Jan 20 16:29:53 2012 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 28F4B1065675 for ; Fri, 20 Jan 2012 16:29:53 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id 82E1B8FC0C for ; Fri, 20 Jan 2012 16:29:52 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [IPv6:2001:8b0:151:1:fa1e:dfff:feda:c0bb]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id q0KGTntg031694 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Fri, 20 Jan 2012 16:29:49 GMT (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: OpenDKIM Filter v2.4.2 smtp.infracaninophile.co.uk q0KGTntg031694 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1327076989; bh=TT9PvdPhR1OK2B73PqSt+PvAuyxyiko0KZ+O/TzHBO8=; h=Message-ID:Date:From:MIME-Version:To:Subject:Content-Type:Cc: In-Reply-To:References; b=m0BkSftZkzBIcm+odxPjj3Ou7/phgHWAPbLgzaaDJ75tmFC6H5qpDEAP7LKze4LPT lMu9SLcC9KZEqBCXwDmpwvsOOeVKqvZc5FACyv7pgQ6ultu8DgsFHof05SGyCUWZ+f kqJW0UsDi3j8J4Ad+pdiQ1CDjFfGQE0LuuB3Pk3A= Message-ID: <4F199672.8050008@infracaninophile.co.uk> Date: Fri, 20 Jan 2012 16:29:38 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:9.0) Gecko/20111222 Thunderbird/9.0.1 MIME-Version: 1.0 To: freebsd-ports X-Enigmail-Version: 1.3.4 OpenPGP: id=60AE908C Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigF98D2264247AED65ED6CCFE9" X-Virus-Scanned: clamav-milter 0.97.3 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.6 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU autolearn=ham version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Cc: Subject: Doing SQL to the FreeBSD ports index 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: Fri, 20 Jan 2012 16:29:53 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigF98D2264247AED65ED6CCFE9 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Dear all, Apropos nothing much at all, but congruent with some of the discussion going on in this list at the moment, I've been playing around loading ports index related data into a RDBMS and querying that to pull out interesting factoids, or indeed a complete INDEX file. I didn't start doing this with any idea other than my own edification but now it seems it might be vaguely useful here and there, so I've stuck a copy on my website: http://www.infracaninophile.co.uk/articles/portindexdb/ I'd be happy to hear from anyone using this, or receive bug reports / feature requests. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matthew@infracaninophile.co.uk Kent, CT11 9PW --------------enigF98D2264247AED65ED6CCFE9 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk8ZlnwACgkQ8Mjk52CukIwcLwCdE3ucaeVzVVK+AI66+ti8v1kh +zIAn1sn1+SIUWRp0JavYlYq/A0lNtia =R9xR -----END PGP SIGNATURE----- --------------enigF98D2264247AED65ED6CCFE9--