MongoDB cheatsheet

Syntax snippets and quick notes for revision.

MongoDB Introduction

db.orders.find({
  status: "paid",
  total: { $gte: 50 }
}).sort({ total: -1 })

Use this mongodb introduction pattern when a MongoDB task needs a small, readable starting point.

Database

db.orders.find({
  status: "paid",
  total: { $gte: 51 }
}).sort({ total: -1 })

Use this database pattern when a MongoDB task needs a small, readable starting point.

Collection

db.orders.find({
  status: "paid",
  total: { $gte: 52 }
}).sort({ total: -1 })

Use this collection pattern when a MongoDB task needs a small, readable starting point.

Document

db.orders.find({
  status: "paid",
  total: { $gte: 53 }
}).sort({ total: -1 })

Use this document pattern when a MongoDB task needs a small, readable starting point.

Insert

db.orders.find({
  status: "paid",
  total: { $gte: 54 }
}).sort({ total: -1 })

Use this insert pattern when a MongoDB task needs a small, readable starting point.

Find

db.orders.find({
  status: "paid",
  total: { $gte: 55 }
}).sort({ total: -1 })

Use this find pattern when a MongoDB task needs a small, readable starting point.

Update

db.orders.find({
  status: "paid",
  total: { $gte: 56 }
}).sort({ total: -1 })

Use this update pattern when a MongoDB task needs a small, readable starting point.

Delete

db.orders.find({
  status: "paid",
  total: { $gte: 57 }
}).sort({ total: -1 })

Use this delete pattern when a MongoDB task needs a small, readable starting point.

Filters

db.orders.find({
  status: "paid",
  total: { $gte: 58 }
}).sort({ total: -1 })

Use this filters pattern when a MongoDB task needs a small, readable starting point.

Sorting

db.orders.find({
  status: "paid",
  total: { $gte: 59 }
}).sort({ total: -1 })

Use this sorting pattern when a MongoDB task needs a small, readable starting point.

Indexing

db.orders.createIndex({ status: 1, createdAt: -1 })
db.orders.find({ status: "paid" }).sort({ createdAt: -1 })

Use this indexing pattern when a MongoDB task needs a small, readable starting point.

Aggregation

db.orders.aggregate([
  { $match: { status: "paid" } },
  { $group: { _id: "$customerId", revenue: { $sum: "$total" } } },
  { $sort: { revenue: -1 } }
])

Use this aggregation pattern when a MongoDB task needs a small, readable starting point.