Countme integration on the image websites

T

tulip•2/8/25, 10:53 PM

hell yeah

J

j0rge•2/8/25, 10:53 PM

https://github.com/ublue-os/countme

GitHub

GitHub - ublue-os/countme: countme

countme . Contribute to ublue-os/countme development by creating an account on GitHub.

J

j0rge•2/8/25, 10:53 PM

I am ready to recklessly merge whatever you PR

T

tulip•2/8/25, 10:53 PM

@j0rge @imbev @antheas @Niklas

since you guys were already there seeing this conversation

Jj0rge https://github.com/ublue-os/countme

R

RoyalOughtness•2/9/25, 1:35 AM

oooh this looks cool

R

RoyalOughtness•2/9/25, 1:36 AM

ive been poking around the countme db recently and was hoping there was a visualizer for it

R

RoyalOughtness•2/9/25, 1:36 AM

so i may steal this

R

RoyalOughtness•2/9/25, 1:36 AM

also reminder that hits != hosts

R

RoyalOughtness•2/9/25, 1:36 AM

e.g.

select date(2440591.5+weeknum*7) as week_start,
       os_name, os_version, os_variant, os_arch, sys_age,
       sum(hits) as totalhits, max(hits) as hosts
from countme_totals
where os_name == 'Fedora' and os_version=='31' and os_arch=='x86_64' and weeknum==2636
group by os_name, os_version, os_variant, os_arch, sys_age;

select date(2440591.5+weeknum*7) as week_start,
       os_name, os_version, os_variant, os_arch, sys_age,
       sum(hits) as totalhits, max(hits) as hosts
from countme_totals
where os_name == 'Fedora' and os_version=='31' and os_arch=='x86_64' and weeknum==2636
group by os_name, os_version, os_variant, os_arch, sys_age;

select date(2440591.5+weeknum*7) as week_start,
       os_name, os_version, os_variant, os_arch, sys_age,
       sum(hits) as totalhits, max(hits) as hosts
from countme_totals
where os_name == 'Fedora' and os_version=='31' and os_arch=='x86_64' and weeknum==2636
group by os_name, os_version, os_variant, os_arch, sys_age;

select date(2440591.5+weeknum*7) as week_start,
       os_name, os_version, os_variant, os_arch, sys_age,
       sum(hits) as totalhits, max(hits) as hosts
from countme_totals
where os_name == 'Fedora' and os_version=='31' and os_arch=='x86_64' and weeknum==2636
group by os_name, os_version, os_variant, os_arch, sys_age;

J

j0rge•2/9/25, 2:10 AM

yea whatever it's measuring we should put as the label

RRoyalOughtness also reminder that hits != hosts

A

antheas•2/9/25, 7:21 AM

Hits == hosts

Aantheas Hits == hosts

R

RoyalOughtness•2/9/25, 7:22 AM

is this out of date? https://github.com/wgwoods/fedora-countme-data?tab=readme-ov-file#counting-hits-vs-hosts

A

antheas•2/9/25, 7:23 AM

No, it just tells you that the number might need to be scaled

A

antheas•2/9/25, 7:23 AM

Also the rpm ostree timer is more stable than dnf for reporting hits

A

antheas•2/9/25, 7:23 AM

So you will see spikes with fedora workstation you don't see with tbjs

Aantheas No, it just tells you that the number might need to be scaled

R

RoyalOughtness•2/9/25, 7:23 AM

scaled down you mean?

A

antheas•2/9/25, 7:23 AM

Up

Aantheas Also the rpm ostree timer is more stable than dnf for reporting hits

R

RoyalOughtness•2/9/25, 7:23 AM

oh i see

R

RoyalOughtness•2/9/25, 7:23 AM

hmm

R

RoyalOughtness•2/9/25, 7:24 AM

so i shouldn't be using max(hits)?

A

antheas•2/9/25, 7:25 AM

For fedora atomic use my script

A

antheas•2/9/25, 7:25 AM

It sums the fedora repos

A

antheas•2/9/25, 7:26 AM

Just the main fedora one, no fedora-updates

A

antheas•2/9/25, 7:26 AM

So it's correct

Aantheas For fedora atomic use my script

R

RoyalOughtness•2/9/25, 7:26 AM

alright, let me try to convert it to sql

A

antheas•2/9/25, 7:26 AM

It's not worth it SQL is just slower

A

antheas•2/9/25, 7:26 AM

Just make a secure blue version and put it in an action

R

RoyalOughtness•2/9/25, 7:27 AM

lemme try it locally

Aantheas Just make a secure blue version and put it in an action

R

RoyalOughtness•2/9/25, 7:37 AM

hrm, getting keyerrors

gonna go back to sql i think

    plt.plot(res.index, res.values, label=f"{os} ({res[res.index.max()] / 1000:.1f}k)")  # type: ignore
                                                   ~~~^^^^^^^^^^^^^^^^^

    plt.plot(res.index, res.values, label=f"{os} ({res[res.index.max()] / 1000:.1f}k)")  # type: ignore
                                                   ~~~^^^^^^^^^^^^^^^^^

    plt.plot(res.index, res.values, label=f"{os} ({res[res.index.max()] / 1000:.1f}k)")  # type: ignore
                                                   ~~~^^^^^^^^^^^^^^^^^

    plt.plot(res.index, res.values, label=f"{os} ({res[res.index.max()] / 1000:.1f}k)")  # type: ignore
                                                   ~~~^^^^^^^^^^^^^^^^^

A

antheas•2/9/25, 7:38 AM

Probably messed up the os name or something

Aantheas Probably messed up the os name or something

R

RoyalOughtness•2/9/25, 7:38 AM

for fig, oss in [
    ("secureblue", ["secureblue"]),
]:

for fig, oss in [
    ("secureblue", ["secureblue"]),
]:

for fig, oss in [
    ("secureblue", ["secureblue"]),
]:

for fig, oss in [
    ("secureblue", ["secureblue"]),
]:

R

RoyalOughtness•2/9/25, 7:38 AM

idk what fig and oss are

R

RoyalOughtness•2/9/25, 7:38 AM

so i guessed

A

antheas•2/9/25, 7:38 AM

Do you edit your release file?

R

RoyalOughtness•2/9/25, 7:38 AM

yup

A

antheas•2/9/25, 7:40 AM

It's ("figname", ["os1", "os2", ...])

A

antheas•2/9/25, 7:40 AM

So if I look into os variant there should be secure blue hits?

Aantheas So if I look into os variant there should be secure blue hits?

R

RoyalOughtness•2/9/25, 7:40 AM

yep

A

antheas•2/9/25, 7:41 AM

Bruh

R

RoyalOughtness•2/9/25, 7:41 AM

?

R

RoyalOughtness•2/9/25, 7:41 AM

what

A

antheas•2/9/25, 7:41 AM

Os variant

A

antheas•2/9/25, 7:41 AM

Change os variant to os name

R

RoyalOughtness•2/9/25, 7:41 AM

wdym

A

antheas•2/9/25, 7:42 AM

Look at the column names

A

antheas•2/9/25, 7:42 AM

Bazzite has os name fedora

A

antheas•2/9/25, 7:42 AM

We don't use os name

Aantheas Bazzite has os name fedora

R

RoyalOughtness•2/9/25, 7:42 AM

negative

A

antheas•2/9/25, 7:43 AM

I don't remember why I did t use that

A

antheas•2/9/25, 7:43 AM

I think it's because it's the pretty name

Countme integration on the image websites

Similar Threads

Similar Threads

Similar Threads