From owner-freebsd-questions@FreeBSD.ORG Mon Dec 12 07:11:10 2011 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8FC57106564A; Mon, 12 Dec 2011 07:11:10 +0000 (UTC) (envelope-from freebsd@hub.org) Received: from hub.org (hub.org [200.46.204.220]) by mx1.freebsd.org (Postfix) with ESMTP id 3ACAA8FC12; Mon, 12 Dec 2011 07:11:09 +0000 (UTC) Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by hub.org (Postfix) with ESMTP id 4E2F2226B3C; Mon, 12 Dec 2011 02:56:36 -0400 (AST) Received: from hub.org ([200.46.204.220]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 69403-03; Mon, 12 Dec 2011 06:56:29 +0000 (UTC) Received: from [192.168.1.134] (24-246-4-43.cable.teksavvy.com [24.246.4.43]) by hub.org (Postfix) with ESMTPA id 991C4226B3B; Mon, 12 Dec 2011 02:56:28 -0400 (AST) Mime-Version: 1.0 (Apple Message framework v1251.1) From: Hub- FreeBSD In-Reply-To: <1323576406.11525.140661010093757@webmail.messagingengine.com> Date: Mon, 12 Dec 2011 01:56:28 -0500 Message-Id: <214308D4-AB41-4FA5-BF65-4FA94793E496@hub.org> References: <1323576406.11525.140661010093757@webmail.messagingengine.com> To: freebsd-questions@freebsd.org X-Mailer: Apple Mail (2.1251.1) Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: antony@mawer.org, fabrizio@nldesign.com, scrappy@freebsd.org, alex@libman.us Subject: Re: Thank you for bsdstats! X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 12 Dec 2011 07:11:10 -0000 Since this may by of interest to others, including those maintaining = ports, I've just created a dump of the history data for ports and = versions reported in =85 not the reporting ports is optional, there = appears to only be about 10% of the hosts that report in port = information =85 The dump is available at http://www.bsdstats.org/ports.raw.sql.bz2 it contains a postgresql dump of three tables: ports, where id =3D=3D system id (anonymous data, but let's you group data) catid =3D=3D link to port_category (ie. net, www) sw_id =3D=3D link to port_software (ie. apache, perl) the data goes back to '07, so a fair amount of history to look at =85 For those unaware of what BSDstats is, check out http://www.bsdstats.org = *or* /usr/ports/sysutils/bsdstats =85 short summary: An OptIn only site that accumulates statistics on *BSD related usage =85 = as the #s show when you go to the site, it is by no means close to the # = of sites using *BSD ... We are averaging over 6k hosts reporting in each month, for 7 different = variants of *BSD: PC-BSD, FreeBSD, DesktopBSD, DragonflyBSD, NetBSD, OpenBSD and = MidnightBSD=20 To participate is a simple 'make install' in = /usr/ports/sysutils/bsdstats =85 at a minimum, just make sure you enable = it to run monthly out of periodic =85=20 The data collected and stored is done so totally anonymously =85 we = collect no IP *or* hostname information =85 each participate gets an Id = that is stored in a token file that is used for reporting, which also = allows the system to work through proxy / nat, since the individual ID = is generated the first time you connect to the system, and used going = forward =85 On 2011-12-10, at 11:06 PM, Alex Libman wrote: > Dear BSD Stats Team, >=20 > I just wanted to drop you a line and thank you for bsdstats. I run it > on my *BSD installations whenever it is feasible. I am also wondering > if it would be possible to access the aggregate data in a raw format. > I am particularly curious about the ports usage data... >=20 > Best regards, > Alex Libman