Comment/Reply database design decision record

The Samelogic Research Platform allows users to write and post documents representing research and decisions. This is what a Post is for us.

Other users can comment and reply to other comments on the post.

This is a tree structure, meaning selecting the correct database pattern requires fleshed-out user experience requirements.

User Requirements

The comment system is expected to have mostly read and is pretty straightforward in how writes are done.

❗️ It is essential to note that we will not factor votes/reactions into the ranking of comments. Most people will vote/react based on feelings, which will be biased.

Reads

1. Get the latest 30 comments.

2. If more than 30 comments exist, get the latest 10.

Writes

1. Create a new comment to a post or reply to an existing comment.

2. Edit existing comment content and flag it as edited.

3. Remove a comment (use soft delete, flag it as removed)