kevinww•3w ago

array vs join table

If I have a 1:N relationship between things, should I use an array or a separate table like I would in a relational database? eg.:

cohortsTable = [{id: "cohort1", enrollments: ["user1", "user2"]}]

cohortsTable = [{id: "cohort1", enrollments: ["user1", "user2"]}]

cohortsTable = {id: "cohort1"}
enrollmentsTable = [{cohortId: "cohort1", enrollment: "user1"},
{cohortId: "cohort1", enrollment: "user2"}]

cohortsTable = {id: "cohort1"}
enrollmentsTable = [{cohortId: "cohort1", enrollment: "user1"},
{cohortId: "cohort1", enrollment: "user2"}]

Is there an article discussing the tradeoffs and how to decide between the two options?

2 Replies

Convex Bot•3w ago

Thanks for posting in <#1088161997662724167>. Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets. - Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.) - Use search.convex.dev to search Docs, Stack, and Discord all at once. - Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI. - Avoid tagging staff unless specifically instructed. Thank you!

erquhart•2w ago

The latter, you generally don't want to use nested document data for relations/foreign keys.

array vs join table

Did you find this page helpful?