Re: Rough estimate of number of downloads per year/month/day?

On Thu, Oct 25, 2012 at 3:32 AM, Gabriele Bartolini
<gabriele.bartolini@2ndquadrant.it> wrote:
> I know this is the 1 million dollar question and we miss most of the data.
>
> But I'd love to have some numbers about the downloads from the community
> website. Something like: number of downloads in 2012 so far, or a daily
> average in 2012 or something like that. If you have a series of data per
> day, that'd be cool.
>
> The reason is that today an open source conference is takin place in Italy
> and it was reported that MySQL has 70000 downloads per day. I have asked
> more information about the source and the specific product, but I'd love to
> have a number about PostgreSQL (even if partial).

If you're looking for a rough (but still apples-to-apples) Postgres
vs. MySQL estimate, what about using Debian popcon? Looking at this
listing:
  http://popcon.debian.org/by_inst

For MySQL client:
$ cat by_inst.txt | grep -i mysql | grep -i client  | perl -pi -e
's/\d+\s+[\S]+\s+(\d+).+$/$1/' | awk '{s+=$1} END {print s}'
183654

For PostgreSQL client:
$ cat by_inst.txt | grep -i postgres | grep -i -E '(client)|(libpq)' |
perl -pi -e 's/\d+\s+[\S]+\s+(\d+).+$/$1/' | awk '{s+=$1} END {print
s}'
122026

For MySQL server:
$ cat by_inst.txt | grep -i mysql | grep -i server  | perl -pi -e
's/\d+\s+[\S]+\s+(\d+).+$/$1/' | awk '{s+=$1} END {print s}'
113256

For PostgreSQL server, tallying by hand*:
postgresql-common (19355) + postgresql (14895) + postgresql-8.4
(11058) + postgresql-9.1 (4315) + postgrsql-8.3 (3059) +
postgresql-9.0 (865) = 53547
* ignoring some uncommon variants less popular than all these

I'm not totally familiar with popcon and the Debian packaging
conventions, so apologies if I double-counted some packages or
otherwise mangled the counts.

Josh