MongoDB at Fiesta

Slides from a NY MongoDB User Group talk given on 11/16/2011. The talk was about lessons we've learned while using MongoDB at Fiesta. The bulk of the talk was an overview on data modeling with MongoDB, since that is an issue that tends to come up frequently with new users.

Transcript

1. MongoDB at Fiesta @mdirolf @fiesta
4. Cc: Subject: To: Good article jim@example.com, jolene@example.com, chris@example.com, jared@example.com Thought you guys might enjoy this article: http://nymag.com/arts/books/features/jeffrey-eugenides
5. Cc: Subject: To: jim@example.com, jolene@example.com, chris@example.com, jared@example.com family@fiesta.cc Good article Thought you guys might enjoy this article: http://nymag.com/arts/books/features/jeffrey-eugenides
6. Data Modeling Flexibility is a blessing (and a curse).
7. 0-embed {    _id:  PERSON_ID,    name:  "Mike  Dirolf",    pw:  "Some  Hashed  Password" } Person
8. 0-embed {    _id:  ADDRESS_ID,    person:  PERSON_ID,    address:  "mike@corp.fiesta.cc" } Address
9. 0-embed {    _id:  GROUP_ID,    domain:  "gitlists.com" } Group
10. 0-embed {    _id:  MEMBERSHIP_ID,    person:  PERSON_ID,    group:  GROUP_ID,    address:  ADDRESS_ID,    group_name:  "family" } Membership
11. 0-embed Other member addresses for an address & group_name: 1.  var  x  =  db.addresses.findOne({address:  address}) 2.  var  y  =  db.memberships.findOne({person:  x.person,                                                                group_name:  group_name}) 3.  var  z  =  db.memberships.find({group:  y.group}) 4.  for  m  in  z:  db.addresses.findOne({person:  m.person})
12. Embed Everything {    _id:  GROUP_ID,    domain:  "gitlists.com",    memberships:  [{        address:  "mike@corp.fiesta.cc",        name:  "Mike  Dirolf",        pw:  "Some  Hashed  Password",        person_addresses  =            ["mike@corp.fiesta.cc",              "mike@dirolf.com",              ...],        group_name:  "family"    },  ...] }
13. Embed Everything Other member addresses for an address & group_name: db.groups.findOne({memberships:                                        {$elemMatch:                                            {address:  address,                                              group_name:  group_name}}})
14. Embed Everything How do we change a Person’s name?
15. Embed Trivial Cases {    _id:  PERSON_ID,    name:  "Mike  Dirolf",    pw:  "Some  Hashed  Password",    addresses:  ["mike@corp.fiesta.cc",                            "mike@dirolf.com",  ...],    memberships:  [{        address:  "mike@corp.fiesta.cc",        group_name:  "family",        group:  GROUP_ID    },  ...] }
16. Embed Trivial Cases Other member addresses for an address & group_name: 1.  var  x  =  db.users.findOne({address:  address,                                                          "groups.name":  group_name}) 2.  db.users.find({"groups.id":  ...})
17. Scratch That Flexibility is a blessing.
18. Flexible “Schemas” {“author”:  “mike”,  “text”:  “...”} {“author”:  “eliot”,  “text”:  “...”,  “tags”:  [“mongodb”]}
19. To munge, or not to munge...
20. if user.get("munge", True): do_munge(...)
21. Dynamic Queries 1. Development speed 2. Natural for dynamic languages 3. Easy for administration
22. ODMs vs. Using Drivers Directly http://blog.fiesta.cc/post/12167731260/on-object- document-mapping
23. @fiesta @mdirolf