Please enable JavaScript.

Coggle requires JavaScript to display documents.

DATA BASE - Coggle Diagram

- - - - Definition
        
        Collection (table)
        
        Document (row) -- Json Value
        
        Property (attribute)
        
        Nested document
      - Advantages
        
        High speed response
        
        Flexible data structure
        
        Possibility to use nested document
        
        Easy to create queries
    - - Tools
        
        Mongo Shell
        
        mongosh (start)
        
        show dbs --> to list databases
        
        use {dbname} --> to connect to or create a db
        
        db --> show the dbname of the current db
        
        show collections --> list db collection
        
        variable
        
        var {varname} = {value} --> to create a variable
        
        {varname} --> display variable value
        
        {varname} = {value} --> set new value to a variable
        
        exit --> disconnect to mongosh
        
        help --> display commands
        
        CRUD
        
        Create
        
        db.{collection}.insertOne({json})
        
        db.{collection}.insertMany([{json}, {json}, ...])
        
        Read
        
        db.{collection}.find()
        
        db.{collection}.find({filter}) --> filter = {{prop}:{val}, {prop}:{val}, ...}
        
        db.{collection}.find({filter}, {prop}) --> prop = {{prop}: 1 | 0, {prop}: 1 | 0, ...}
        
        db.{collection}.findOne()
        
        db.{collection}.find().count()
        
        db.{collection}.find().limit(number)
        
        db.{collection}.sort({property}) --> property = {{property}: 1 | -1, {property}: 1 | -1, ...}
        
        Operators ($name)
        
        8 more items...
        
        Delete
        
        db.{collection}.deleteOne({filter})
        
        db.{collection}.deleteMany({filter})
        
        Update
        
        db.{collection}.updateOne({filter}, {$set: {prop1: val1, prop2: val2, ...})
        
        db.{collection}.updateMany({filter}, {$set: {prop1: val1, prop2: val2, ...})
        
        db.{collection}.updateOne({filter}, {$inc: {prop1: incremental, prop2: -decremental, ...})
        
        db.{collection}.updateOne({filter}, {$pull/$push: {prop1: val, prop2: val, ...}) --> remove/Insert value to an array
        
        db.{collection}.updateOne({filter}, {$push: {prop1:{$each: [val1, val2, ...]}}}) --> add or remove many values from an array
        
        Mongo Compass (DBMS)
        
        MongoDB Atlas (Cloud)
        
        mLab (online)
    - - All the find queries return a cursor, so we need to iterate on it to get each vale
      - To make a query by using mongoI id, you have to use ObjectId methid
      - Pagination -->
        db.{collection}.find().skip(number).limit(number)
      - Indexes
        
        Create list of property values to make search faster
        
        db.{collection}.find().explain('executionStats')
        Gives more details on execution KPI
        
        db.{collection}.getIndexes() --> return index list
        
        db.{collection}.createIndex({prop: value})
        
        db.{collection}.dropIndex({prop: value})
      - Connection string :: mongodb://{URI}:{port}/{dbname}