{"action":"created","issue":{"url":"https://api.github.com/repos/bolt/bolt/issues/4513","labels_url":"https://api.github.com/repos/bolt/bolt/issues/4513/labels{/name}","comments_url":"https://api.github.com/repos/bolt/bolt/issues/4513/comments","events_url":"https://api.github.com/repos/bolt/bolt/issues/4513/events","html_url":"https://github.com/bolt/bolt/issues/4513","id":118266698,"number":4513,"title":"Reduce SQLite base size after logs clear","user":{"login":"Boorj","id":2145313,"avatar_url":"https://avatars.githubusercontent.com/u/2145313?v=3","gravatar_id":"","url":"https://api.github.com/users/Boorj","html_url":"https://github.com/Boorj","followers_url":"https://api.github.com/users/Boorj/followers","following_url":"https://api.github.com/users/Boorj/following{/other_user}","gists_url":"https://api.github.com/users/Boorj/gists{/gist_id}","starred_url":"https://api.github.com/users/Boorj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Boorj/subscriptions","organizations_url":"https://api.github.com/users/Boorj/orgs","repos_url":"https://api.github.com/users/Boorj/repos","events_url":"https://api.github.com/users/Boorj/events{/privacy}","received_events_url":"https://api.github.com/users/Boorj/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-11-22T14:37:35Z","updated_at":"2015-11-24T18:08:58Z","closed_at":null,"body":"Would be lovely to automatically execute `VACUUM;` sqlite command (after clearing logs - especially).\r\nIt could reduce database size at more than 100 times.\r\n[→ Vacuum docs](https://sqlite.org/lang_vacuum.html)\r\n"},"comment":{"url":"https://api.github.com/repos/bolt/bolt/issues/comments/159359027","html_url":"https://github.com/bolt/bolt/issues/4513#issuecomment-159359027","issue_url":"https://api.github.com/repos/bolt/bolt/issues/4513","id":159359027,"user":{"login":"Boorj","id":2145313,"avatar_url":"https://avatars.githubusercontent.com/u/2145313?v=3","gravatar_id":"","url":"https://api.github.com/users/Boorj","html_url":"https://github.com/Boorj","followers_url":"https://api.github.com/users/Boorj/followers","following_url":"https://api.github.com/users/Boorj/following{/other_user}","gists_url":"https://api.github.com/users/Boorj/gists{/gist_id}","starred_url":"https://api.github.com/users/Boorj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Boorj/subscriptions","organizations_url":"https://api.github.com/users/Boorj/orgs","repos_url":"https://api.github.com/users/Boorj/repos","events_url":"https://api.github.com/users/Boorj/events{/privacy}","received_events_url":"https://api.github.com/users/Boorj/received_events","type":"User","site_admin":false},"created_at":"2015-11-24T18:08:58Z","updated_at":"2015-11-24T18:08:58Z","body":"i agree it's good to leave it as dry as possible, but this feature is really nice for those people who bought 100mb shared hosting, and it' getting filled with logs) but it's only my humble opinion, i don't insist."}}