50-Lesson Curriculum

Learn SapixDB

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

Your progress6 / 50 lessons

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

Foundations

6/6 done
1
The Mental Model
What SapixDB is, why it exists, how it differs from every database you've used.
Review
2
First Boot
Start with Docker, health check, make your first write.
Review
3
Record Anatomy
content_hash, parent_hash, ts_hlc, flags, signature — field by field.
Review
4
Organisms and Agents
Create multiple agents in one organism, understand namespacing.
Review
5
Writing Records in Depth
JSON write, batch write, TTL, the write path internals.
Review
6
Reading Records in Depth
By hash, latest N, scan, time travel, chain_head, count.
Review

Working with Records

0/4 done
7
Soft Delete & Tombstones
How deletion works in an append-only system. What tombstones are.
Start →
8
Batch Writes
Write many records in one call. GroupCommitter and throughput.
Start →
9
Per-Record TTL
Automatic expiry, the sweeper cycle, good and bad TTL patterns.
Start →
10
Schema Validation
Enforce required fields, types, and enums on an agent.
Start →

Querying with SaQL

0/7 done
11
SaQL Basics
All query types, the request shape, basic filter syntax.
Start →
12
All 15 WhereOp Operators
eq, ne, gt, lt, between, contains, starts_with, in, fts, and more.
Start →
13
Compound Filters
Combine conditions with AND, OR, NOT — any depth.
Start →
14
Sort Order & Pagination
asc/desc, cursor pagination with after_hlc.
Start →
15
Aggregate Functions
sum, avg, min, max, count over a filtered field.
Start →
16
Group By
Count or aggregate per group value.
Start →
17
Distinct Queries
Find unique field values without loading all records.
Start →

Indexes & Performance

0/4 done
18
Single-Field Indexes
Create an index, understand when the engine uses it.
Start →
19
Composite Indexes
Index multiple fields for AND-of-eq compound queries.
Start →
20
Full-Text Search
Inverted index, tokenizer, the fts operator.
Start →
21
Query Explain
See the query plan before execution — index or full scan?
Start →

Time & History

0/3 done
22
Time Travel Deep Dive
Query exact past state using as_of. Audit snapshots.
Start →
23
Time Range Queries
Window queries across any period. Billing period patterns.
Start →
24
Chain Verification
Verify cryptographic integrity. Detect tampering.
Start →

Graph & Joins

0/3 done
25
Graph Edges
Create typed directional edges between agents.
Start →
26
Graph Traversal
Walk the graph, record-level references.
Start →
27
Multi-Agent Joins
Inner-join two agents on a shared field in one SaQL query.
Start →

Advanced Query

0/3 done
28
Field Projection
Return only specific fields — reduce payload, hide sensitive data.
Start →
29
Natural Language Queries
Ask in plain English. Heuristic vs LLM planner.
Start →
30
Streaming Queries (SSE)
Live stream of records matching a filter.
Start →

Binary Storage

0/1 done
31
BlobStore
Upload files, retrieve by hash, link to strand records.
Start →

Auth & Security

0/5 done
32
Master Seed & Encryption
AES-256-GCM payload encryption, HKDF derivation, what stays plaintext.
Start →
33
Root Key & API Auth
SAPIX_ROOT_KEY, open vs auth mode, authentication on every request.
Start →
34
Scoped API Keys
Per-service keys with limited scopes, revoke independently.
Start →
35
Key Delegation & Rate Limits
Delegate key creation authority, set per-key rate limits.
Start →
36
Key Rotation
Rotate root key (instant) and master seed (migration).
Start →

Automation

0/3 done
37
Cron Jobs
Schedule recurring jobs inside SapixDB — no external scheduler.
Start →
38
Triggers
Fire an action whenever a matching record is written.
Start →
39
Mutants (AI Schema Evolution)
AI-proposed schema changes. Human approval before apply.
Start →

Real-Time

0/2 done
40
Per-Agent SSE Stream
Stream every new record from a specific agent in real time.
Start →
41
Global Broadcast Bus
All events across all agents, publications and topic subscriptions.
Start →

Operations

0/3 done
42
Epigenetic Profiles
Switch between default, high_load, compliance, analytics, maintenance.
Start →
43
Snapshots & Backups
Point-in-time snapshots, restore, automated backup scripts.
Start →
44
WAL & Checkpoints
What the WAL is, when to checkpoint, manual flush.
Start →

Enterprise

0/3 done
45
HIPAA Compliance Mode
PHI field tagging, access logging, HIPAA audit reports.
Start →
46
SOX Compliance
Dual-admin controls, SOX-tier agents, audit reports.
Start →
47
Codios Authorization
Contract-based write authorization for multi-agent systems.
Start →

SDKs

0/2 done
48
Python SDK
Full walkthrough: write, query, stream, batch — no curl.
Start →
49
TypeScript SDK
Typed payloads, async/await, React hooks for live data.
Start →

Production

0/1 done
50
Production Deployment & Mesh Replication
Production config, secrets management, HA replication, full checklist.
Start →

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 →