multi author support - Githubissues

opral / lix-sdk

1 stars 0 forks source link

multi author support #56

Open samuelstroschein opened 2 weeks ago

samuelstroschein commented 2 weeks ago

Context

Changes, commits, etc. can be authored by multiple people/bots.

Modeling multi author relations can be achieved differently e.g. via SQL joins tables for foreign key consistency, JSON array, etc.

Task

SQL join tables or JSON array?

type Change = {
  authors: string[]
}

type Change = {
  authors: "20j3sa2" // @relation ChangeAuthors
}

Pro for SQL join tables

foreign key consistency guarantees if author maps to an account table.

Pro for JSON array

simpler but no foreign key mapping to an author table is possible