Schema for website comments

[The Castle Cary Fairy]

Hello all,

I want to build a comments section into a website I am building.

It's a personal project. Just wondering if anyone could share or point me towards a database schema that encompasses the typical entities of such a feature.

 

[WTFH]

I'd suggest just using wordpress.

 

[The Castle Cary Fairy]

I'd suggest just using wordpress.

I want to do it in Angular. It's a learning process as much as anything - but I'd like to have a decent schema as a starting point.

 

[woohoo]

Take a look at MiniBlog. You can have a look at how they have done it though they save to files rather than a db.

https://github.com/madskristensen/MiniBlog

Code specifically for comments

https://github.com/madskristensen/MiniBlog/blob/master/Website/app_code/code/Comment.cs

 

[Snarf]

It going to depend very much on what features you want in the comments section.

Any more info on what you want to do?

 

[The Castle Cary Fairy]

It going to depend very much on what features you want in the comments section.

Any more info on what you want to do?

Oh, the bare rudiments really. Probably doesn't justify an RDBMS solution so something as suggested by Woohoo or a JSON implementation are more likely to be suitable. I literally want to store the comment text, date of posting and associate it with its parent content.

 

[Snarf]

Oh, the bare rudiments really. Probably doesn't justify an RDBMS solution so something as suggested by Woohoo or a JSON implementation are more likely to be suitable. I literally want to store the comment text, date of posting and associate it with its parent content.

I might be misunderstanding, Apologies if so an this isnt what youre looking for:

 

[Snarf]

I might be misunderstanding, Apologies if so an this isnt what youre looking for:

If there is a likelihood that you might want to capture comments against different content types (Stored in different tables) I'd maybe be tempted to change the way that the content links to its comments...

The difference here is that the comment group table is allowing you to link multiple different types of content stored in different tables back to the one comments table whilst maintaining referential integrity.

Let me know if you need more details/if thats not what youre looking for.

 

[The Castle Cary Fairy]

If there is a likelihood that you might want to capture comments against different content types (Stored in different tables) I'd maybe be tempted to change the way that the content links to its comments...



The difference here is that the comment group table is allowing you to link multiple different types of content stored in different tables back to the one comments table whilst maintaining referential integrity.

Let me know if you need more details/if thats not what youre looking for.

Thank you - I think that covers off all I need. It really is the simplest of implementations. So simple, in fact, that an RDBMS solution seems overkill. That said, I could be adding features in the future that would justify it so good to have something that is scalable from the outset.