I'm confused about the structure of Databases.
We have Database -> Collection -> Document -> Attributes
. This somehow seems to be one layer too much.
I want documents that contain additional information about users, e.g. how many products they bought, favourite product, ...
How should I structure my Database? I thought of
[Database] UserInfo -> [Collection] ??? -> [Document] User1 -> [Attributes] all attributes of this user
.
What should "collection" be? Or do I have a fundamental misunderstanding of how databases are supposed to be structured?
Recommended threads
- Query Appwrite
Hello, I have a question regarding Queries in Appwrite. If I have a string "YYYY-MM", how can I query the $createdAt column to match this filter?
- Type Mismatch in AppwriteException
There is a discrepancy in the TypeScript type definitions for AppwriteException. The response property is defined as a string in the type definitions, but in pr...
- What Query's are valid for GetDocument?
Documentation shows that Queries are valid here, but doesn't explain which queries are valid. At first I presumed this to be a bug, but before creating a githu...