Add comment system

[FelixCCWork]

General design:

• Flat comment tree with one level of depth (Users can reply to top level comments)

• Users can use @ sign to mention other users (needed?)

• Comments and replies are stored in separate SQL tables

• We need a system to report comments and replies as inappropriate

• We need to handle deleted user accounts

  • On deletion replace the users information with randomized data (eg. name, mail, etc)
  • Mark the user as deleted (soft delete)
  • When showing comments written by a deleted user, show a one time valid random user name. With this logic a user could be identified within a blog posts comment section but not across different blog posts

• Admins need to be able to delete comments and replies

Usefull libs:

• https://github.com/stephenhaunts/ProfanityDetector