Overview

Custom tables let your project provision its own database tables alongside Sublay’s built-in models — the app-specific data that doesn’t fit a built-in feature. In React and React Native, you read a table’s rows with the useTable hook and a single row with useTableRow. For the full feature overview — the custom_ naming model, managed columns, soft-delete, and the dashboard editor — see Custom Tables.

@sublay/core is hook-only — there is no imperative client.table(...) in the React SDK. useTable and useTableRow are the custom-table surface. For an imperative, server- side client use @sublay/node; for browser/vanilla JS, use @sublay/js.

The hook

useTable(name) returns the table’s rows plus loading state, query controls (page, sort, filters, soft-delete visibility), and row CRUD actions. The query knobs are held in the Redux store keyed by table name, so multiple components reading the same table share one view.

import { useTable } from "@sublay/react-js";

type EventRow = {
  id: string;
  name: string;
  capacity: number;
  createdAt: string;
};

function EventsTable() {
  const { rows, loading, setSort, setFilters, createRow } =
    useTable<EventRow>("Events");

  if (loading) return <Spinner />;

  return (
    <>
      <button onClick={() => setSort("capacity", "desc")}>Sort by capacity</button>
      {rows.map((e) => (
        <div key={e.id}>{e.name} — {e.capacity}</div>
      ))}
      <button onClick={() => createRow({ name: "New event", capacity: 50 })}>
        Add
      </button>
    </>
  );
}

The name you pass is the logical table name — Sublay applies the custom_ prefix for you. Both hooks are re-exported from @sublay/react-js, @sublay/react-native and @sublay/expo.

Reads, filters, and soft delete

Rows come back already paginated, sorted, and filtered according to the table’s stored view. Adjust the view with setPage, setSort, setFilters, and setIncludeDeleted. Filters are { column, operator, value } clauses (AND-combined) using the operators eq, ne, gt, gte, lt, lte, in, contains, like, isNull. On a paranoid table, soft-deleted rows are hidden by default; call setIncludeDeleted(true) to surface them, and restoreRow(id) to bring one back. deleteRow(id) soft-deletes on a paranoid table (pass { force: true } to hard-delete) and hard-deletes otherwise.

Hooks

useTableRow

One row by ID, for a detail view.

useTable

Full reference — props, return values, and the CRUD actions.

Row CRUD on the /db surface is currently open — identity is captured but not enforced. See the security note before storing access-controlled data in custom tables.

Setup

Authentication

Users

Entities

Entity Lists

Comments

Reactions

Reputation

Spaces

Workspaces

Events

Chat

Collections

Relationships

App Notifications

Push Notifications

Search & AI

Storage

Moderation

Custom Tables

The hook

Reads, filters, and soft delete

Hooks

useTableRow

useTable

​The hook

​Reads, filters, and soft delete

​Hooks

useTableRow

useTable

The hook

Reads, filters, and soft delete

Hooks