KernelCI Dashboard Report - July 24 - August 11, 2025

Hello everyone,

In the last weeks, we have been focused on the transition of KCIDB-ng
to the dashboard backend as an Azure Managed PostgreSQL. KCIDB-ng will
remain as the API for submitters to send their results in json files.
Production deployment will take a few weeks.

The preparation required some time from the Dashboard team to
understand the DB setup better and configure it well, alongside other
improvements that we worked on during this time.

## Database changes
- The new database was created and is managed by our backend with
Django ORM; its integration is being tested. [1]
- In order to move the database quickly, the new instance had its
foreign key constraints removed, making it more similar to kcidb. [2]
- Some schema changes were suggested, still needs some discussion as
to which will be implemented. [3]
- We are bringing the tool that parses submission data (the ingester)
into the dashboard repository, including some changes to allow for
insertion directly into the new database. [4]

## Improvements
- On the tree-report endpoint, it is now possible to specify the
interval to get checkouts and related tests. [5]
- The build, test and issue details pages were redesigned to have
better readability and organization. [6]
- The response from the issue extras endpoint was improved to be clearer. [7]

## Technical Debts
- Some tree endpoints had their code refined to allow for more
specific documentation. [8]

## Future changes
We plan to keep working on the transition to a new deployment for the
database, providing better performance for the queries and the
dashboard consequently. In parallel, some improvements will continue
to be made.

References
[1] https://github.com/kernelci/dashboard/issues/1332
[2] https://github.com/kernelci/dashboard/issues/1382
[3] https://github.com/kernelci/dashboard/issues/1334
[4] https://github.com/kernelci/dashboard/pull/1372
[5] https://github.com/kernelci/dashboard/pull/1374
[6] https://github.com/kernelci/dashboard/issues/1347
[7] https://github.com/kernelci/dashboard/issues/1335
[8] https://github.com/kernelci/dashboard/issues/1317