MongoDB Notes

MongoDB Notes

Schema-Free
Hierarchy
1. Instance
  1. Database
    1. Collection
      1. Document
        Every Document has an id
        JSON Format
      2. Embedded
        Attributes are not stored in separate collection
        Implementation depends on the needs of the application
      3. Linked
Optimized to quickly retrieve relevant data
Design should take into account how the application needs the data
Documentation: https://docs.mongodb.com/manual/
Extensions
1. Mongoose
2. RoboMongo
3. MongoChef
CRUD Operations
1. find
  1. Equivalent to SELECT statement
  2. Examples
    1. Minimal
      1. db.Products.find()
    2. Query + Projection
      1. db.Products.find({ "desc": "42in TV", "width": 41 })
    3. Query Only
      1. db.Products.find({"desc": "42in TV"})
    4. Projection Only
      1. db.Products.find({"width": 1, "height": 1, "depth": 1} )
    5. Arrays
      1. db.Products.find({ "priceHist" : {$elemMatch: { $gt: 100, $lt: 300 } } })
    6. Conditional Statements
      1. db.Products.find({"reviews.star": { $gte: 4 } })
    7. Embedded Collections
      1. db.Products.find({"editorReview.authorlname" : "Smith"} )
  3. Syntax
    1. db.collection.find(query, projection)
      1. Projection: Which columns you're going to return
      2. id always comes back unless id is set to false {id: 0}
2. Inserts
  1. Examples
    1. Single
      1. db.Questions.insert({"_id": NumberInt(5), "prodID": NumberInt(4), "author": "MrsInquisitive", "text": "Sample question"})
    2. Multiple
      1. db.Questions.insert([{"_id": NumberInt(6), "prodID": NumberInt(4), "author": "MrsInquisitive", "text": "Sample question"}, {"_id": NumberInt(7), "prodID": NumberInt(4), "author": "MrIWantToKnow", "text": "Sample question"} ])

Next up

Description

Resource summary

Similar

	Created by Callie Toothman over 8 years ago