Doing SQL to the FreeBSD ports index

2012-01-20 Thread Matthew Seaman
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 t

Re: Doing SQL to the FreeBSD ports index

2012-01-20 Thread Kurt Jaeger
Hi! > it might be vaguely useful here and there, so I've stuck a copy on my > website: > >http://www.infracaninophile.co.uk/articles/portindexdb/ http://www.infracaninophile.co.uk/articles/portindexdb.html works better 8-) -- p...@opsec.eu+49 171 3101372

Re: Doing SQL to the FreeBSD ports index

2012-01-20 Thread Matthew Seaman
On 20/01/2012 18:20, Kurt Jaeger wrote: > Hi! > >> it might be vaguely useful here and there, so I've stuck a copy on my >> website: >> >>http://www.infracaninophile.co.uk/articles/portindexdb/ > > http://www.infracaninophile.co.uk/articles/portindexdb.html > > works better 8-) > D'Oh! --

Re: Doing SQL to the FreeBSD ports index

2012-01-20 Thread Mark Linimon
You've probably reimplemented part of ports tinderbox (and, separately, portsmon and FreshPorts) :) mcl ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-uns

Re: Doing SQL to the FreeBSD ports index

2012-01-20 Thread Matthew Seaman
On 20/01/2012 19:25, Mark Linimon wrote: > You've probably reimplemented part of ports tinderbox (and, separately, > portsmon and FreshPorts) :) I have this other invention I've been calling 'a rotationally symmetrical device designed to facilitate travel.' Cheers, Matthew -- D

Re: Doing SQL to the FreeBSD ports index

2012-01-20 Thread dgmm
On Friday 20 January 2012, Matthew Seaman wrote: >On 20/01/2012 19:25, Mark Linimon wrote: >> You've probably reimplemented part of ports tinderbox (and, separately, >> portsmon and FreshPorts) :) > >I have this other invention I've been calling 'a rotationally >symmetrical device designed to facil

Re: Doing SQL to the FreeBSD ports index

2012-01-27 Thread rflynn
Hi, > 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 > doin

Re: Doing SQL to the FreeBSD ports index

2012-01-29 Thread Matthew Seaman
On 28/01/2012 02:05, rfl...@acsalaska.net wrote: > I haven't looked in detail - perl has to leave my head - but what I think > is a good feature for a database to handle is to find outdated distfiles. > > Since the relationship between a portorigin and it's distfile(s) is not > available otherwise