{"action":"closed","issue":{"url":"https://api.github.com/repos/bmershon/wikiblocks-search/issues/15","labels_url":"https://api.github.com/repos/bmershon/wikiblocks-search/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/bmershon/wikiblocks-search/issues/15/comments","events_url":"https://api.github.com/repos/bmershon/wikiblocks-search/issues/15/events","html_url":"https://github.com/bmershon/wikiblocks-search/issues/15","id":119336824,"number":15,"title":"PSQL full text searching","user":{"login":"bmershon","id":3190945,"avatar_url":"https://avatars.githubusercontent.com/u/3190945?v=3","gravatar_id":"","url":"https://api.github.com/users/bmershon","html_url":"https://github.com/bmershon","followers_url":"https://api.github.com/users/bmershon/followers","following_url":"https://api.github.com/users/bmershon/following{/other_user}","gists_url":"https://api.github.com/users/bmershon/gists{/gist_id}","starred_url":"https://api.github.com/users/bmershon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmershon/subscriptions","organizations_url":"https://api.github.com/users/bmershon/orgs","repos_url":"https://api.github.com/users/bmershon/repos","events_url":"https://api.github.com/users/bmershon/events{/privacy}","received_events_url":"https://api.github.com/users/bmershon/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-11-29T04:52:13Z","updated_at":"2015-12-03T16:31:51Z","closed_at":"2015-12-03T16:31:51Z","body":"Little late to find this, but hey:\r\n\r\nhttp://www.postgresql.org/docs/8.3/static/textsearch-controls.html#TEXTSEARCH-RANKING\r\n\r\nThere is a possibility of letting PostgreSQL do all the work of full text with little change to the codebase.\r\n\r\nSince the generators NOW take arbitrary queries with a text parameter (and limit, offset), rather than using an array of tokens, The entire hook (e.g. \"Prim's algorithm\") can be used as a parameter.\r\n\r\nI'm not sure yet how the tables might change. If there is too much significant change I won't worry about it until after the demo. However, at the very least we can probably take care of the issues that arise from simple cases like \"triangles\" and \"triangle\" not being recognized as equal.\r\n\r\nThis guy did a short tutorial on full text search using PostgreSQL.\r\n\r\nhttp://shisaa.jp/postset/postgresql-full-text-search-part-2.html"}}