Export to JSON

mongoexport --collection=krakens --db=code-gorilla --out=20220812-krakens.json --pretty
 

Import from JSON

mongoimport --collection=krakens --db=code-gorilla --file=20220812-krakens.json --type=json

---

Mac OS Install

 
To install mongoose on your mac:
brew tap mongodb/brew
brew update
brew install mongodb-community@8.0
https://www.mongodb.com/docs/manual/tutorial/install-mongodb-on-os-x/
 

Mac Start

After install, start server and have automatically start on reboot:
brew services start mongodb-community
brew services stop mongodb-community
brew services restart mongodb-community
 
Check Status of Mongoose:
brew services list

To UNinstall mongoose on your mac:
https://www.mongodb.com/resources/products/fundamentals/uninstall-mongodb
 

Mongoose Shell

 
mongosh
show dbs

Log:
/opt/homebrew/var/log/mongodb/mongo.log

---

Queries

 

Document Count

db.krakens.countDocuments()
 

Select All

db.krakens.find({})
 

Select All, ORDER BY Ascending

db.krakens.find({}).sort({'fieldName': 1})
 

Select All, ORDER BY Descending

db.krakens.find({}).sort({'fieldName': -1})
 

Find Exact Match on Field

db.krakens.find({ isValidated: false })
 

Find Exact Match on Id

db.krakens.find('_id': ObjectId('696901313fa123dc02d77777'))
 

String Partial Match (*like%), Case Sensitive

db.krakens.find({ "fieldName": { "$regex": "VegJutsu" } })
 

String Partial Match (*like%), Case Insensitive

db.krakens.find({ "fieldName": { "$regex": "VegJutsu", "$options": "i" } })
 

String Partial Match (*like%), Special Character (Parenthesis)

db.krakens.find({ "fieldName": { "$regex": "\\(" } }) })
 

---

GUI for MongoDB

You could use Compass from MongoDB, which I tried to like:
https://www.mongodb.com/products/compass
 
But I prefer Studio 3T:
https://studio3t.com/free/
 
Note: My preference is based on what I'm familiar with and my easy of use. I'm sure the MongoDB version is awesome.