-
Notifications
You must be signed in to change notification settings - Fork 1
Open
Labels
C-BackendRelate to backendRelate to backendK-FeatureFeature requestFeature requestP-MiddleMiddle priorityMiddle priority
Description
The state of art for problem search:
- support text search (using
%text%): sqlx doesn't supportfts5ortsvector - support tag search (using
COUNT(DISTINCT "problem"."id"))
- automatically add tag on addition
- Cannot auto-compelete tag or list tag
- tag would not delete if all problem deleted
periodic tag deletion was chosen because we use
read committedisolation level on SQL transcation during tag addition for performance.
TODO:
- write auto-compelete API
- auto compeletion caching
- periodic tag deletion
Metadata
Metadata
Assignees
Labels
C-BackendRelate to backendRelate to backendK-FeatureFeature requestFeature requestP-MiddleMiddle priorityMiddle priority