{"action":"created","issue":{"url":"https://api.github.com/repos/maxogden/sqlite-search/issues/7","repository_url":"https://api.github.com/repos/maxogden/sqlite-search","labels_url":"https://api.github.com/repos/maxogden/sqlite-search/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/maxogden/sqlite-search/issues/7/comments","events_url":"https://api.github.com/repos/maxogden/sqlite-search/issues/7/events","html_url":"https://github.com/maxogden/sqlite-search/issues/7","id":137382219,"number":7,"title":"ORDER BY relevance","user":{"login":"Blahah","id":836040,"avatar_url":"https://avatars.githubusercontent.com/u/836040?v=3","gravatar_id":"","url":"https://api.github.com/users/Blahah","html_url":"https://github.com/Blahah","followers_url":"https://api.github.com/users/Blahah/followers","following_url":"https://api.github.com/users/Blahah/following{/other_user}","gists_url":"https://api.github.com/users/Blahah/gists{/gist_id}","starred_url":"https://api.github.com/users/Blahah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Blahah/subscriptions","organizations_url":"https://api.github.com/users/Blahah/orgs","repos_url":"https://api.github.com/users/Blahah/repos","events_url":"https://api.github.com/users/Blahah/events{/privacy}","received_events_url":"https://api.github.com/users/Blahah/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-29T21:29:54Z","updated_at":"2016-02-29T21:35:06Z","closed_at":null,"body":"For most full-text (or all-fields see #4) search situations we're looking for a relevance metric.\r\n\r\nPossibly this should be a separate module as an sqlite extension, but once that's done how about offering the feature in `sqlite-search`?"},"comment":{"url":"https://api.github.com/repos/maxogden/sqlite-search/issues/comments/190406561","html_url":"https://github.com/maxogden/sqlite-search/issues/7#issuecomment-190406561","issue_url":"https://api.github.com/repos/maxogden/sqlite-search/issues/7","id":190406561,"user":{"login":"Blahah","id":836040,"avatar_url":"https://avatars.githubusercontent.com/u/836040?v=3","gravatar_id":"","url":"https://api.github.com/users/Blahah","html_url":"https://github.com/Blahah","followers_url":"https://api.github.com/users/Blahah/followers","following_url":"https://api.github.com/users/Blahah/following{/other_user}","gists_url":"https://api.github.com/users/Blahah/gists{/gist_id}","starred_url":"https://api.github.com/users/Blahah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Blahah/subscriptions","organizations_url":"https://api.github.com/users/Blahah/orgs","repos_url":"https://api.github.com/users/Blahah/repos","events_url":"https://api.github.com/users/Blahah/events{/privacy}","received_events_url":"https://api.github.com/users/Blahah/received_events","type":"User","site_admin":false},"created_at":"2016-02-29T21:35:06Z","updated_at":"2016-02-29T21:35:06Z","body":"This sqlite extension should do it: https://github.com/neozenith/sqlite-okapi-bm25\r\n"}}