News for hackers. Stuff that matters.
Re:Vore: A new RSS feed reader by dotancohen on Monday May 15, 2023 @02:58AM (#35944639)

  > this tight coupling ignores the distributed reality of comments, leaving them with no real place to exist in the data model.
The canonical way to do this is too assign each article a unique identifier, say a primary key, in a table "articles". Then, each comment gets a unique identifier in a table "article_comments" with a foreign key back to the article's unique identifier. This is a well known pattern in databases but could be adapted to any other data structure, even one that is not segmented into tables.

There are no comments on this comment yet.