{"action":"created","issue":{"url":"https://api.github.com/repos/JonathanReeve/corpus-db/issues/12","repository_url":"https://api.github.com/repos/JonathanReeve/corpus-db","labels_url":"https://api.github.com/repos/JonathanReeve/corpus-db/issues/12/labels{/name}","comments_url":"https://api.github.com/repos/JonathanReeve/corpus-db/issues/12/comments","events_url":"https://api.github.com/repos/JonathanReeve/corpus-db/issues/12/events","html_url":"https://github.com/JonathanReeve/corpus-db/issues/12","id":305620924,"number":12,"title":"Create full text search (FTS5) table","user":{"login":"JonathanReeve","id":1843676,"avatar_url":"https://avatars2.githubusercontent.com/u/1843676?v=4","gravatar_id":"","url":"https://api.github.com/users/JonathanReeve","html_url":"https://github.com/JonathanReeve","followers_url":"https://api.github.com/users/JonathanReeve/followers","following_url":"https://api.github.com/users/JonathanReeve/following{/other_user}","gists_url":"https://api.github.com/users/JonathanReeve/gists{/gist_id}","starred_url":"https://api.github.com/users/JonathanReeve/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonathanReeve/subscriptions","organizations_url":"https://api.github.com/users/JonathanReeve/orgs","repos_url":"https://api.github.com/users/JonathanReeve/repos","events_url":"https://api.github.com/users/JonathanReeve/events{/privacy}","received_events_url":"https://api.github.com/users/JonathanReeve/received_events","type":"User","site_admin":false},"labels":[{"id":868454699,"url":"https://api.github.com/repos/JonathanReeve/corpus-db/labels/1.0","name":"1.0","color":"f27e02","default":false},{"id":831690730,"url":"https://api.github.com/repos/JonathanReeve/corpus-db/labels/language-agnostic","name":"language-agnostic","color":"4cc9c9","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-15T16:14:46Z","updated_at":"2018-03-23T00:32:47Z","closed_at":null,"author_association":"OWNER","body":"https://www.sqlite.org/fts5.html \r\n\r\nSteps are: \r\n \r\n1. Create a new FTS5 virtual table modeled on the `text` table\r\n2. Copy all data from `text` to the new table\r\n3. ???\r\n4. Profit!\r\n\r\nI have no idea how big this will make the database, though, since I had to kill the process on my laptop after the database more than doubled in size (>18G). I think I'll need to temporarily buy a new DigitalOcean volume and hook it up to the server in order to test this. "},"comment":{"url":"https://api.github.com/repos/JonathanReeve/corpus-db/issues/comments/375501515","html_url":"https://github.com/JonathanReeve/corpus-db/issues/12#issuecomment-375501515","issue_url":"https://api.github.com/repos/JonathanReeve/corpus-db/issues/12","id":375501515,"user":{"login":"JonathanReeve","id":1843676,"avatar_url":"https://avatars2.githubusercontent.com/u/1843676?v=4","gravatar_id":"","url":"https://api.github.com/users/JonathanReeve","html_url":"https://github.com/JonathanReeve","followers_url":"https://api.github.com/users/JonathanReeve/followers","following_url":"https://api.github.com/users/JonathanReeve/following{/other_user}","gists_url":"https://api.github.com/users/JonathanReeve/gists{/gist_id}","starred_url":"https://api.github.com/users/JonathanReeve/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonathanReeve/subscriptions","organizations_url":"https://api.github.com/users/JonathanReeve/orgs","repos_url":"https://api.github.com/users/JonathanReeve/repos","events_url":"https://api.github.com/users/JonathanReeve/events{/privacy}","received_events_url":"https://api.github.com/users/JonathanReeve/received_events","type":"User","site_admin":false},"created_at":"2018-03-23T00:32:47Z","updated_at":"2018-03-23T00:32:47Z","author_association":"OWNER","body":"Turns it this only slightly more than doubled the size of the DB. Full text search is working now. "}}
{"actor":{"display_login":"JonathanReeve"}}