Database

The database stores your app’s records: tasks, orders, posts, customers. You define it once (tables, columns, relations, who can do what) and then use it from your app with pawabase.from("table"). This section teaches both halves together. For every topic you will see how to do it in Studio (the dashboard), how to do the same thing from code so it can be reviewed and repeated, and how your app uses the result.

The two halves

	You do this	With
Define	Create tables, add columns, set relations and indexes, choose access rules, shape responses	Studio (Data)
Use	Create, read, update and delete records	`pawabase.from("table")` in your app

Because access rules run on the server for every request, your app can call the database directly from a browser. No backend of your own sits in between.

Where the database lives in Studio

Open your project, pick an environment, and choose Data under Data. Its sidebar is the map for this section:

In the sidebar	What it is	Learn
Tables (a searchable list)	Every table. One tagged `resource` is served as an API	Tables and resources
A table’s Data tab	Browse, filter, add and edit rows	The table editor
Columns tab	Names, types, constraints	Columns and types
Access tab	Who may list, read, create, update, delete	Access
Indexes tab	Make queries fast, enforce uniqueness	Indexes
History tab	Schema changes and rollbacks	Migrations and history
Settings tab	Id type, owner, events, realtime, cache, rate limit, relations	Table settings
Tools → SQL	Run queries	SQL editor
Tools → Schemas	Reusable shapes	Schemas
Tools → Topology	A diagram of your tables	Topology
API Explorer	Try the API	API Explorer

Learn it in this order

Build your first table

Quickstart, then How data works.

Define data well

Tables and resources, columns and types, ids and timestamps, relations, indexes.

Read and write

Read records, filter, sort and page, write, bulk.

Protect and shape

Access (with the full Access rules section), caching and limits.

Run it

Events and realtime, import and export, types, patterns, troubleshooting.

A first taste

const task = await pawabase.from("tasks").create({ title: "Write the docs", done: false });

const { data: open } = await pawabase.from("tasks").eq("done", false).order("created_at", "desc");

await pawabase.from("tasks").update(task.id, { done: true });
await pawabase.from("tasks").delete(task.id);

task = pb.from_("tasks").create(title="Write the docs", done=False)

open_tasks = pb.from_("tasks").eq("done", False).order("created_at", "desc").execute().data

pb.from_("tasks").update(task["id"], done=True)
pb.from_("tasks").delete(task["id"])

Getting started

Define your data

Change safely

Read and write

Protect and shape

Studio tools

Build well

The two halves

Where the database lives in Studio

Learn it in this order

A first taste

​The two halves

​Where the database lives in Studio

​Learn it in this order

​A first taste

The two halves

Where the database lives in Studio

Learn it in this order

A first taste