diff options
author | Yorhel <git@yorhel.nl> | 2015-09-07 01:35:48 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-09-07 01:35:48 +0200 |
commit | 438d4df64d950f8905bd31bddc203d408f42f125 (patch) | |
tree | d2ebd6f9ea86238773cfdc35ac41033dcb9baffa /static/s/ever17_01 | |
parent | 19ce5fcf536ed478ad34b6b1014bf6f44841d25d (diff) |
Implement discussion board search function
Inspired by wakaranai's implementation at
https://github.com/morkt/vndb/commit/b852c87ad145fdaaa09c79b6378dd819b46f7e87
This version is different in a number of aspects:
- Separate search functions for title search and fulltext post search.
Perhaps not the most convenient option, but the downside of a combined
search is that if the query matches the threads' title, then all of
the posts in that thread will show up in the results. This didn't seem
very useful.
- Sorting is based purely on post date. Rank-based sort is slow without
a separate caching column, and in my opinion not all that useful.
Implementation differences:
- Integrated in the existing DB::Discussions functions, so less code to
maintain and more code reuse.
- No separate caching column for the tsvector, a functional index is
used instead. This is a bit slower (index results need to be
re-checked against the actual messages, hence the slowdown), but has
the advantage of smaller database dumps and less complexity in
updating the cache.
Things to fix or look at:
- Highlighting of the search query in message contents.
- Allow or-style query matching
Diffstat (limited to 'static/s/ever17_01')
0 files changed, 0 insertions, 0 deletions