First iteration of schema checker page
What does this MR do and why?
This adds a schema checker diagnostic in addition to the collation checker diagnostic in /admin/database_diagnostics
.
This is the frontend part. The backend has been split off to !200156 (merged).
References
Screenshots or screen recordings
How to set up and validate locally
- Checkout this branch.
- Navigate to
/admin/database_diagnostics
. - Click on
Run Schema Check
. - You should see no issues.
- If you want to create an issue, you can run
gdk psql
and drop an index:
DROP INDEX index_abuse_events_on_user_id;
- Now click on
Run Schema Check
again. - You should see now a missing index.
- Add back the index in
gdk psql
:
CREATE INDEX index_abuse_events_on_user_id ON abuse_events USING btree (user_id);
MR acceptance checklist
Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Edited by Stan Hu