59-Lesson Curriculum

Learn SapixDB

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

Your progress0 / 59 lessons

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

Foundations

0/6 done

The Mental Model

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

First Boot

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

Record Anatomy

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

Organisms and Agents

Create multiple agents in one organism, understand namespacing.

Writing Records in Depth

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

Reading Records in Depth

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

Working with Records

0/4 done

Soft Delete & Tombstones

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

Batch Writes

Write many records in one call. GroupCommitter and throughput.

Per-Record TTL

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

Schema Validation

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

Querying with SaQL

0/7 done

SaQL Basics

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

All 15 WhereOp Operators

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

Compound Filters

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

Sort Order & Pagination

asc/desc, cursor pagination with after_hlc.

Aggregate Functions

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

Group By

Count or aggregate per group value.

Distinct Queries

Find unique field values without loading all records.

Indexes & Performance

0/4 done

Single-Field Indexes

Create an index, understand when the engine uses it.

Composite Indexes

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

Full-Text Search

Inverted index, tokenizer, the fts operator.

Query Explain

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

Time & History

0/3 done

Time Travel Deep Dive

Query exact past state using as_of. Audit snapshots.

Time Range Queries

Window queries across any period. Billing period patterns.

Chain Verification

Verify cryptographic integrity. Detect tampering.

Graph & Joins

0/3 done

Graph Edges

Create typed directional edges between agents.

Graph Traversal

Walk the graph, record-level references.

Multi-Agent Joins

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

Advanced Query

0/3 done

Field Projection

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

Natural Language Queries

Ask in plain English. Heuristic vs LLM planner.

Streaming Queries (SSE)

Live stream of records matching a filter.

Binary Storage

0/1 done

BlobStore

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

Auth & Security

0/5 done

Master Seed & Encryption

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

Root Key & API Auth

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

Scoped API Keys

Per-service keys with limited scopes, revoke independently.

Key Delegation & Rate Limits

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

Key Rotation

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

Automation

0/3 done

Cron Jobs

Schedule recurring jobs inside SapixDB — no external scheduler.

Triggers

Fire an action whenever a matching record is written.

Mutants (AI Schema Evolution)

AI-proposed schema changes. Human approval before apply.

Real-Time

0/3 done

Per-Agent SSE Stream

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

Global Broadcast Bus

All events across all agents, publications and topic subscriptions.

Durable Publications

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

Operations

0/3 done

Epigenetic Profiles

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

Snapshots & Backups

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

WAL & Checkpoints

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

Enterprise

0/3 done

HIPAA Compliance Mode

PHI field tagging, access logging, HIPAA audit reports.

SOX Compliance

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

Codios Authorization

Contract-based write authorization for multi-agent systems.

SDKs

0/2 done

Python SDK

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

TypeScript SDK

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

Production

0/2 done

Production Deployment & Mesh Replication

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

Replication Reliability

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

Go SDK

0/1 done

Go SDK

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

Add-ons

0/2 done

Mail Add-on

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

Chat Add-on

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

Administration

0/2 done

CLI (sapix)

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

Sherapd & Alabay Watchdogs

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

Auth Add-ons

0/2 done

User Auth — Register, Login & Magic Links

Add end-user authentication: password registration, login, passwordless magic-link sign-in, JWT access tokens, refresh token rotation.

OAuth, Passkeys & Custom Claims

OAuth 2.0 (Google/GitHub), WebAuthn passkeys, and embedding app_metadata/user_metadata roles into JWTs.

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 →