Normilization Best Practices
Does anyone have a guide to best practices for normilization of the tables in Convex, maybe assumptions you would do in RDMS/SQL but wouldn't do in Convex.
5 Replies
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!
I think that in general, the same rules apply. I personally prefer to start with a fully normalized data model, and only denormalize as performance requires.
Yeah that seems to be my approach also
If you have questions about specific scenarios, feel free to share those and we'll be glad to try to advise as well!
Yeah I think I have a lot of cases where in my SQL db I have a table that only holds like many to many, that are usually only a couple to the main entity.
Like
Contact to ContactRoles to Roles , maybe it has a few extra fields on the ContactRoles like start and end date but that is it