{"action":"created","issue":{"url":"https://api.github.com/repos/simplare/stoffi-web/issues/17","labels_url":"https://api.github.com/repos/simplare/stoffi-web/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/simplare/stoffi-web/issues/17/comments","events_url":"https://api.github.com/repos/simplare/stoffi-web/issues/17/events","html_url":"https://github.com/simplare/stoffi-web/issues/17","id":91519379,"number":17,"title":"Add support for Postgres","user":{"login":"ephracis","id":247659,"avatar_url":"https://avatars.githubusercontent.com/u/247659?v=3","gravatar_id":"","url":"https://api.github.com/users/ephracis","html_url":"https://github.com/ephracis","followers_url":"https://api.github.com/users/ephracis/followers","following_url":"https://api.github.com/users/ephracis/following{/other_user}","gists_url":"https://api.github.com/users/ephracis/gists{/gist_id}","starred_url":"https://api.github.com/users/ephracis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ephracis/subscriptions","organizations_url":"https://api.github.com/users/ephracis/orgs","repos_url":"https://api.github.com/users/ephracis/repos","events_url":"https://api.github.com/users/ephracis/events{/privacy}","received_events_url":"https://api.github.com/users/ephracis/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/simplare/stoffi-web/labels/chore","name":"chore","color":"FEF2C0"},{"url":"https://api.github.com/repos/simplare/stoffi-web/labels/enhancement","name":"enhancement","color":"5EBEFF"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-27T21:55:23Z","updated_at":"2015-07-17T08:25:17Z","closed_at":null,"body":"Make sure it is possible to run on a postgres db."},"comment":{"url":"https://api.github.com/repos/simplare/stoffi-web/issues/comments/122214172","html_url":"https://github.com/simplare/stoffi-web/issues/17#issuecomment-122214172","issue_url":"https://api.github.com/repos/simplare/stoffi-web/issues/17","id":122214172,"user":{"login":"ephracis","id":247659,"avatar_url":"https://avatars.githubusercontent.com/u/247659?v=3","gravatar_id":"","url":"https://api.github.com/users/ephracis","html_url":"https://github.com/ephracis","followers_url":"https://api.github.com/users/ephracis/followers","following_url":"https://api.github.com/users/ephracis/following{/other_user}","gists_url":"https://api.github.com/users/ephracis/gists{/gist_id}","starred_url":"https://api.github.com/users/ephracis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ephracis/subscriptions","organizations_url":"https://api.github.com/users/ephracis/orgs","repos_url":"https://api.github.com/users/ephracis/repos","events_url":"https://api.github.com/users/ephracis/events{/privacy}","received_events_url":"https://api.github.com/users/ephracis/received_events","type":"User","site_admin":false},"created_at":"2015-07-17T08:25:17Z","updated_at":"2015-07-17T08:25:17Z","body":"Contrary to MySQL and SQLite, Postgres demands that queries actually follow the SQL standard. It turns out that several queries in *stoffi-web* do not.\r\n\r\nThe work to get *stoffi-web* running on Postgres is considerably larger than anticipated and I got stuck on some weird behaviour from `ActiveRecord` when using inner joins. All of a sudden, the query was filled with `$2`. It looks to me that `ActiveRecord` doesn't interpolate the strings as it should when using `Model.select(x).from(y)` (it is `y` that contains `$2`).\r\n\r\nI really don't have the time and energy to continue this effort right now. But I will let the branch stay and perhaps I can get back to it later."}}