I have a attribute items in my database and i want to store a list of Item objects which includes name, ID and price... I'm not able to figure out how do I achieve this with appwrite database
The best approach is to make a collection for those items
The database servers us in this way: Database > Collection > Document My database is 'orders' for storing all the all the orders, so each order will be a collection storing the necessary details, such as order ID, username, phone, address, items.. How can I create a collection inside a document?
In general, I recommend having a collection per object type. I would only create separate databases if there was some specific reason
You're telling me to create another collection for items, i got it.. But how I'll link it with the order of which the items( stored in the items collection)?
Have an order ID attribute in items
Hmm...Okay.. and while fetching the list of documents, I can filter it out by querying the Order ID... For that i need to add create index for the order id, right?
Got it, Thank you for the help 😊
[SOLVED] How do I store list of maps in appwrite database?
Recommended threads
- 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...
- Accidental deletion of two production da...
Hello Appwrite Support, We accidentally deleted two production databases and urgently need your help restoring them. What happened: On 2026-08-14 at approxima...