appwrite-dart

Use the Account class from the appwrite Flutter package to call createEmailPasswordSession for email login or createOAuth2Session for providers like Google. New users are registered with account.create using a unique ID from ID.unique().

Use TablesDB.listRows with Query helpers such as Query.equal, Query.greaterThan, Query.orderDesc, and Query.limit. Prefer cursor pagination with Query.cursorAfter for large datasets, and use TablesDB rather than the deprecated Databases class.

The appwrite package is for client-side Flutter apps and acts as the logged-in user, while dart_appwrite is for server-side Dart and uses an API key for admin operations like user management and database creation.

Yes, the Realtime class in the client SDK subscribes to channels for rows, files, teams, and function executions. The subscription stream emits events and payloads, and you close it with subscription.close() when done.

Appwrite grants no access by default, so rows without explicit permissions are inaccessible to everyone including the creator. Add permissions like Permission.read(Role.user(userId)) when creating the row, or configure table-level permissions.

Create the session with an admin client using an API key, then store the session secret in an HttpOnly, Secure, SameSite=Strict cookie named a_session_<PROJECT_ID>. Build a per-request session client with setSession for authenticated calls.