{"action":"created","issue":{"url":"https://api.github.com/repos/slick/slick/issues/92","labels_url":"https://api.github.com/repos/slick/slick/issues/92/labels{/name}","comments_url":"https://api.github.com/repos/slick/slick/issues/92/comments","events_url":"https://api.github.com/repos/slick/slick/issues/92/events","html_url":"https://github.com/slick/slick/issues/92","id":10270401,"number":92,"title":"Feature Request: Support for \"SELECT ... FOR UPDATE\"","user":{"login":"hvesalai","id":861035,"avatar_url":"https://avatars.githubusercontent.com/u/861035?v=3","gravatar_id":"","url":"https://api.github.com/users/hvesalai","html_url":"https://github.com/hvesalai","followers_url":"https://api.github.com/users/hvesalai/followers","following_url":"https://api.github.com/users/hvesalai/following{/other_user}","gists_url":"https://api.github.com/users/hvesalai/gists{/gist_id}","starred_url":"https://api.github.com/users/hvesalai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hvesalai/subscriptions","organizations_url":"https://api.github.com/users/hvesalai/orgs","repos_url":"https://api.github.com/users/hvesalai/repos","events_url":"https://api.github.com/users/hvesalai/events{/privacy}","received_events_url":"https://api.github.com/users/hvesalai/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/slick/slick/labels/improvement","name":"improvement","color":"009800"},{"url":"https://api.github.com/repos/slick/slick/labels/UPVOTED","name":"UPVOTED","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/slick/slick/milestones/18","html_url":"https://github.com/slick/slick/milestones/3.1.0","labels_url":"https://api.github.com/repos/slick/slick/milestones/18/labels","id":927523,"number":18,"title":"3.1.0","description":"","creator":{"login":"cvogt","id":274947,"avatar_url":"https://avatars.githubusercontent.com/u/274947?v=3","gravatar_id":"","url":"https://api.github.com/users/cvogt","html_url":"https://github.com/cvogt","followers_url":"https://api.github.com/users/cvogt/followers","following_url":"https://api.github.com/users/cvogt/following{/other_user}","gists_url":"https://api.github.com/users/cvogt/gists{/gist_id}","starred_url":"https://api.github.com/users/cvogt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cvogt/subscriptions","organizations_url":"https://api.github.com/users/cvogt/orgs","repos_url":"https://api.github.com/users/cvogt/repos","events_url":"https://api.github.com/users/cvogt/events{/privacy}","received_events_url":"https://api.github.com/users/cvogt/received_events","type":"User","site_admin":false},"open_issues":114,"closed_issues":8,"state":"open","created_at":"2015-01-08T18:58:38Z","updated_at":"2015-08-13T11:09:16Z","due_on":null,"closed_at":null},"comments":36,"created_at":"2013-01-24T12:15:20Z","updated_at":"2015-08-14T10:02:31Z","closed_at":null,"body":"Row level locking is supported by most datebases. The usual syntax to lock a row is to do a SELECT ... FOR UPDATE query in the beginning of the transaction.\r\n\r\nThis mechanism is supported at least by the following databases (some I know from experience and the rest I checked with quick googling)\r\n\r\n- Derby/JavaDB\r\n- H2\r\n- HSQLDB/HyperSQL\r\n- Microsoft SQL Server\r\n- MySQL\r\n- PostgreSQL\r\n- Oracle\r\n\r\nNot support (and not needed) by SQLite since it allows no concurrent access anyway. (http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql)\r\n\r\nWorkaround and discussion: https://groups.google.com/forum/#!msg/scalaquery/exYF_FSQBmc/WK9pmm7ilkoJ"},"comment":{"url":"https://api.github.com/repos/slick/slick/issues/comments/131056786","html_url":"https://github.com/slick/slick/issues/92#issuecomment-131056786","issue_url":"https://api.github.com/repos/slick/slick/issues/92","id":131056786,"user":{"login":"yzbr","id":13795860,"avatar_url":"https://avatars.githubusercontent.com/u/13795860?v=3","gravatar_id":"","url":"https://api.github.com/users/yzbr","html_url":"https://github.com/yzbr","followers_url":"https://api.github.com/users/yzbr/followers","following_url":"https://api.github.com/users/yzbr/following{/other_user}","gists_url":"https://api.github.com/users/yzbr/gists{/gist_id}","starred_url":"https://api.github.com/users/yzbr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yzbr/subscriptions","organizations_url":"https://api.github.com/users/yzbr/orgs","repos_url":"https://api.github.com/users/yzbr/repos","events_url":"https://api.github.com/users/yzbr/events{/privacy}","received_events_url":"https://api.github.com/users/yzbr/received_events","type":"User","site_admin":false},"created_at":"2015-08-14T10:02:31Z","updated_at":"2015-08-14T10:02:31Z","body":"+1"}}