58-Lesson Curriculum

Learn SapixDB

From first boot to production deployment — complete, hands-on, with real curl examples and challenges in every lesson.

Your progress0 / 58 lessons

Click the checkbox next to any lesson to mark it complete. Progress is saved in your browser.

Foundations

0/6 done

1

The Mental Model

What SapixDB is, why it exists, how it differs from every database you've used.

2

First Boot

Start with Docker, health check, make your first write.

3

Record Anatomy

content_hash, parent_hash, ts_hlc, flags, signature — field by field.

4

Organisms and Agents

Create multiple agents in one organism, understand namespacing.

5

Writing Records in Depth

JSON write, batch write, TTL, the write path internals.

6

Reading Records in Depth

By hash, latest N, scan, time travel, chain_head, count.

Working with Records

0/4 done

7

Soft Delete & Tombstones

How deletion works in an append-only system. What tombstones are.

8

Batch Writes

Write many records in one call. GroupCommitter and throughput.

9

Per-Record TTL

Automatic expiry, the sweeper cycle, good and bad TTL patterns.

10

Schema Validation

Enforce required fields, types, and enums on an agent.

Querying with SaQL

0/7 done

11

SaQL Basics

All query types, the request shape, basic filter syntax.

12

All 15 WhereOp Operators

eq, ne, gt, lt, between, contains, starts_with, in, fts, and more.

13

Compound Filters

Combine conditions with AND, OR, NOT — any depth.

14

Sort Order & Pagination

asc/desc, cursor pagination with after_hlc.

15

Aggregate Functions

sum, avg, min, max, count over a filtered field.

16

Group By

Count or aggregate per group value.

17

Distinct Queries

Find unique field values without loading all records.

Indexes & Performance

0/4 done

18

Single-Field Indexes

Create an index, understand when the engine uses it.

19

Composite Indexes

Index multiple fields for AND-of-eq compound queries.

20

Full-Text Search

Inverted index, tokenizer, the fts operator.

21

Query Explain

See the query plan before execution — index or full scan?

Time & History

0/3 done

22

Time Travel Deep Dive

Query exact past state using as_of. Audit snapshots.

23

Time Range Queries

Window queries across any period. Billing period patterns.

24

Chain Verification

Verify cryptographic integrity. Detect tampering.

Graph & Joins

0/3 done

25

Graph Edges

Create typed directional edges between agents.

26

Graph Traversal

Walk the graph, record-level references.

27

Multi-Agent Joins

Inner-join two agents on a shared field in one SaQL query.

Advanced Query

0/3 done

28

Field Projection

Return only specific fields — reduce payload, hide sensitive data.

29

Natural Language Queries

Ask in plain English. Heuristic vs LLM planner.

30

Streaming Queries (SSE)

Live stream of records matching a filter.

Binary Storage

0/1 done

31

BlobStore

Upload files, retrieve by hash, link to strand records.

Auth & Security

0/5 done

32

Master Seed & Encryption

AES-256-GCM payload encryption, HKDF derivation, what stays plaintext.

33

Root Key & API Auth

SAPIX_ROOT_KEY, open vs auth mode, authentication on every request.

34

Scoped API Keys

Per-service keys with limited scopes, revoke independently.

35

Key Delegation & Rate Limits

Delegate key creation authority, set per-key rate limits.

36

Key Rotation

Rotate root key (instant) and master seed (migration).

Automation

0/3 done

37

Cron Jobs

Schedule recurring jobs inside SapixDB — no external scheduler.

38

Triggers

Fire an action whenever a matching record is written.

39

Mutants (AI Schema Evolution)

AI-proposed schema changes. Human approval before apply.

Real-Time

0/3 done

40

Per-Agent SSE Stream

Stream every new record from a specific agent in real time.

41

Global Broadcast Bus

All events across all agents, publications and topic subscriptions.

42

Durable Publications

Named change-feeds with server-side cursor tracking, subscriber slots, backfill on reconnect, and at-least-once ACK.

Operations

0/3 done

43

Epigenetic Profiles

Switch between default, high_load, compliance, analytics, maintenance.

44

Snapshots & Backups

Point-in-time snapshots, restore, automated backup scripts.

45

WAL & Checkpoints

What the WAL is, when to checkpoint, manual flush.

Enterprise

0/3 done

46

HIPAA Compliance Mode

PHI field tagging, access logging, HIPAA audit reports.

47

SOX Compliance

Dual-admin controls, SOX-tier agents, audit reports.

48

Codios Authorization

Contract-based write authorization for multi-agent systems.

SDKs

0/3 done

49

Python SDK

Full walkthrough: write, query, stream, batch — no curl.

50

TypeScript SDK

Typed payloads, async/await, React hooks for live data.

53

Go SDK

Zero-dependency Go client: write, query, time travel, graph edges, SSE streaming.

Production

0/2 done

51

Production Deployment & Mesh Replication

Production config, secrets management, HA replication, full checklist.

52

Replication Reliability

Retry queue for durable push replication, Codios auth cache, circuit breaker, and ops runbook.

Add-ons

0/2 done

54

Mail Add-on

Embed SMTP email in your agent: send transactional email with no external SaaS, audited on-chain.

55

Chat Add-on

Persistent multi-room messaging inside sapix-agent: strand-backed, real-time SSE, agent-to-human workflows.

Administration

0/3 done

56

CLI (sapix)

Every admin operation from the command line: status, chain verify, keys, peers, mutants, blobs, organisms.

57

Sherapd & Alabay Watchdogs

Built-in performance and security watchdogs: query their strands, understand severity levels, ops runbook.

58

DBA Agent

External 24/7 Resident Agent: chain tracking, daily reports, auto-remediation, multi-instance support.

Ask a question

Stuck on a concept, a curl command, or something unexpected? Send your question and the team will respond — usually within one business day.

Prefer the raw docs? Read the manual →