Show a few more search results about guildwarsitembrowser HOT 4 OPEN

When you say you're not sure whether sql.js supports "this" - relevancy? Sorting?

from guildwarsitembrowser.

Sqlite3 proper supports adding your own functions to rank search results, so you can display the most relevant ones first. See https://www.sqlite.org/fts3.html#matchinfo.

However, Sql.js currently provides no hook to register your own functions. See https://github.com/kripken/sql.js/issues/60.

If one were to implement registering your own functions in sql.js, those people would surely be happy to see you create a pull request for it.

from guildwarsitembrowser.

I've done custom functions for SQL.js. Now need to implement rank function. See https://www.sqlite.org/fts3.html#appendix_a for inspiration.

from guildwarsitembrowser.

Nicely done. I was thinking about what we can apply as a custom function.

If we only search on full words and we require each of the words to appear in the name for an item to be included then I think we have a super simple metric in the form of total string length (or even better, total word count).

Each result will have at least your query in and things that have more than that are less likely to be what you were after.

I'm going to implement that as a baseline. From there, I think it's our best bet would be to have a few keywords that bump things up the list (e.g. "dye") and/or weight things by their total trade volume (number of buy/sell orders). The latter would require hitting the API for up-to-date info, though doing that would also allow us to show current prices in the search results.

from guildwarsitembrowser.