-
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 supportfts5
ortsvector
- 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 committed
isolation 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