Auto-follow objects created by user

Feature Request

When a user creates an object (proposition, document, tag, source), it should automatically be added to their default follow list ("My Follows").

Current Behavior

Objects must be manually added to follow lists via the Quick Follow button or Add to List dropdown. There are no triggers or automatic mechanisms to add newly created objects to the creator's default follow list.

Proposed Behavior

When a user creates any of the following entity types, automatically add them to the user's default follow list:

  • Propositions
  • Documents
  • Tags
  • Sources

Implementation Notes

  • Add database triggers on the relevant tables (propositions, documents, tags, sources) that insert into follow_list_entries after creation
  • The trigger should look up the creator's default follow list (where is_default = true) and add the new entity
  • Consider making this behavior configurable via user settings

Related Files

  • ratings-sql/V077__follow_lists.sql - Follow list schema
  • ratings-sql/R__065_follow_lists_api.sql - Follow list API functions
  • ratings-ui-demo/src/pvcomponents/pv-quick-follow-button.tsx - UI component for following