KernelCI Dashboard Report - September 15 - September 30, 2025

Hello everyone,

In the last two weeks we had improvements for the stability of the
dashboard, as well as other features and bugfixes. Here are the
changes from our last 2-week sprint, all of them are already available
in production:

## Improvements
- Integration tests now use a local database, putting less strain in
the production database and fixing CI runs on PRs from forks - [1]
- TreeLatest and TreeLatestHash endpoints were combined, making the
commit_hash an optional query parameter - [2]
- Added origin field to the test and build details pages for more
information - [3]
- More unit tests were made to improve our backend coverage, including
several files - [4] [5] [6]
- The legend for the status graph now has a better layout for small
screens - [7]

## Bugfixes
- Issues now show the version of their first incident, and also show
incidents of non existing tests - [8]
- Notifications had stopped working, but were fixed at the beginning
of this sprint

## Future Changes
We plan on giving more stability and performance to the database,
starting with basic improvements such as database indexes and then
experimenting with table denormalization, where what you see in the
frontend will have a direct correlation on the database, making the
queries faster. Apart from that, we will continue working on improving
the test coverage of the backend, on the frontend support for smaller
screen sizes, and on other specific issues.


## References
[1] - https://github.com/kernelci/dashboard/issues/1397
[2] - https://github.com/kernelci/dashboard/issues/1476
[3] - https://github.com/kernelci/dashboard/issues/1490
[4] - https://github.com/kernelci/dashboard/issues/1495
[5] - https://github.com/kernelci/dashboard/issues/1499
[6] - https://github.com/kernelci/dashboard/issues/1518
[7] - https://github.com/kernelci/dashboard/issues/1425
[8] - https://github.com/kernelci/dashboard/issues/1290