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
- Cannot migrate from Supabase
Hi, I was trying to migrate from Supabase to the Appwrite database. My database had around 190K columns. I tried it twice. Both times, after 2 days, the proce...
- Production down - createExecution return...
Hey, Since 1.9.6 rollout in fra (~17:00 UTC, 14 Aug), POST /v1/functions/{functionId}/executions returns a 400 whenever the body includes an empty headers ob...
- CreateRow is doing ListRows on self-host...
### setup ``` appwrite 1.9.5 self-hosted bun 1.3 node-appwrite 27.1.0 ``` ### issue Im running a function on a self hosted 1.9.5 with "node-appwrite": "^27.1.0...