{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/4491","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/4491/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/4491/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/4491/events","html_url":"https://github.com/cockroachdb/cockroach/issues/4491","id":134618950,"number":4491,"title":"sql: support SERIAL PK for appending rows to a table","user":{"login":"JackKrupansky","id":448646,"avatar_url":"https://avatars.githubusercontent.com/u/448646?v=3","gravatar_id":"","url":"https://api.github.com/users/JackKrupansky","html_url":"https://github.com/JackKrupansky","followers_url":"https://api.github.com/users/JackKrupansky/followers","following_url":"https://api.github.com/users/JackKrupansky/following{/other_user}","gists_url":"https://api.github.com/users/JackKrupansky/gists{/gist_id}","starred_url":"https://api.github.com/users/JackKrupansky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JackKrupansky/subscriptions","organizations_url":"https://api.github.com/users/JackKrupansky/orgs","repos_url":"https://api.github.com/users/JackKrupansky/repos","events_url":"https://api.github.com/users/JackKrupansky/events{/privacy}","received_events_url":"https://api.github.com/users/JackKrupansky/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/4","html_url":"https://github.com/cockroachdb/cockroach/milestones/Q2","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/4/labels","id":1690471,"number":4,"title":"Q2","description":"","creator":{"login":"petermattis","id":6201335,"avatar_url":"https://avatars.githubusercontent.com/u/6201335?v=3","gravatar_id":"","url":"https://api.github.com/users/petermattis","html_url":"https://github.com/petermattis","followers_url":"https://api.github.com/users/petermattis/followers","following_url":"https://api.github.com/users/petermattis/following{/other_user}","gists_url":"https://api.github.com/users/petermattis/gists{/gist_id}","starred_url":"https://api.github.com/users/petermattis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petermattis/subscriptions","organizations_url":"https://api.github.com/users/petermattis/orgs","repos_url":"https://api.github.com/users/petermattis/repos","events_url":"https://api.github.com/users/petermattis/events{/privacy}","received_events_url":"https://api.github.com/users/petermattis/received_events","type":"User","site_admin":false},"open_issues":96,"closed_issues":86,"state":"open","created_at":"2016-04-07T18:25:48Z","updated_at":"2016-05-10T01:39:45Z","due_on":"2016-06-30T04:00:00Z","closed_at":null},"comments":9,"created_at":"2016-02-18T15:55:59Z","updated_at":"2016-05-10T03:26:49Z","closed_at":null,"body":"For tables in which new rows are intended to be appended in chronological order support for SERIAL PK would be very desirable. While at first blush it would seem that having to synchronize atomic updating of a sequence number generator would add excessive overhead, it can be noted that since each appended row will be inserted in the last range for the table, the sequence number generator could be stored with a RocksDB key that is composed so that it always is positioned after the highest PK value of the table. IOW, it is located in the same range as where the appended row will be inserted in the key store. So, the transaction and consensus overhead to manage the sequence number should be minimal and optimal and convenient and readable (1..n) for the \"chronological append\" access pattern."},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/218050076","html_url":"https://github.com/cockroachdb/cockroach/issues/4491#issuecomment-218050076","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/4491","id":218050076,"user":{"login":"tlvenn","id":3340262,"avatar_url":"https://avatars.githubusercontent.com/u/3340262?v=3","gravatar_id":"","url":"https://api.github.com/users/tlvenn","html_url":"https://github.com/tlvenn","followers_url":"https://api.github.com/users/tlvenn/followers","following_url":"https://api.github.com/users/tlvenn/following{/other_user}","gists_url":"https://api.github.com/users/tlvenn/gists{/gist_id}","starred_url":"https://api.github.com/users/tlvenn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tlvenn/subscriptions","organizations_url":"https://api.github.com/users/tlvenn/orgs","repos_url":"https://api.github.com/users/tlvenn/repos","events_url":"https://api.github.com/users/tlvenn/events{/privacy}","received_events_url":"https://api.github.com/users/tlvenn/received_events","type":"User","site_admin":false},"created_at":"2016-05-10T03:26:49Z","updated_at":"2016-05-10T03:26:49Z","body":"Thanks for the update @petermattis. I think Github introduced reactions a few weeks ago.."}}