recommend way of CRUD operations

for a saas platform using flutter, if it has to be scalable and secure and fast , which way of doing CRUD is better?? implementing CRUD operations directly from the client side using Databases API's (list documents, update document ect) or creating a cloud functions for every App functionality and doing CRUD from within the cloud function such that CRUD operations are encapsulated from the client side. and only cloud function API calls will be made from the client for fetching or modifying data.

is there any down sides for using cloud functions for every user interaction with the saas app? ie, for fetching data and modifying data?

and function api is rate limited to 60 per minute per IP address. so if the platform is being used by 60 employees in a company using company WIFI , only 1 function executions can be made per user ??

is there a way to modify the rate per IP by logging into mariaDB and changing any values?

I think it's going to be really rare seeing users triggering at the same time them

A workaround could be triggering it indirectly by changing anything in the database. That way you will not get any rate limit, except of the database limits

i think if every user has a separate account, you ahould be okay.

?

It depends on what you're building. If you need custom or enhanced security features, for example, it's going to be better managing it through functions

However, probably it will be slower

is there a way to allot more priority and allot more RAM to functions?

to make running of functions more smooth and faster?

I've thought they ran smooth and fast by default

I'm not sure if it's possible to make that

you shouldn't face any issues with function execution times. Appwrite is pretty optimized to handle function executions. Obviously, you have to do your best to make sure your function code is optimized as well.

Note they don't run parallel so, it's not that optimized. However, they can be scaled by replicating the corresponding docker container

is there any docs or resources available for me to refer ??

just look up load balancing

normal load balancing woul do the job? no other configs need for the appwrite or docker specifically?

Here you have more details: https://github.com/appwrite/appwrite/issues/1425

It seems that parallel execution is already implemented, or that said Eldad

Except for the ones triggered by events, so give it a 👍 on GitHub if you need that