appwrite-python

Install the appwrite package with pip, then create a Client configured with your endpoint, project ID, and API key from environment variables. Instantiate services like Users, TablesDB, or Storage from that client to make server-side calls.

Use an admin client with an API key to call create_email_password_session, then store the session secret in an httponly cookie named a_session_<PROJECT_ID>. For subsequent requests, create a per-request session client with set_session to act on behalf of the user.

Use TablesDB for all new code, since the Databases class is deprecated. TablesDB provides create_row, list_rows, get_row, update_row, and delete_row methods with the same querying capabilities.

Appwrite grants no access by default, so rows created without permission strings are inaccessible to users. Attach Permission and Role strings like Permission.read(Role.user('[USER_ID]')) when creating rows, or configure permissions at the table level.

Appwrite supports varchar, text, mediumtext, and longtext column types. Varchar is stored inline and fully indexable up to 768 bytes, while text, mediumtext, and longtext are stored off-page and support only prefix indexing.