[feature-request]: add search to schema checks

[huv1k]

It would simplify the workflow of searching schema checks with one type. Trying to find a check that contains specific changes can be time-consuming. I could see having a simple search field that would filter all checks that don't include specific strings.

[n1ru4l]

How often is it necessary to search a schema check for changes?
We already thought about searching schema versions via changes (e.g. you want to figure out which schema publish resulted in a change and who did it), but never schema checks 🤔

[huv1k]

For example, somebody removes a field or operation that doesn't have any usage => is not used in production etc. This doesn't count in code that is for example in code, but it's not yet used. It can happen that this change breaks CI checks in repository that have this code inside, so I would like to find what removed this field so we can figure out who is responsible for it and followup with deprecation in another repo 🙌

[capaj]

I think we're storing schema changes in the DB, so it should be doable to run ILIKE search on that. Would such simple search query work for you @huv1k ?

[jdolle]

Thank you for reporting this and providing a recommendation for the UI.

I'm starting work on this feature.
I think you're right that we should be able to search the contents of the check, and would include the service name, author, and ID/SHA as well. Restricting the time window could also be helpful, but I think typically if you know the time window then you should be able to find out the SHA/ID from a deployment history.

[jdolle]

I started this and have discovered that using LIKE isnt possible because of performance implications. I tried using tsvectors also, and that didn't give good enough search results. This will be a more difficult undertaking than anticipated.
I believe this requires migrating schema checks out of postgres, and into clickhouse to fascilitate the search. We could possibly also duplicate some of the data, but I worry about the performance if we need to query multiple databases.