Each piece of data or information in Appwrite Databases is a row. Rows have a structure defined by the parent table.
Create rows
Permissions required
You must grant create permissions to users at the table level before users can create rows. Learn more about permissions
In most use cases, you will create rows programmatically.
During testing, you might prefer to create rows in the Appwrite Console. To do so, navigate to the Rows tab of your table and click the Add row button.
List rows
Permissions required
You must grant read permissions to users at the table level before users can read rows. Learn more about permissions
Rows can be retrieved using the List Row endpoint.
Results can be filtered, sorted, and paginated using Appwrite's shared set of query methods. You can find a full guide on querying in the Queries Guide.
By default, results are limited to the first 25 items. You can change this through pagination.
Upsert rows
Permissions required
You must grant create and update permissions to users at the table level before users can upsert rows. You can also grant update permissions at the row level instead. Learn more about permissions
In most use cases, you will upsert rows programmatically.
Permissions
In Appwrite, permissions can be granted at the table level and the row level. Before a user can create a row, you need to grant create permissions to the user.
Read, update, and delete permissions can be granted at both the table and row level. Users only need to be granted access at either the table or row level to access rows.