Lumina

Manuals / SQL / Edit

Chapter studio

Insert after a chapter (numbers shift), add sub-chapters (5.1), edit fields, add/remove steps. Format matches ch() / step schema. Stored in pathwise-manual-edits-v1.

Back to manual

Chapters (12)

  1. 1
    How to use this SQL pathbase · Start · 3 steps
    Open
  2. 2
    SELECT basics — reading rowsbase · A · Query · 3 steps
    Open
  3. 3
    WHERE, ORDER BY & LIMITbase · A · Query · 3 steps
    Open
  4. 4
    JOINs — inner, left, and relationshipsbase · A · Query · 3 steps
    Open
  5. 5
    Checkpoint A — SELECT & JOINsbase · A · Query · 3 steps
    Open
  6. 6
    Aggregations & GROUP BYbase · B · Analyze · 3 steps
    Open
  7. 7
    Subqueries & CTEsbase · B · Analyze · 3 steps
    Open
  8. 8
    INSERT, UPDATE, DELETE safelybase · C · Write · 3 steps
    Open
  9. 9
    Transactions & isolationbase · C · Write · 3 steps
    Open
  10. 10
    Indexes & EXPLAINbase · D · Performance · 3 steps
    Open
  11. 11
    Checkpoint B — SQL job-readybase · D · Performance · 3 steps
    Open
  12. 12
    Timeline, tools & cheat sheetbase · Reference · 3 steps
    Open

Schema

Same fields as data files:

ch({
  id, title, level, minutes, phase, kind,
  parentId,   // sub-chapters
  overview, learn[], steps[{
    title, body, callout, aside,
    code, codeTitle, tip, doThis, quiz, …
  }],
  checklist[], practice, note
})

Pick Edit, Insert after, or Add sub on a chapter.