Would love to see an API for uploading files/pics. I would use it on my iPhone with Shortcuts as a way to fix the issue that only pictures can be uploaded.
Nodes are not stored individually on our server, so the server will do more work if it were to find the specific node in the document for you. It would be fastest to pass the entire document alone and you can walk the tree to find the node.
Are you running into rate limiting issues? We recently raised the limit, realizing some folks need to have things updated pretty often.
We used to store nodes separately as rows in the DB table but at some point, we realized that DB performance would be quite bad since rows from multiple documents would start to get shuffled around inside the billion-row table and even properly indexing the table it would be quite a disaster for the DB to constantly fetch from multiple sectors.
More than 3 years ago we decided to move all node data to be stored in a per-document blob.
The biggest deciding factor was that the most frequent operations done were on a per-document level, meaning there’s a lot of node lookups in parent-child relationships, changes to multiple nodes under the same document, etc… which usually happened all at once per sync attempt.