{"action":"opened","number":20,"pull_request":{"url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/20","id":40303821,"html_url":"https://github.com/Ohmbrewer/ohmbrewer/pull/20","diff_url":"https://github.com/Ohmbrewer/ohmbrewer/pull/20.diff","patch_url":"https://github.com/Ohmbrewer/ohmbrewer/pull/20.patch","issue_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/20","number":20,"state":"open","locked":false,"title":"Changes the application database to Postgresql","user":{"login":"kyleoliveira","id":5393682,"avatar_url":"https://avatars.githubusercontent.com/u/5393682?v=3","gravatar_id":"","url":"https://api.github.com/users/kyleoliveira","html_url":"https://github.com/kyleoliveira","followers_url":"https://api.github.com/users/kyleoliveira/followers","following_url":"https://api.github.com/users/kyleoliveira/following{/other_user}","gists_url":"https://api.github.com/users/kyleoliveira/gists{/gist_id}","starred_url":"https://api.github.com/users/kyleoliveira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kyleoliveira/subscriptions","organizations_url":"https://api.github.com/users/kyleoliveira/orgs","repos_url":"https://api.github.com/users/kyleoliveira/repos","events_url":"https://api.github.com/users/kyleoliveira/events{/privacy}","received_events_url":"https://api.github.com/users/kyleoliveira/received_events","type":"User","site_admin":false},"body":"@Ohmbrewer/owners This is pretty small commit, but it's important. This swaps us off of SQLite3 and onto Postgresql. We're doing this because while SQLite3 is fairly serviceable for doing simple development work, it isn't meant to be a production database. It would be good to get this change in now before we get much further down the road.\r\n\r\nYou will have to do some installation work in your VM unfortunately. However, I've done it myself and I've created a Gist of the process for you to follow: https://gist.github.com/kyleoliveira/73a81eba44a85fc468ab If it weren't for the parts you have to do in the psql client, you'd be able to run it as a BASH script. As it is, just follow those steps and you should be good to go. If you run into problems for whatever reason, just let me know and we can work through them.\r\n\r\nI'm going to leave this open for a few days in case there are any objections. If I don't hear anything back from you guys, I'll merge it to master Monday or Tuesday.","created_at":"2015-07-19T06:08:01Z","updated_at":"2015-07-19T06:08:01Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":{"login":"azyth","id":8579908,"avatar_url":"https://avatars.githubusercontent.com/u/8579908?v=3","gravatar_id":"","url":"https://api.github.com/users/azyth","html_url":"https://github.com/azyth","followers_url":"https://api.github.com/users/azyth/followers","following_url":"https://api.github.com/users/azyth/following{/other_user}","gists_url":"https://api.github.com/users/azyth/gists{/gist_id}","starred_url":"https://api.github.com/users/azyth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/azyth/subscriptions","organizations_url":"https://api.github.com/users/azyth/orgs","repos_url":"https://api.github.com/users/azyth/repos","events_url":"https://api.github.com/users/azyth/events{/privacy}","received_events_url":"https://api.github.com/users/azyth/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/20/commits","review_comments_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/20/comments","review_comment_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/20/comments","statuses_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/statuses/2dd68d088cb46b027a5af001d81e1f7f6f5d27e6","head":{"label":"Ohmbrewer:postgres","ref":"postgres","sha":"2dd68d088cb46b027a5af001d81e1f7f6f5d27e6","user":{"login":"Ohmbrewer","id":10904072,"avatar_url":"https://avatars.githubusercontent.com/u/10904072?v=3","gravatar_id":"","url":"https://api.github.com/users/Ohmbrewer","html_url":"https://github.com/Ohmbrewer","followers_url":"https://api.github.com/users/Ohmbrewer/followers","following_url":"https://api.github.com/users/Ohmbrewer/following{/other_user}","gists_url":"https://api.github.com/users/Ohmbrewer/gists{/gist_id}","starred_url":"https://api.github.com/users/Ohmbrewer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ohmbrewer/subscriptions","organizations_url":"https://api.github.com/users/Ohmbrewer/orgs","repos_url":"https://api.github.com/users/Ohmbrewer/repos","events_url":"https://api.github.com/users/Ohmbrewer/events{/privacy}","received_events_url":"https://api.github.com/users/Ohmbrewer/received_events","type":"Organization","site_admin":false},"repo":{"id":30479401,"name":"ohmbrewer","full_name":"Ohmbrewer/ohmbrewer","owner":{"login":"Ohmbrewer","id":10904072,"avatar_url":"https://avatars.githubusercontent.com/u/10904072?v=3","gravatar_id":"","url":"https://api.github.com/users/Ohmbrewer","html_url":"https://github.com/Ohmbrewer","followers_url":"https://api.github.com/users/Ohmbrewer/followers","following_url":"https://api.github.com/users/Ohmbrewer/following{/other_user}","gists_url":"https://api.github.com/users/Ohmbrewer/gists{/gist_id}","starred_url":"https://api.github.com/users/Ohmbrewer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ohmbrewer/subscriptions","organizations_url":"https://api.github.com/users/Ohmbrewer/orgs","repos_url":"https://api.github.com/users/Ohmbrewer/repos","events_url":"https://api.github.com/users/Ohmbrewer/events{/privacy}","received_events_url":"https://api.github.com/users/Ohmbrewer/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Ohmbrewer/ohmbrewer","description":"The web application for a happy brew day.","fork":false,"url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer","forks_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/forks","keys_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/teams","hooks_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/hooks","issue_events_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/events{/number}","events_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/events","assignees_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/assignees{/user}","branches_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/branches{/branch}","tags_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/tags","blobs_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/refs{/sha}","trees_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/statuses/{sha}","languages_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/languages","stargazers_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/stargazers","contributors_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/contributors","subscribers_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/subscribers","subscription_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/subscription","commits_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/commits{/sha}","git_commits_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/commits{/sha}","comments_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/comments{/number}","issue_comment_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/comments{/number}","contents_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/contents/{+path}","compare_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/merges","archive_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/downloads","issues_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues{/number}","pulls_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls{/number}","milestones_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/milestones{/number}","notifications_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/labels{/name}","releases_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/releases{/id}","created_at":"2015-02-08T03:24:28Z","updated_at":"2015-04-16T18:39:06Z","pushed_at":"2015-07-19T06:08:02Z","git_url":"git://github.com/Ohmbrewer/ohmbrewer.git","ssh_url":"git@github.com:Ohmbrewer/ohmbrewer.git","clone_url":"https://github.com/Ohmbrewer/ohmbrewer.git","svn_url":"https://github.com/Ohmbrewer/ohmbrewer","homepage":"http://ohmbrewer.github.io","size":1056,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":10,"forks":0,"open_issues":10,"watchers":0,"default_branch":"master"}},"base":{"label":"Ohmbrewer:master","ref":"master","sha":"a01bb72651d8ccbb91fcae4f5073aab6c09e933b","user":{"login":"Ohmbrewer","id":10904072,"avatar_url":"https://avatars.githubusercontent.com/u/10904072?v=3","gravatar_id":"","url":"https://api.github.com/users/Ohmbrewer","html_url":"https://github.com/Ohmbrewer","followers_url":"https://api.github.com/users/Ohmbrewer/followers","following_url":"https://api.github.com/users/Ohmbrewer/following{/other_user}","gists_url":"https://api.github.com/users/Ohmbrewer/gists{/gist_id}","starred_url":"https://api.github.com/users/Ohmbrewer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ohmbrewer/subscriptions","organizations_url":"https://api.github.com/users/Ohmbrewer/orgs","repos_url":"https://api.github.com/users/Ohmbrewer/repos","events_url":"https://api.github.com/users/Ohmbrewer/events{/privacy}","received_events_url":"https://api.github.com/users/Ohmbrewer/received_events","type":"Organization","site_admin":false},"repo":{"id":30479401,"name":"ohmbrewer","full_name":"Ohmbrewer/ohmbrewer","owner":{"login":"Ohmbrewer","id":10904072,"avatar_url":"https://avatars.githubusercontent.com/u/10904072?v=3","gravatar_id":"","url":"https://api.github.com/users/Ohmbrewer","html_url":"https://github.com/Ohmbrewer","followers_url":"https://api.github.com/users/Ohmbrewer/followers","following_url":"https://api.github.com/users/Ohmbrewer/following{/other_user}","gists_url":"https://api.github.com/users/Ohmbrewer/gists{/gist_id}","starred_url":"https://api.github.com/users/Ohmbrewer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ohmbrewer/subscriptions","organizations_url":"https://api.github.com/users/Ohmbrewer/orgs","repos_url":"https://api.github.com/users/Ohmbrewer/repos","events_url":"https://api.github.com/users/Ohmbrewer/events{/privacy}","received_events_url":"https://api.github.com/users/Ohmbrewer/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Ohmbrewer/ohmbrewer","description":"The web application for a happy brew day.","fork":false,"url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer","forks_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/forks","keys_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/teams","hooks_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/hooks","issue_events_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/events{/number}","events_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/events","assignees_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/assignees{/user}","branches_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/branches{/branch}","tags_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/tags","blobs_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/refs{/sha}","trees_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/statuses/{sha}","languages_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/languages","stargazers_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/stargazers","contributors_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/contributors","subscribers_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/subscribers","subscription_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/subscription","commits_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/commits{/sha}","git_commits_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/git/commits{/sha}","comments_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/comments{/number}","issue_comment_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/comments{/number}","contents_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/contents/{+path}","compare_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/merges","archive_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/downloads","issues_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues{/number}","pulls_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls{/number}","milestones_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/milestones{/number}","notifications_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/labels{/name}","releases_url":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/releases{/id}","created_at":"2015-02-08T03:24:28Z","updated_at":"2015-04-16T18:39:06Z","pushed_at":"2015-07-19T06:08:02Z","git_url":"git://github.com/Ohmbrewer/ohmbrewer.git","ssh_url":"git@github.com:Ohmbrewer/ohmbrewer.git","clone_url":"https://github.com/Ohmbrewer/ohmbrewer.git","svn_url":"https://github.com/Ohmbrewer/ohmbrewer","homepage":"http://ohmbrewer.github.io","size":1056,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":10,"forks":0,"open_issues":10,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/20"},"html":{"href":"https://github.com/Ohmbrewer/ohmbrewer/pull/20"},"issue":{"href":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/20"},"comments":{"href":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/issues/20/comments"},"review_comments":{"href":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/20/comments"},"review_comment":{"href":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/pulls/20/commits"},"statuses":{"href":"https://api.github.com/repos/Ohmbrewer/ohmbrewer/statuses/2dd68d088cb46b027a5af001d81e1f7f6f5d27e6"}},"merged":false,"mergeable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"commits":1,"additions":24,"deletions":17,"changed_files":4}}