Build like Convex. Own the backend.

// burrow/schema.ts
export default defineSchema({
  messages: defineTable({
    channel: v.string(),
    author: v.string(),
    body: v.string(),
    edited: v.optional(v.boolean()),
  }).index("by_channel", ["channel"]),
});

// burrow/messages.ts
export const recent = query({
  args: { channel: v.string() },
  handler: (ctx, { channel }) =>
    ctx.db
      .query("messages")
      .withIndex("by_channel", (q) => q.eq("channel", channel))
      .order("desc")
      .take(50),
});

export const send = mutation({
  args: { channel: v.string(), body: v.string() },
  handler: async (ctx, args) => {
    const id = await ctx.db.insert("messages", { ...args, author: "me" });
    // written in the same transaction: exists only if send commits
    await ctx.scheduler.runAfter(0, internal.notify.push, { id });
  },
});

// src/Chat.tsx
export function Chat({ channel }: { channel: string }) {
  const messages = useQuery(api.messages.recent, { channel }); // live
  const send = useMutation(api.messages.send);

  if (messages === undefined) return <Spinner />;
  return (
    <>
      {messages.map((m) => <Message key={m._id} {...m} />)}
      <Composer onSend={(body) => send({ channel, body })} />
    </>
  );
}