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
- API key without database.read/write
I had some issues with my previous API key and I deleted it then I wanted to create a new one and discovered the database checkbook has no database.read/write j...
- dynamic key missing scopes for database ...
Here are the scopes listed, I get permission errors for reading row and document. Appears to be missing since last time i checked. Database 6 Scopes policies....
- Upgrading selfhost version?
It is okay to upgrade version to higher one, of my current version is 1.7.4 to 1.8.1. Is that safe to do cause my clients already have data on that? Also is a...