typescript-server

Define tables with `table({ name, public }, columns)` and register them via `schema({...})` exported as default. Create reducers with `spacetimedb.reducer(args, callback)` as named exports, and mutate data through `ctx.db` accessors matching the schema keys.

Use inline `.index('btree')` on a column for single-column indexes, or an `indexes` array entry with `accessor`, `algorithm`, and `columns` for named or multi-column indexes. Access them via `ctx.db.table.accessor.filter(value)`.

Lifecycle hooks must be declared as `export const` using `spacetimedb.init(...)`, `spacetimedb.clientConnected(...)`, or `spacetimedb.clientDisconnected(...)`. Bare calls without export are silently ignored by the module runtime.

No, procedure callbacks are synchronous and must return the declared value directly without `async` or `await`. Perform network I/O with `ctx.http.fetch` before opening a database transaction via `ctx.withTx`.

Types like `t.u64()`, `t.i64()`, and `t.u128()` map to JavaScript `bigint`, so use `0n` literals for inserts and `BigInt()` conversions for computed values. Avoid annotating context as `any`, which can cause bigint expressions to infer as `number`.