Dubious Database Design

077e9a0cb34fa3eba2699240c9509717?s=47 Andrew Godwin
September 07, 2015

Dubious Database Design

My talk from DjangoCon US 2015.

077e9a0cb34fa3eba2699240c9509717?s=128

Andrew Godwin

September 07, 2015
Tweet

Transcript

  1. 2.

    Andrew Godwin Hi, I'm Author of 1.7 Django & South

    migrations Senior Software Engineer at Only hates MySQL a little
  2. 8.
  3. 19.

    {"id": 11, "post": "abc", "author": 1} {"id": 12, "post": "def",

    "author": 2} {"id": 13, "post", "ghi", "author": 3} {"id": 1, "name": "Andrew"} {"id": 2, "name": "Brenda"} {"id": 3, "name": "Carol"}
  4. 21.

    scan all posts build dict of author -> posts scan

    all authors and emit with posts
  5. 22.
  6. 33.
  7. 34.
  8. 38.
  9. 40.

    Columns per language 300 - 400 language variants x A

    couple of translated cols per table x
  10. 47.
  11. 62.
  12. 64.