{"action":"created","issue":{"url":"https://api.github.com/repos/TryGhost/Ghost/issues/586","labels_url":"https://api.github.com/repos/TryGhost/Ghost/issues/586/labels{/name}","comments_url":"https://api.github.com/repos/TryGhost/Ghost/issues/586/comments","events_url":"https://api.github.com/repos/TryGhost/Ghost/issues/586/events","html_url":"https://github.com/TryGhost/Ghost/issues/586","id":18828757,"number":586,"title":"Utilize Transactions in Data Operations","user":{"login":"gotdibbs","id":1540648,"avatar_url":"https://avatars.githubusercontent.com/u/1540648?v=3","gravatar_id":"","url":"https://api.github.com/users/gotdibbs","html_url":"https://github.com/gotdibbs","followers_url":"https://api.github.com/users/gotdibbs/followers","following_url":"https://api.github.com/users/gotdibbs/following{/other_user}","gists_url":"https://api.github.com/users/gotdibbs/gists{/gist_id}","starred_url":"https://api.github.com/users/gotdibbs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gotdibbs/subscriptions","organizations_url":"https://api.github.com/users/gotdibbs/orgs","repos_url":"https://api.github.com/users/gotdibbs/repos","events_url":"https://api.github.com/users/gotdibbs/events{/privacy}","received_events_url":"https://api.github.com/users/gotdibbs/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TryGhost/Ghost/labels/data","name":"data","color":"C0E5C8"},{"url":"https://api.github.com/repos/TryGhost/Ghost/labels/server","name":"server","color":"0B939C"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/TryGhost/Ghost/milestones/6","html_url":"https://github.com/TryGhost/Ghost/milestones/Future%20Backlog","labels_url":"https://api.github.com/repos/TryGhost/Ghost/milestones/6/labels","id":432397,"number":6,"title":"Future Backlog","description":"Planned future work - if an issue is in here, it has been filed away likely because it has too many dependencies or is otherwise not ready to be worked on yet.","creator":{"login":"ErisDS","id":101513,"avatar_url":"https://avatars.githubusercontent.com/u/101513?v=3","gravatar_id":"","url":"https://api.github.com/users/ErisDS","html_url":"https://github.com/ErisDS","followers_url":"https://api.github.com/users/ErisDS/followers","following_url":"https://api.github.com/users/ErisDS/following{/other_user}","gists_url":"https://api.github.com/users/ErisDS/gists{/gist_id}","starred_url":"https://api.github.com/users/ErisDS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ErisDS/subscriptions","organizations_url":"https://api.github.com/users/ErisDS/orgs","repos_url":"https://api.github.com/users/ErisDS/repos","events_url":"https://api.github.com/users/ErisDS/events{/privacy}","received_events_url":"https://api.github.com/users/ErisDS/received_events","type":"User","site_admin":false},"open_issues":21,"closed_issues":28,"state":"open","created_at":"2013-09-20T11:12:23Z","updated_at":"2015-10-09T14:18:55Z","due_on":"2017-02-28T00:00:00Z","closed_at":null},"comments":5,"created_at":"2013-08-31T21:36:20Z","updated_at":"2015-10-09T14:18:55Z","closed_at":"2015-10-09T14:18:55Z","body":"SQLite has to open a file every time it does a single transaction thus anywhere we do any chaining of operations we should probably be doing them inside of one single transaction to increase performance. This should significantly improve performance of our migrations at the very least.\r\n\r\nBookshelf/Knex appears to provide this functionality already (see: http://bookshelfjs.org/#Bookshelf-Transaction)."},"comment":{"url":"https://api.github.com/repos/TryGhost/Ghost/issues/comments/146884352","html_url":"https://github.com/TryGhost/Ghost/issues/586#issuecomment-146884352","issue_url":"https://api.github.com/repos/TryGhost/Ghost/issues/586","id":146884352,"user":{"login":"ErisDS","id":101513,"avatar_url":"https://avatars.githubusercontent.com/u/101513?v=3","gravatar_id":"","url":"https://api.github.com/users/ErisDS","html_url":"https://github.com/ErisDS","followers_url":"https://api.github.com/users/ErisDS/followers","following_url":"https://api.github.com/users/ErisDS/following{/other_user}","gists_url":"https://api.github.com/users/ErisDS/gists{/gist_id}","starred_url":"https://api.github.com/users/ErisDS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ErisDS/subscriptions","organizations_url":"https://api.github.com/users/ErisDS/orgs","repos_url":"https://api.github.com/users/ErisDS/repos","events_url":"https://api.github.com/users/ErisDS/events{/privacy}","received_events_url":"https://api.github.com/users/ErisDS/received_events","type":"User","site_admin":false},"created_at":"2015-10-09T14:18:55Z","updated_at":"2015-10-09T14:18:55Z","body":"This issue has never gotten traction, going to close it for now. If anyone has ideas for specific changes that would be great."}}