Still unsure on the pros and cons of relationship for building a reddit like app should i be designing one-to-many for post to comments and one-to-one for user to comment. will this give any benefit?
TL;DR
Developers are discussing the benefits of relationships in database design for a Reddit-like app. Storing `IDs` of related docs in the document is recommended for performance. Use one-to-many for post to comments and one-to-one for user to comment for best results.Relationships are very experimental and can have performance bottlenecks. It'd better to store the IDs of the related docs in the document.
Recommended threads
- Introducing new string column types made...
Adding new string types is hugely bennificial! Unfortunately it made the current column types not editable to change their types to the new longer field types.
- there is critical problem in this part
when user update the integer and double both get error not update or upload
- Python function - error while creating /...
I have been trying to figure it out myself for the last 2 days. I have self-hosted appwrite instance, and I am running python 3.12 function. It works great up t...