
Appwrite is more like a relational database than a NoSQL database. I do not suggest creating a collection like this because you may run into problems querying data or adding/removing addresses.
I highly recommend creating a collection per data type. Then, you can either use relationships (keep in mind it's still experimental) or manually put the document ids as strings

An example of this is a client whose data is:
Order number: name: payment method: Address: city, street, home address, Its location is on Google Map. Products ordered: Total:

Do i have to create a collection per data type for all of these.

No these would live in one collection

You'd create an attribute for each of these with the appropraite data type

I was hoping if I can mush all of these into one array of map, but I can't.

Why do you want all of these into one array map?

Do you not need to query them?

If you don't need to query this data, you can just use a giant serialized JSON stirng.
If you need to query them, they should be documents in a collection π

This future is in firebase and I'm used to using it.

π

π We're not a NoSQL db heeheee

I understand where you're coming from tho

haha

If you need to query, should be attributes in a collection/

I'm sadπ

If you don't need to query, serialize it and stick it in a String

Ok i will try this.

If you only lookup by user, you cand have a giant array of strings for orders under the user

Ok, thanks.

At least you won't have query times in the hundreds of millisecond range for searching a few strings π

We may add a multi-model DB in the future, support NoSQL like DBs in the future

Also keep your eyes peeled for that π

We're still early stages

<:appwritefire:823999000330895380> <:appwritefire:823999000330895380>
Recommended threads
- Sites 30MB limit from GitHub
Iβm deploying a site from github as Other type on the Hobby plan. It is actually a Flutter web app but itβs in a subdirectory with the root being an html landin...
- Query params are way too limiting in ter...
I was trying to list rows in a table that do not already exist in another table. I retrieved around 260 row IDs which are 13 characters in length each, and then...
- Relationship null, even when relationshi...
Hi Everyone, im experiencing issues with set relation data. When im setting the document id from the related database most of them seem fine, except one table. ...
