Back

[SOLVED] Nesting in Relationship of multiple collections.

  • 1
  • Databases
  • Flutter
Hemish11
19 Jun, 2023, 17:08

For upload its 5mb if i guess so

TL;DR
Solution: The user was asking about nesting in a relationship of multiple collections in the appwrite backend. They were concerned about limits on the number of documents and response size. The default limit is 25 documents per request, but it can be increased. Pagination should be used for best practices. The query.limit() maximum limit has been removed in version 1.3. There is also a size limit of 8k characters for the response. There is no limit on the size of the request body JSON for a function. However, it is not possible to delete a file from storage automatically after a certain time period. The upload size limit
Drake
19 Jun, 2023, 17:08

No

Hemish11
19 Jun, 2023, 17:09

Got it, thanks a lot, and also one little thing, is it possible to delete the file from storage after 1 month or 2 weeks or so? Likc is there a way for the same?

Hemish11
19 Jun, 2023, 17:11

Ohh, and one little thing, is there any limit on size of the request body json for a function?

Drake
19 Jun, 2023, 17:13

Yes, you can write a function to do that

Drake
19 Jun, 2023, 17:13

Yes, 8k characters

Hemish11
19 Jun, 2023, 17:17

got it, thanks a lot for heping me, it means a lot to me

joeyouss
20 Jun, 2023, 13:24

Please mark the post as [SOLVED] if you don't need anymore help here @Hemish11

Hemish11
20 Jun, 2023, 16:28

Will do it, just had one thing to ask,

Hemish11
20 Jun, 2023, 16:28

Steven, do we also have a response size limit when we directly get data from the database, using database api?

Hemish11
20 Jun, 2023, 16:29

Lets say if i want to fetch multiple documents from a given collection, the total documents can be in range of like 500 to 1000, so will it be size limited?

Hemish11
20 Jun, 2023, 16:29

Each document would have about 5-6 parameters and also a few will be in relation with other collection but wont get longer than 3, and the related colletion can also have anywhere between 4-10 parameters of string and double

Hemish11
20 Jun, 2023, 17:27

@Steven ??

Hemish11
20 Jun, 2023, 17:27

You were online so pinged you, if you were busy, sorry for it

Drake
20 Jun, 2023, 18:54

The default limit is 25 documents. Ideally, you should paginate (https://appwrite.io/docs/pagination). That said, we removed the maximum limit on Query.limit() in 1.3.

Hemish11
21 Jun, 2023, 01:32

I thought that I would get the entire tree in a flat manner and thereby would make it in tree form in front end

Hemish11
21 Jun, 2023, 01:33

How can I increase this limit?

Drake
21 Jun, 2023, 02:03

What do you mean?

Hemish11
21 Jun, 2023, 04:13

Like it defaults to 25 documents so is it possible to increase that limit?

Drake
21 Jun, 2023, 04:15

Did you take a look at the docs I linked?

Hemish11
21 Jun, 2023, 04:38

Got it, thanks a lot

joeyouss
21 Jun, 2023, 12:02

Hey, please refrain from tagging the members directly kindly

Hemish11
21 Jun, 2023, 12:09

I’m really sorry for it, but as I mentioned earlier it’s very urgent for me as we are currently migrating old backend to appwrite and also we are on a very tight schedule

Hemish11
21 Jun, 2023, 16:50

[Solved] Nesting in Relationship of multiple collections.

Drake
21 Jun, 2023, 17:19

[SOLVED] Nesting in Relationship of multiple collections.

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more