Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-7722

Materialized derived AR infrastructure

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • Schema Change, Scripts
    • None

      As discussed in the meeting, we should design a structure for deriving links; our current use cases for this are links to CritiqueBrainz derived from the existence of reviews, and links to Wikipedia derived from Wikidata links.

      As far as the schema change bits, it'd presumably just be an 'is this derived' column to add to the l_ tables to track links created and managed by this system, and thus deny direct editing on them by users, etc. The architecture of the thing that changes these rows is less clear. Current idea is have something that pushes changes of potential relevance to a message queue and then acts on them by calling out to APIs and updating the materialized version in the table.

            Unassigned Unassigned
            ianmcorvidae Ian McEwen
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

                Version Package