Counting Blog Post 'Likes'

[mrpavlitzky]

Hi,

I'm preparing to implement 'Thumbs Up' functionality for blog posts and I have a following dillema. Since I don't have much experience with document based databases (which as far as I know is how Orchard stores Content Items) I wonder what's the most optimal way to store the number of likes of every post. Suppose I'd like to add a module which shows the number of likes under each post. Would it then be reasonable to add a numeric field to the Blog Post content definition or maybe create a separate sql table with post_id and likes_count columns.

[hyzx86]

Enable the SQL Index Feature

Define a ContentType like this , (not C# only，you can create with UI also):

public class MyCollectionPart : ContentPart
{
   public ContentPickerField PostId {get; set;}
   public UserPickerField UserId {get; set;}
}

Then you can add a content to MyCollection, after user click.

[mrpavlitzky]

@hyzx86 thanks for the suggestion. I'll have posts liked by unregistered users so I think I'll stick to updating a LikeCount content part on click event in every blog post.