From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
---|---|
To: | Gabriele Bartolini <gabriele(dot)bartolini(at)2ndquadrant(dot)it> |
Cc: | PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: Rough estimate of number of downloads per year/month/day? |
Date: | 2012-10-25 15:11:38 |
Message-ID: | CAK3UJRHy_wyTnR59njAZ0SH2-h57qQoBe8824dqmfTsqS_AYsQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
On Thu, Oct 25, 2012 at 3:32 AM, Gabriele Bartolini
<gabriele(dot)bartolini(at)2ndquadrant(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Ambler | 2012-10-26 08:18:54 | Re: Rough estimate of number of downloads per year/month/day? |
Previous Message | Jonathan S. Katz | 2012-10-25 13:11:29 | Re: Rough estimate of number of downloads per year/month/day? |