TablesDB_
Store and query structured data with Appwrite TablesDB. Tables provide performant and scalable storage for your application, business, and user data.
1 min read
Appwrite Databases let you store and query structured data. Databases provide high-performance and scalable data storage for your key application, business, and user data.
Databases store data, if you need to store files like images, PDFs or videos, use Appwrite Storage.
You can organize data into databases, tables, and rows. You can also paginate, order, and query rows. For complex business logic, Appwrite supports relationships to help you model your data.
Concepts
Databases
Create and manage databases, the largest organizational unit.
Tables
Define typed columns and indexes for structured data.
Rows
Create, read, update, and delete rows.
Permissions
Control access at the table and row level.
Relationships
Model one-to-one, one-to-many, and many-to-many relations.
Queries
Filter rows with comparison, string, and logical operators.
Order
Sort results by one or more columns.
Backups
Schedule backup policies and restore from any backup.
Guides
Pagination
Page through results with offset or cursor pagination.
Transactions
Stage operations and commit or roll them back atomically.
Type generation
Generate types for your tables in your language of choice.
Offline sync
Keep data available offline and sync when back online.
Bulk operations
Create, update, upsert, or delete many rows in one request.
CSV imports
Import rows from CSV files.
CSV exports
Export tables to CSV files.
Was this page helpful?
Share what worked or what we should fix. Once approved, our agents automatically apply suggested updates to the docs.