sharedmodel schema needs to be refined.

Bug #1066165 reported by Robert Bruce Park
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Friends
Fix Released
Medium
Robert Bruce Park

Bug Description

Currently the 'comments' column is an 'as' (array of strings) type, but this is a lossy idea: comments are stored with no author name, author avatar, etc. Quite useless.

What we should really do instead is drop the 'comments' column altogether, and then publish a whole new row for each comment. "Comments" and "Posts" are essentially identical, so using the same schema for each should be a winning idea. Then we can have a new schema column called "parent_id" which would contain the message_id that the comment is a response to. This will allow clients to build a tree-like data structure for displaying threaded comment discussions to the user.

Related branches

Changed in friends:
assignee: nobody → Robert Bruce Park (robru)
Changed in friends:
status: New → Triaged
importance: Undecided → Medium
Changed in friends:
status: Triaged → Fix Committed
Changed in friends:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.