Supabase Database¶
Non-Visible component| Category | Requires | Version |
|---|---|---|
| Storage | API 21, Android 5.0 Lollipop | 1 |
Overview¶
A non-visible component that provides database operations via Supabase PostgREST API. Supports query building with filters, ordering, and pagination, CRUD operations, and RPC function calls.
Events¶
Error Occurred¶
Fired when any operation fails
| Param | Type |
|---|---|
| operation | Text |
| status Code | Number |
| message | Text |
Got Function Result¶
Fired after a successful RPC function call
| Param | Type |
|---|---|
| result | Any |
Got Rows¶
Fired after a Select or RawQuery with the resulting rows
| Param | Type |
|---|---|
| rows | List |
| operation | Text |
Row Inserted¶
Fired after a successful Insert with the returned row
| Param | Type |
|---|---|
| row | Dictionary |
Rows Deleted¶
Fired after a successful Delete with deleted rows
| Param | Type |
|---|---|
| rows | List |
| count | Number |
Rows Inserted¶
Fired after a successful BulkInsert with the returned rows
| Param | Type |
|---|---|
| rows | List |
Rows Updated¶
Fired after a successful Update with affected rows
| Param | Type |
|---|---|
| rows | List |
| count | Number |
Methods¶
Add Filter¶
Add a PostgREST filter. Operators: eq, neq, gt, gte, lt, lte, like, ilike, is, in, cs, cd, ov, fts, plfts, phfts, wfts. Operators are passed through to the server without validation.
| Param | Type |
|---|---|
| column | Text |
| operator | Text |
| value | Text |
Bulk Insert¶
Insert multiple rows into the table
| Param | Type |
|---|---|
| data | List |
Call Function¶
Call a Supabase database function (RPC)
| Param | Type |
|---|---|
| function Name | Text |
| params | Dictionary |
Clear Query¶
Clear all query builder state
Delete¶
Delete rows matching the current filters. Requires at least one filter to prevent accidental full-table deletes.
Insert¶
Insert a new row into the table
| Param | Type |
|---|---|
| data | Dictionary |
Raw Query¶
Execute a raw query with custom PostgREST query parameters
| Param | Type |
|---|---|
| table | Text |
| query String | Text |
Select¶
Select rows from the table using current builder state
Set Columns¶
Set which columns to return (comma-separated)
| Param | Type |
|---|---|
| columns | Text |
Set Limit¶
Set the maximum number of rows to return
| Param | Type |
|---|---|
| limit | Number |
Set Offset¶
Set the number of rows to skip (for pagination)
| Param | Type |
|---|---|
| offset | Number |
Set Order¶
Set the ordering for results
| Param | Type |
|---|---|
| column | Text |
| ascending | Boolean |
Set Table¶
Set the target table for the next operation
| Param | Type |
|---|---|
| table | Text |
Update¶
Update rows matching the current filters. Requires at least one filter to prevent accidental full-table updates.
| Param | Type |
|---|---|
| data | Dictionary |
Properties¶
Access Token¶
Text 
Read Write - Blocks
JWT auth token from SupabaseAuthentication (optional, enables RLS). Set at runtime from SupabaseAuthentication.AccessToken after sign-in.
Default Schema¶
Text Default: public Read Write - Designer Blocks
The default database schema
Project URL¶
Text Read Write - Designer Blocks
The Supabase project URL (e.g. https://xxx.supabase.co)
Publishable API Key¶
Text Read Write - Designer Blocks
The Supabase publishable API key