Re: [gentoo-dev] bug queue size over time

[Alec Warner]

On Tue, Mar 20, 2018 at 12:24 AM, Kent Fredric <kentnl@g.o> wrote:

> On Mon, 19 Mar 2018 19:33:11 -0700
> "Paweł Hajdan, Jr." <phajdan.jr@g.o> wrote:
>
> > Is it possible to get graphs of bugs.g.o bug queue size for certain
> > query (e.g. by assignee) over time?
> >
> > Best,
> > Paweł
> >
>
> The *data* is there to do it, but its a bit of a pain, you have to
> extract all the individual "changed" events and then use that to reason
> about each individual bugs state at a given time, and use *that* to
> deduce how many open bugs there *were* at a historical moment.
>
> And that's a lot of painful queries for the REST API.
>

I'd avoid the REST API here. If you want this data; I'd consider filing a
bug. Infra can do stuff like run nightly reports for this information and
hang them off of endpoints you can access.
This works well for public bugs; and not well for private ones.


>
> I've done something like this before with Perl bugs[1], but again, very
> painful, slow and time consuming.
>
> This sort of thing would be *much* easier if we could have direct bulk
> access to the underlying MYSQL store, but that's a tricky thing to do
> because:
>
> 1. Its MySQL
> 2. Some bugs have visibility restrictions that have to be factored for
>

In this way, you can download the (likely hundreds of megs) of JSON or
whatever, and do the sorting / filtering / timeseries work on the client
end?

Its not great I suspect, but it saves everyone hamming the database.

-A

>
> ----
>
> Note: these pages are very browser taxing:
>
> 1: https://docs.google.com/spreadsheets/d/1mm8iYE77SRh-
> q2jOfKNSWHUetswEABJawp-94UyTHio/edit?usp=sharing
>
>
>
>
>
>