Granting Access to another Projects database.

I have two Application using Appwrite and Users from both applications must be able to access certain collection of the other Database. I am in the process of solving this issue with an API KEY to grant access. However to hide it securely with dotenv i must set up a backend server with node.js. I was wondering if there is a better way to do this? Help is very much appreciated!

You can use an Appwrite function and grant it access to your database, it will automatically generate and API key that will be available in your function runtime env vars.

This way, you don't to manage API keys, or external servers or worry about scale.