File search: result ordering

[carderne]

New issue brought over from #23 as requested.
Running Regoligh 2.1.

Scenario

I have some files in various places in my HOMEDIR:

1. dial.txt
2. Dial Revenge.mp3
3. Street Dialogue.mp3
4. p_radial.csv
5. Odyssey.mobi

For the search string "dial", I mostly want 1, I might want 2, and I don't care about the rest because I'd use a different search string. (The last one is a full-text result.)

Results from various search methods:

• Tracker search from Nautilus: 1 5 2 4 3
• Tracker search via tracker3 sparql[0]: 1 2 3 (misses 4-5)
• ilia search: 2 3 1 (misses 4-5)
• fzf: 1 2 (misses 3-5)
• fdfind: 1 3 2 4 (misses 5)

For me, all except ilia are fine, because it is the only one that makes me scroll to get the result I want.

Investigation

I played around a bit with tracker3 sparql but not enough to figure out what other columns it might be hiding, or if it exposes any way to ORDER BY in a more useful manner.

Ref

[0] Full command:

tracker3 sparql -q "SELECT DISTINCT nie:url(?f) nie:title(?f) nie:mimeType(?f) WHERE { ?f fts:match 'dial' }"

#37 is also related, inasmuch as it touches the same code.