On 4/4/24 15:36, Przemek Klosowski via devel wrote:
On 4/3/24 17:49, Kevin Kofler via devel wrote:

And is there a statistical evaluation of that data somewhere? Downloading
350 MiB (!) of raw CSV data does not sound to me like a convenient way to
work with it.

It's messy, but interesting. Here's the architecture data for the last 3 or so years:

from top to bottom, x86_64 aarch64 ppc64le s390x armhfp i386 arm powerpc64 riscv64

so you can see the decline of armhfp and i386.

I don't know what to make of the relatively large population of ppc64le and s390x; I think maybe IBM is eating their own dogfood and using it in some internal datacenters?

I am pleased to see RISC-V showing up within last year!

Very impressive. I tried to make a table of output using a Python script and it ended up being so inefficient for reasons I don't understand (a bug in my code possibly/likely) that I couldn't get the final report to ever come out.

sqlite -csv :memory:

.import totals.csv t

select date(round(julianday(week_end)/30)*30) as Tx, count(os_arch) filter (where os_arch like "x86_64") as x86_64, count(os_arch) filter (where os_arch like "aarch64") as aarch64,  count(os_arch) filter (where os_arch like "ppc64le") as ppc64le, count(os_arch) filter (where os_arch like "s390x") as s390x,  count(os_arch) filter (where os_arch like "armhfp") as armhfp, count(os_arch) filter (where os_arch like "i386") as i386,count(os_arch) filter (where os_arch like "arm") as arm, count(os_arch) filter (where os_arch like "powerpc64") as powerpc64, count(os_arch) filter (where os_arch like "riscv64") as riscv64 from t group by tx




--
_______________________________________________
devel mailing list --devel@lists.fedoraproject.org
To unsubscribe send an email todevel-le...@lists.fedoraproject.org
Fedora Code of 
Conduct:https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines:https://fedoraproject.org/wiki/Mailing_list_guidelines
List 
Archives:https://lists.fedoraproject.org/archives/list/devel@lists.fedoraproject.org
Do not reply to spam, report 
it:https://pagure.io/fedora-infrastructure/new_issue

--
Aaron Rainbolt
Lubuntu Developer
Matrix: @arraybolt3:ubuntu.com
IRC: arraybolt3 on libera.chat and oftc.net
GitHub:https://github.com/ArrayBolt3
--
_______________________________________________
devel mailing list -- devel@lists.fedoraproject.org
To unsubscribe send an email to devel-le...@lists.fedoraproject.org
Fedora Code of Conduct: 
https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: 
https://lists.fedoraproject.org/archives/list/devel@lists.fedoraproject.org
Do not reply to spam, report it: 
https://pagure.io/fedora-infrastructure/new_issue

Reply via email to