Xtykutl

I am building an app that allows users to make public posts, you can make a post and view all new posts on the home page. I am struggling to find the best way to efficiently structure the database data and monitor all new posts that are made, as currently if a user is logged in, they can post anything without restriction. I need an effective way to screen posts for content that is uploaded to Firebase, or even a solution that when a new post is made it is sent for approval, rather than being sent on the database straight away. How should I manage this?

Here is the way that posts are uploaded to the database, I use duplicates of this structure also under authors and categories, which I am not sure if it is a good way to do it or not, should I be finding a way to have 1 instance of a post on the database, and instead use some kind of IDs to find it in different situations such as by author or by category?

     "posts": {

           -childGeneratedKey: {

                      author: "author",

                      body: "body",

                      category: "category",

                      post_date: "1541784510.682485",

                      post_id: "childAddedID",

                      title: "post_title",

                      votes:"0",

                     }

             -childGeneratedKey: {...

             }

Here is how I handle posting in-app:

 func createPost(title: String, body: String) {



   let timeInterval = NSDate().timeIntervalSince1970

    let timeDouble = Double(timeInterval)



      ref = Database.database().reference()

        let posts = self.ref.child("posts")

        let post_id = posts.childByAutoId().key!

        let category = self.category

        let post_date = timeDouble



    if postTitle != "" {



        let newPost: Dictionary<String, Any> = [

            "title": title,

            "body": body,

            "votes": 0,

            "author": username,

            "post_id": post_id,

            "category": category,

            "post_date": post_date



        ]



        if privatePost == false {

        createNewPost(post: newPost, post_id: post_id, category: category)

        } else if privatePost == true {

            createnewPrivatePost(post: newPost, post_id: post_id, category: category)

        }



    }

}



func createNewPost(post: Dictionary<String, Any>, post_id: String, category: String) {



    let user_id = Auth.auth().currentUser?.uid

    let posts = self.ref.child("posts")

    let authors = self.ref.child("authors")

    let categories = self.ref.child("categories")

    let users = self.ref.child("users")



    posts.child(post_id).setValue(post)

    authors.child(user_id!).child("posts").child(post_id).setValue(post)

    categories.child(category).child("posts").child(post_id).setValue(post)

    users.child(user_id!).child("posts").child(post_id).setValue(post)





}

I am finding it hard to find the best structure to handle this type of data and an efficient way to screen it to ensure that the content is acceptable (no abusive content etc) Please point me to the best way to handle a blog post type situation like this and how I can best monitor the posts that are set to the database, Thank you.