Using MongoDB

MongoDB

Our database is stored here (the SandBox account - 0.5 GB with no backups) https://mlab.com/

Quick summary: It's a NoSQL - so they are just documents and they are stored as JSON objects (key-value pairs) NoSQL Explained

We have a users collection currently, and each item is just a JSON, like that: { username: "mary" password: "littlelamb" }

---

MongoDB code:

substitute and with a database user/password (set one up @ mlab.com) Starting up the mongoClient dependencies and initialization

var mongodb = require('mongodb');
const mongoClient = mongodb.MongoClient;
const url = 'mongodb://<dbuser>:<dbpassword>@ds163013.mlab.com:63013/cardsagainsthumanity';

Code to connect to to the database

mongoClient.connect(url, {useNewUrlParser: true}, function (err, db) {
   if (err) {
      console.log ("Error connecting to mongo" + err);
   } else {
      console.log("Successfully connected);
   }
   
   // Now within the body of this connect, you can do stuff
   doStuff();
});

Replace doStuff() with stuff you want to do:

Accessing a collection in the database, 'cardsagainsthumanity' called 'users':

const cahDB = db.db('cardsagainsthumanity');
const userCollection =cahDB.collection('users);

Finding an entry in the collection, like the username:

userCollection.find({username: "mary"}).toArray((err,dbResult) {
   if (err) {
    // handle error
   } else if (dbResult.length) {  // equivalent to if dbResult.length != 0;
    // do something if result is non-zero length (not empty)
   } else {
     // do something is nothing is found
   }

More cheatsheets: Beginner mongodb examples