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
- Urgent help with removed databases
Hi <@564158268319203348> <@501784879638249472> I wrote to paid plan support about this but no response as of yet⦠About an hour ago one of the interns from o...
- MariaDB refuses to connect to appwrite
Earlier, I tried updating my Appwrite version from 18.1.x to the latest release because my Flutter package required it to function properly. I used the official...
- executeFunction intermittently throws Fo...
Environment: Flutter app using the Appwrite Flutter SDK, calling executeFunction for [describe endpoint, e.g. live-stream-related function]. *Description*: Int...