{"action":"created","issue":{"url":"https://api.github.com/repos/eleweek/WatchPeopleCode/issues/10","labels_url":"https://api.github.com/repos/eleweek/WatchPeopleCode/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/eleweek/WatchPeopleCode/issues/10/comments","events_url":"https://api.github.com/repos/eleweek/WatchPeopleCode/issues/10/events","html_url":"https://github.com/eleweek/WatchPeopleCode/issues/10","id":58468247,"number":10,"title":"Can't set up local development environment with SQLite","user":{"login":"mikeconley","id":195042,"avatar_url":"https://avatars.githubusercontent.com/u/195042?v=3","gravatar_id":"","url":"https://api.github.com/users/mikeconley","html_url":"https://github.com/mikeconley","followers_url":"https://api.github.com/users/mikeconley/followers","following_url":"https://api.github.com/users/mikeconley/following{/other_user}","gists_url":"https://api.github.com/users/mikeconley/gists{/gist_id}","starred_url":"https://api.github.com/users/mikeconley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikeconley/subscriptions","organizations_url":"https://api.github.com/users/mikeconley/orgs","repos_url":"https://api.github.com/users/mikeconley/repos","events_url":"https://api.github.com/users/mikeconley/events{/privacy}","received_events_url":"https://api.github.com/users/mikeconley/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-21T18:03:54Z","updated_at":"2015-02-22T10:19:03Z","closed_at":null,"body":"Hello,\r\n\r\nI want to contribute to this project, but I'm having a hard time setting up my development environment; particularly, it looks like some of the migrations don't work with SQLite. For example, running upgrade 177b55430b61 -> 1aaef862b2da, I get:\r\n\r\nsqlalchemy.exc.OperationalError: (OperationalError) Cannot add a NOT NULL column with default value NULL u'ALTER TABLE stream ADD COLUMN channel VARCHAR(25) NOT NULL' ()\r\n\r\nIf SQLite support isn't in the cards, which database backend should I be using instead to contribute?"},"comment":{"url":"https://api.github.com/repos/eleweek/WatchPeopleCode/issues/comments/75428687","html_url":"https://github.com/eleweek/WatchPeopleCode/issues/10#issuecomment-75428687","issue_url":"https://api.github.com/repos/eleweek/WatchPeopleCode/issues/10","id":75428687,"user":{"login":"elimohl","id":10729543,"avatar_url":"https://avatars.githubusercontent.com/u/10729543?v=3","gravatar_id":"","url":"https://api.github.com/users/elimohl","html_url":"https://github.com/elimohl","followers_url":"https://api.github.com/users/elimohl/followers","following_url":"https://api.github.com/users/elimohl/following{/other_user}","gists_url":"https://api.github.com/users/elimohl/gists{/gist_id}","starred_url":"https://api.github.com/users/elimohl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elimohl/subscriptions","organizations_url":"https://api.github.com/users/elimohl/orgs","repos_url":"https://api.github.com/users/elimohl/repos","events_url":"https://api.github.com/users/elimohl/events{/privacy}","received_events_url":"https://api.github.com/users/elimohl/received_events","type":"User","site_admin":false},"created_at":"2015-02-22T10:19:03Z","updated_at":"2015-02-22T10:19:03Z","body":"I think you can just run `db.create_all()` and then set `alembic_version` to last revision in your database."}}