On a related note, say I want to build my own commenting system (self hosted), any good papers / articles / discussion topics to share? Topics from db structur

On a related note, say I want to build my own commenting system (self hosted), any good papers / articles / discussion topics to share? Topics from db structure to how to handle nesting(display wise), sorting (top / trending), etc. Some gotchas which we might miss.