Skip to content
Back

Pros of relationship

  • 0
  • Databases
  • Cloud
KINGKabir👑
13 Apr, 2025, 07:14

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.
Darshan Pandya
13 Apr, 2025, 07:31

Relationships are very experimental and can have performance bottlenecks. It'd better to store the IDs of the related docs in the document.

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more