What is an app?
An app consists of:- Components — UI elements like tables, inputs, and selects arranged on a canvas
- Queries — SQL statements that fetch data from your database
- State — Runtime data from user inputs and query results
Creating an app
- Navigate to the Apps page
- Click “New App”
- Enter a name for your app
- Start building by adding components and queries
App structure
Each app has:| Property | Description |
|---|---|
| Name | Display name for the app |
| Slug | URL-friendly identifier (auto-generated from name) |
Building your app
Once you’ve created an app, you can:- Add components — Drag and drop from the component palette onto the canvas
- Create queries — Write SQL to fetch data from your connected database
- Configure components — Set up each component using basic mode or code mode
- Connect data — Use transforms to display query data in your components
Example workflow
- Create a new app called “User Dashboard”
- Add a Connection to your database
- Create a Query to fetch users:
SELECT * FROM users LIMIT 100 - Add a Table component to the canvas
- Write a transform to display the query results
- Add an Input for search and a Select for filtering
- Update the table transform to filter based on user input