My (augmented todo-list) website has Categories, and each Category has a set of Tasks (aka “one-to-many”).
Using a relational database, one does not simply store references to all the Tasks directly in each Category. With Mongo, one may do exactly that.
After looking at various “embedded vs references” documents, I have decided to go with the hybrid model (the second of the three on that linked page), and embed references to Tasks in an array in each Category.
The console shall reveal the way to accomplish this
My lack of sustained googling didn’t turn up any online resources about how to do it, so here you go.
After installing MongoDB with Homebrew, it became clear that the configuration was still incomplete (perhaps because brew lacks root access to the root directory). StackOverflow told me how to finish. I show you.
1 2 3 4 5 6 7 8
Write the code
Now let’s do an example of having a one-to-many relationship between Categories and Tasks, where in particular, we are storing an array of Task id’s in each Category. In the end we will write a query to get all Tasks belonging to a Category.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29