appwrite-python

Install the appwrite package with pip, then create a Client configured with set_endpoint, set_project, and set_key using an API key stored in an environment variable. From that client you instantiate services like Users, TablesDB, Storage, and Functions.

Use tables_db.list_rows with Query helpers such as Query.equal, Query.greater_than, Query.order_desc, and Query.limit. For pagination prefer Query.cursor_after over offset, and use Query.select to return only specific fields.

Use TablesDB for all new code because the Databases class is deprecated. Only use Databases when an existing codebase already relies on it or it is explicitly requested.

Use two clients: an admin client with an API key that creates sessions, and a per-request session client that reads the a_session_<PROJECT_ID> cookie. Set the cookie with httponly, secure, and samesite='Strict' after calling create_email_password_session or create_session.

Appwrite grants no access by default, so rows created without permission strings are inaccessible to everyone. Pass permissions like Permission.read(Role.user('[USER_ID]')) when creating rows, or configure table-level permissions, and avoid Role.any() with write actions.

Use storage.create_file with a bucket ID, a unique file ID, and an InputFile built via from_path, from_bytes, or from_string. You can attach permission strings in the same call to control who can read, update, or delete the file.