MongoDB RESTful API structuring

Question

So, I'm trying to create a RESTful API that works similar to reddit, where it has users, topics(subreddits), posts and comments. For that I'm trying to use Node.js and MongoDB.

This is the github repo so far: https://github.com/edmassarani/reddit-clone

The only problem is I don't know how to structure the deletion of documents and it's "dependencies" because a user might own a topic, that topic has posts, those posts have comments and those comments have authors, so how would I go about deleting a user without leaving behind a topic with no owner or a post with no topic and so on? Would it be easier if I were to use a relational database?

Chris · Accepted Answer · 2018-05-24 17:06:24Z

1

I can see on your Github repo that your structured your models like in a relational database (note : you named relational db as 'SQL database' on your question) with normalized data models :

Example : In Topic.js, you refer Posts with reference :

posts: [
    {
      type: mongoose.Schema.Types.ObjectId,
      ref: 'Post',
    },
  ],

It certainly works like it, but with NoSQL and specially with MongoDB you have possibility to embed documents into another document.

Why do not embed Post schema directly into Topic like it :

  posts: [
    {

    title: {
        type: String,
        required: true,
      },
      body: {
        type: String,
        required: true,
      },
      ...
      upvotes: [
        {
          type: mongoose.Schema.Types.ObjectId,
          ref: 'User',
        },
      ],
      comments: [
        {
          type: mongoose.Schema.Types.ObjectId,
          ref: 'Comment',
        },
      ],
    },
  ],

As I can understand, if a Topic is deleted, all Posts related to this Topic have to be deleted.

With embedded schema, you have only one deletion to do.

I don't know if in your context embedded is the best solution (because of perfs), but you have two solutions :

Use different schema (your models files) and you have to manually delete in cascade (exemple : when you delete a Topic, you have to find all Posts references into the Topic and delete them...)
Refactoring and embed : with it, deleting the Topic is also deleting Comments.

See mongodb official docs for more information on embedded schema : https://docs.mongodb.com/manual/core/data-model-design/

answered May 24, 2018 at 17:06

Chris

2341 gold badge3 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

edmassarani Over a year ago

if I do this, wouldn't I also need to embed the comments in the post for them to be deleted in one query?

Chris Over a year ago

Exact, but perfs issue may occurs with too many embedded docs, check limitations about this into mongodb docs

Collectives™ on Stack Overflow

MongoDB RESTful API structuring

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related