)]}'
{
  "commit": "1aae1da53855e0bf142ea1aa2aaf09cc0f2ee0e0",
  "tree": "9f383f0db1be1e5a520656d6b3e5418d9950de3c",
  "parents": [
    "f5c4ca9b859b8718262b9ccffabfebddcc6dd01b"
  ],
  "author": {
    "name": "Quentin Smith",
    "email": "quentin@golang.org",
    "time": "Wed Feb 01 10:37:11 2017 -0500"
  },
  "committer": {
    "name": "Quentin Smith",
    "email": "quentin@golang.org",
    "time": "Thu Feb 02 19:59:37 2017 +0000"
  },
  "message": "storage/db: add NOT NULL and PRIMARY KEY constraints to improve performance\n\nIn a test database containing 309,000 real benchmark records, given\nthe query\n\n  select t1.UploadID, (select t2.Value from RecordLabels t2 where\n  t2.UploadID \u003d t1.UploadID AND Name \u003d \u0027upload-time\u0027 limit 1) from\n  Uploads t1;\n\nused to obtain sample values from each upload, the PRIMARY KEY index\ncauses the query to fall from 1.49s to 0.03s.\n\nThe NOT NULL constraint is necessary to make the PRIMARY KEY effective.\n\nChange-Id: I9e663766e2f99f1096952e4c20eecbf8faab577b\nReviewed-on: https://go-review.googlesource.com/36114\nReviewed-by: Russ Cox \u003crsc@golang.org\u003e\n",
  "tree_diff": [
    {
      "type": "modify",
      "old_id": "6794847a4735f752d4ddb225639f7c8e0a878ba8",
      "old_mode": 33188,
      "old_path": "storage/db/db.go",
      "new_id": "5c03b4f1ac01f2dca6605604ee4a8888da574a01",
      "new_mode": 33188,
      "new_path": "storage/db/db.go"
    }
  ]
}