Project Search Functionality

[robbertbos]

Context

Depends on: https://github.com/MinBZK/tad/issues/75

A search bar to find a project:

Deliverable

1. The search bar is a text field WITHOUT a button to perform the search request
2. When a user stops typing, this will trigger the search request
3. By default, the text field shows a placeholder Find projects...
4. The list below with requests will be updated given the response from the server
5. On the right side of the search bar, a click on the x-button will clear the current content in the text field.

Implementation Notes

• We add a the searchquery to the pagination query
• check ORM support? Otherwise we put it in the alembic migration?
• one index per language (f.e. on the project table, for each table a different index)
• We add an index on the project name/title
• Follow: https://supabase.com/blog/postgres-full-text-search-vs-the-rest#a-whirlwind-tour-through-fts-in-postgres
  • Add vector column and gin index