MongoDB on mLab

MongoDB is a particular implementation of a NoSQL database. There are multiple hosting providers that offer MongoDB implementations “in the cloud” as a service.

The particular one we’ll be using for SPIS 2016 is called mLab (https://www.mlab.com. We are using mLab because:

there is free tier
using the free tier does not require entering a credit card

Use mLab.com directly, not via the Heroku mLab add-on

Note that we NOT using mLab MongoDB Add-On for Heroku—instead, we are using mLab directly through its own console at https://www.mlab.com.

Wait, why aren’t we using the mLab add-on.

Although it is slightly more convenient to use the Heroku mLab add-on, that add-on requires entering a credit card into Heroku (even though it is free). What using the Heroku add-on buys you is that with one click, you can:

Automatically create the database
Automatically fill in the five parts of the configuration info for the database directly into Heroku’s configuration variables
- For the record, those are: (host, port, database name, database username, database password)

When you use mLab directly, you have to do those steps manually. Fortunately, that isn’t very difficult. It’s just slightly tedious, but you typically only have to do it once per application, and then you never have to worry about it again (at least not for that app.)

As an aside, what is free on Heroku?

In fact, the only free services on Heroku that do not require entering a credit card are:

Up to five running applications (but no more than that)
The Heroku Postgres add-on (which is for an SQL-based database)
- We certainly could use Postgres, but its a bit more complicated.
The Heroku Connect add-on (which is for integration with Salesforce.com, something not of particular interest to us in SPIS.)

`Flask-PyMongo` Python Module

There is a Python module called Flask-PyMongo that we can install with pip install to make working with MongoDB easier.

To install it on ACMS, use:

pip install --user Flask-PyMongo

on Windows or Mac, just:

pip install Flask-PyMongo

You’ll also need to make sure that you add these lines to the requirements.txt file for any webapp that you want to run on Heroku with MongoDB:

Flask-PyMongo==0.4.1
pymongo==3.3.0

References