AskGit is a tool looking for more (interesting) use cases.
This gist takes a look at the email domains of contributors to two major open source code bases (Linux and Kubernetes).
askgit-query.sql can be piped into the askgit command to produce the output in k8s-SHA.txt and linux-SHA.txt
Commit Count is the total number of commits by contributors with an email address from DomainUnique Emails is the number of unique contributors with an email from DomainDomain is the email domain| SELECT sum(num) AS commit_count, count(DISTINCT author_email) AS unique_emails, domain FROM ( | |
| SELECT | |
| count(*) AS num, | |
| author_email, | |
| substr(author_email, instr(author_email, '@')+1) AS domain | |
| FROM commits GROUP BY author_email ORDER BY count(*) DESC | |
| ) GROUP BY domain ORDER BY unique_emails DESC LIMIT 100 |
| +--------------+---------------+--------------------------+ | |
| | COMMIT COUNT | UNIQUE EMAILS | DOMAIN | | |
| +--------------+---------------+--------------------------+ | |
| | 14400 | 1094 | gmail.com | | |
| | 27604 | 322 | google.com | | |
| | 8858 | 170 | redhat.com | | |
| | 27414 | 158 | users.noreply.github.com | | |
| | 1021 | 69 | vmware.com | | |
| | 823 | 46 | microsoft.com | | |
| | 1443 | 42 | huawei.com | | |
| | 1171 | 38 | zte.com.cn | | |
| | 445 | 35 | qq.com | | |
| | 533 | 32 | intel.com | | |
| | 188 | 31 | hotmail.com | | |
| | 497 | 29 | coreos.com | | |
| | 178 | 29 | 163.com | | |
| | 100 | 27 | outlook.com | | |
| | 134 | 25 | daocloud.io | | |
| | 256 | 22 | us.ibm.com | | |
| | 97 | 21 | amazon.com | | |
| | 95 | 17 | tencent.com | | |
| | 121 | 15 | mirantis.com | | |
| | 144 | 15 | cn.ibm.com | | |
| | 121 | 15 | baidu.com | | |
| | 24 | 11 | yahoo.com | | |
| | 28 | 11 | sap.com | | |
| | 53 | 11 | pivotal.io | | |
| | 430 | 11 | cn.fujitsu.com | | |
| | 180 | 11 | canonical.com | | |
| | 145 | 11 | caicloud.io | | |
| | 58 | 10 | ebay.com | | |
| | 28 | 10 | alauda.io | | |
| | 158 | 9 | zju.edu.cn | | |
| | 91 | 9 | live.com | | |
| | 43 | 9 | docker.com | | |
| | 18 | 9 | 126.com | | |
| | 58 | 8 | suse.com | | |
| | 172 | 8 | mesosphere.io | | |
| | 14 | 8 | ghostcloud.cn | | |
| | 38 | 7 | tigera.io | | |
| | 87 | 7 | qiniu.com | | |
| | 185 | 7 | ibm.com | | |
| | 17 | 7 | hpe.com | | |
| | 67 | 7 | heptio.com | | |
| | 137 | 7 | easystack.cn | | |
| | 31 | 7 | datadoghq.com | | |
| | 50 | 7 | cmss.chinamobile.com | | |
| | 90 | 7 | cisco.com | | |
| | 23 | 7 | apcera.com | | |
| | 19 | 6 | rackspace.com | | |
| | 11 | 6 | me.com | | |
| | 8 | 6 | kinvolk.io | | |
| | 17 | 6 | inspur.com | | |
| | 15 | 6 | est.fujitsu.com | | |
| | 204 | 6 | beyondcent.com | | |
| | 278 | 5 | weave.works | | |
| | 18 | 5 | ts.fujitsu.com | | |
| | 7 | 5 | spotify.com | | |
| | 7 | 5 | samsung.com | | |
| | 40 | 5 | salesforce.com | | |
| | 18 | 5 | metaswitch.com | | |
| | 14 | 5 | linux.com | | |
| | 19 | 5 | india.nec.com | | |
| | 65 | 5 | in.ibm.com | | |
| | 12 | 5 | icloud.com | | |
| | 15 | 5 | foxmail.com | | |
| | 128 | 5 | cloudbasesolutions.com | | |
| | 109 | 5 | apprenda.com | | |
| | 157 | 5 | apache.org | | |
| | 45 | 5 | alibaba-inc.com | | |
| | 10 | 4 | zalando.de | | |
| | 7 | 4 | yeah.net | | |
| | 8 | 4 | vn.fujitsu.com | | |
| | 7 | 4 | squareup.com | | |
| | 15 | 4 | rancher.com | | |
| | 8 | 4 | protonmail.com | | |
| | 29 | 4 | portworx.com | | |
| | 24 | 4 | oracle.com | | |
| | 13 | 4 | lyft.com | | |
| | 192 | 4 | ii.coop | | |
| | 23 | 4 | hp.com | | |
| | 23 | 4 | googlemail.com | | |
| | 19 | 4 | globant.com | | |
| | 14 | 4 | endocode.com | | |
| | 6 | 4 | cern.ch | | |
| | 80 | 4 | amadeus.com | | |
| | 6 | 3 | zlab.co.jp | | |
| | 5 | 3 | wanda.cn | | |
| | 7 | 3 | soundcloud.com | | |
| | 10 | 3 | sky.uk | | |
| | 5 | 3 | netapp.com | | |
| | 3 | 3 | navercorp.com | | |
| | 26 | 3 | jp.fujitsu.com | | |
| | 83 | 3 | infoblox.com | | |
| | 8 | 3 | golang.org | | |
| | 70 | 3 | atlassian.com | | |
| | 26 | 3 | arm.com | | |
| | 2 | 2 | yandex.ru | | |
| | 3 | 2 | windriver.com | | |
| | 37 | 2 | umich.edu | | |
| | 2 | 2 | uk.ibm.com | | |
| | 7 | 2 | twosigma.com | | |
| | 3 | 2 | syseleven.de | | |
| +--------------+---------------+--------------------------+ |
| +--------------+---------------+-----------------------+ | |
| | COMMIT COUNT | UNIQUE EMAILS | DOMAIN | | |
| +--------------+---------------+-----------------------+ | |
| | 90350 | 5207 | gmail.com | | |
| | 53978 | 1221 | intel.com | | |
| | 52777 | 509 | redhat.com | | |
| | 12262 | 464 | google.com | | |
| | 19500 | 422 | amd.com | | |
| | 6102 | 328 | codeaurora.org | | |
| | 9999 | 304 | huawei.com | | |
| | 10964 | 295 | linux.vnet.ibm.com | | |
| | 14583 | 284 | ti.com | | |
| | 12693 | 278 | samsung.com | | |
| | 5552 | 232 | freescale.com | | |
| | 23531 | 229 | linaro.org | | |
| | 20558 | 208 | linux.intel.com | | |
| | 3362 | 206 | marvell.com | | |
| | 7334 | 201 | broadcom.com | | |
| | 14206 | 185 | oracle.com | | |
| | 5155 | 172 | chromium.org | | |
| | 10517 | 171 | mellanox.com | | |
| | 4632 | 158 | nxp.com | | |
| | 5997 | 153 | nvidia.com | | |
| | 3544 | 142 | gmx.de | | |
| | 2868 | 139 | googlemail.com | | |
| | 8542 | 137 | arm.com | | |
| | 2887 | 132 | us.ibm.com | | |
| | 2092 | 126 | mediatek.com | | |
| | 2857 | 123 | nokia.com | | |
| | 1134 | 108 | stericsson.com | | |
| | 3232 | 105 | linux.ibm.com | | |
| | 2233 | 103 | hp.com | | |
| | 3008 | 102 | qlogic.com | | |
| | 23586 | 98 | kernel.org | | |
| | 19315 | 94 | suse.de | | |
| | 5386 | 93 | canonical.com | | |
| | 2991 | 92 | st.com | | |
| | 5356 | 89 | suse.com | | |
| | 5336 | 88 | de.ibm.com | | |
| | 387 | 87 | yahoo.com | | |
| | 1726 | 83 | cavium.com | | |
| | 2365 | 82 | windriver.com | | |
| | 2649 | 78 | sgi.com | | |
| | 722 | 76 | gmx.net | | |
| | 3359 | 69 | cisco.com | | |
| | 3432 | 67 | cn.fujitsu.com | | |
| | 1273 | 65 | xilinx.com | | |
| | 3323 | 64 | fb.com | | |
| | 530 | 63 | web.de | | |
| | 1259 | 61 | vmware.com | | |
| | 2006 | 60 | synopsys.com | | |
| | 282 | 59 | hotmail.com | | |
| | 5463 | 57 | renesas.com | | |
| | 2315 | 57 | qca.qualcomm.com | | |
| | 1838 | 57 | microchip.com | | |
| | 1627 | 55 | free.fr | | |
| | 498 | 55 | debian.org | | |
| | 540 | 50 | linux.alibaba.com | | |
| | 1595 | 48 | rock-chips.com | | |
| | 2803 | 48 | iki.fi | | |
| | 2407 | 47 | imgtec.com | | |
| | 671 | 44 | mvista.com | | |
| | 1135 | 44 | gentoo.org | | |
| | 1165 | 44 | citrix.com | | |
| | 435 | 42 | csr.com | | |
| | 362 | 41 | mentor.com | | |
| | 2281 | 39 | microsoft.com | | |
| | 1574 | 39 | chelsio.com | | |
| | 520 | 38 | 163.com | | |
| | 608 | 37 | novell.com | | |
| | 645 | 37 | axis.com | | |
| | 517 | 36 | hisilicon.com | | |
| | 356 | 36 | amazon.com | | |
| | 359 | 35 | zte.com.cn | | |
| | 1698 | 35 | users.sourceforge.net | | |
| | 310 | 35 | hpe.com | | |
| | 158 | 35 | fau.de | | |
| | 2046 | 35 | analog.com | | |
| | 436 | 34 | qti.qualcomm.com | | |
| | 1540 | 34 | jp.fujitsu.com | | |
| | 1355 | 34 | collabora.com | | |
| | 1507 | 32 | realtek.com | | |
| | 764 | 32 | mail.ru | | |
| | 177 | 32 | dell.com | | |
| | 146 | 31 | yandex.ru | | |
| | 5214 | 31 | suse.cz | | |
| | 230 | 31 | alliedtelesis.co.nz | | |
| | 5406 | 30 | pengutronix.de | | |
| | 2813 | 30 | netapp.com | | |
| | 2565 | 30 | atmel.com | | |
| | 981 | 29 | tieto.com | | |
| | 1134 | 29 | emulex.com | | |
| | 2613 | 29 | baylibre.com | | |
| | 1036 | 28 | wdc.com | | |
| | 133 | 28 | cypress.com | | |
| | 514 | 28 | caviumnetworks.com | | |
| | 300 | 27 | avagotech.com | | |
| | 299 | 26 | ubuntu.com | | |
| | 173 | 26 | ni.com | | |
| | 469 | 26 | in.ibm.com | | |
| | 550 | 26 | android.com | | |
| | 113 | 25 | unisoc.com | | |
| | 833 | 25 | ericsson.com | | |
| +--------------+---------------+-----------------------+ |