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

Materialized derived AR infrastructure

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Schema Change, Scripts
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  Packages

                  Version Package