Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

🚀 Feature: Current output on documents with relationships is exhausting due to abundancies #7502

Open
2 tasks done
step135 opened this issue Jan 28, 2024 · 0 comments
Open
2 tasks done
Labels
product / databases Fixes and upgrades for the Appwrite Database.

Comments

@step135
Copy link

step135 commented Jan 28, 2024

🔖 Feature description

Let's list messages, in each one the user data from another users collection is repeated. This abundancy is causing extreme increase of data transfer. The optimal solution on joining two tables would be:

{messages: [
  {text: "", userId: "a"},
  {text: "", userId: "a"},
  {text: "", userId: "a"},
  {text: "", userId: "b"}
],
users: {
  a: {},
  b:{}
}

In this example we call collection messages. Data from the collection users are added through relationships separately without repeating.

🎤 Pitch

The design of current implementation of relations is the worst possible.

👀 Have you spent some time to check if this issue has been raised before?

  • I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

@stnguyen90 stnguyen90 added the product / databases Fixes and upgrades for the Appwrite Database. label Feb 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
product / databases Fixes and upgrades for the Appwrite Database.
Projects
None yet
Development

No branches or pull requests

2 participants