Q&A

can i access tinytable data via API from my own app?

Nov 5

we have a custom dashboard built in react and want to display data from our tinytables in it. is there an API to: - read rows from a table (with filters) - create new rows - update existing rows - delete rows basically CRUD operations via REST API. want to use tinytable as the database for our dashboard without having to maintain our own database also curious about rate limits and authentication

𝕏 in

Comments (3)

Kai Tanaka · Nov 6

yes theres a full REST API for tables. you can do all CRUD operations: - GET /api/tables/:id/rows (with query params for filtering and pagination) - POST /api/tables/:id/rows (create) - PATCH /api/tables/:id/rows/:rowId (update) - DELETE /api/tables/:id/rows/:rowId auth is via API key in the header. rate limits are generous (100 req/sec if i remember right) we use it to power a customer portal built in react. the table is the database and the API is the backend. works well for internal tools and dashboards

Rahul Gupta · Nov 7

this is great. using tinytable as a backend-as-a-service basically. for prototyping and internal tools this is way faster than spinning up a real database

Alex Janssen · Nov 8

the filtering via query params is key. being able to do ?status=active&created_after=2024-01-01 makes it actually usable as a lightweight backend