DEV Community

How Create Relationships with Mongoose and Node.js ( with real example )

MKilmer on October 20, 2019

Before all, not exists JOIN here! Basically is saved the _id from one collection to another collection ( {type: mongoose.Schema.Types.ObjectId,ref:...

Read full post

Jakub Sarnowski • Oct 21 '19

My answer would be: don't. If you need relationships, go for a relational database. IMHO NoSQL databases are for totally different purpose: they're for data, where you don't care about the structure, like logs, analytics data etc. In case you need a structure, NoSQL database is a bad idea because the database doesn't give you any certainty about how the data is structured.

MKilmer • Oct 21 '19

Thanks for your reply.I know about this, but i just only wanted to show that possible create relationships with NoSQL,even though it's not the best solution for building relationships. 🤘 🤘 🤘

Jakub Sarnowski • Oct 21 '19

Sure thing! I don't say your article is bad, it helps a lot! Just wanted to point out my concerns 😄

Samanta Fluture • Aug 27 '21

Awesome tutorial!

Just adding how I managed to work in a slightly different way.

My 'create' function from my post controller looks like this:

create : async (req, res) => {

        const user = req.params.id;
        const { title, subtitle} = req.body;
        const post = await Post.create({
            title,
            subtitle,
            user
        });
        await post.save();

        const userById = await User.findById(user);

        userById.posts.push(post);
        await userById.save();

        return res.send(userById);
    },

Barney • Oct 20 '19

Could you please add request examples?

MKilmer • Oct 20 '19

I added a gif, showing how the routes work. Thanks for the feedback! 😄

Barney • Oct 20 '19

Thank you very much! :) cool post

MKilmer • Oct 20 '19

🤘 🤘 🤘

Emmanuel • Oct 20 '19

Hi, am having an issue with my mongoose command installation on windows terminal: npm install --save mongoose

each time i try to install i get a node file opened from vnode.exe.

any help would be appreciated

Fermin Solis • Oct 21 '19

Just do npm install mongoose, the save is not needed anymore since versión 5.x.x I think. Some one correct me if im wrong.

MANOJ AP • Dec 24 '20

router.post('/user/find',User.find); this line not working

AvoidingLime • Apr 2 '21

Hello, I know this is a post from 2019 but I am following in 2021 - having an issue with the create Post POST - can you show us a POSTMAN example of what ID you used to POST the post?

oluseyeo • Sep 7 '20

Thank you, this was excellent.

vincent muthabuku • Apr 24 '20

also why did you use the router.post request on user/find and user/find/post/:id? Just curious, otherwise great article.
O

berkslv • May 10 '21

Thank you sooo much! mongose docs isn't enough for this :(

DJDole • Oct 22 '19 • Edited

While an interesting exercise, anyone looking production solutions, reconsider.
Never reinvent the wheel.
If you need RDBS, choose RDBS.
Don't shoehorn RDBS into a document-oriented DBS.

MKilmer • Oct 22 '19

Thanks for your reply! Yes, it is for teaching purposes only, when you want to create relationships, I would not recommend using NoSQL. 🤘 🤘 🤘