SQLer Interactive Tour

Learn SQLer through interactive notebooks. Run and modify code directly in your browser!

Lite Tours (Run in Browser)

These tours use SQLerLiteModel (dataclasses) and run fully in-browser via WebAssembly.

• 01. Fundamentals
  Setup, models, CRUD operations, queries, and aggregations
• 02. Relationships
  Model relationships, automatic hydration, querying across models
• 03. Safe Models
  Optimistic locking, StaleVersionError, conflict resolution
• 04. Transactions
  Atomic operations, rollback, nested transactions
• 05. Mixins
  Timestamps, soft delete, lifecycle hooks (manual patterns)
• 06. Advanced Features
  Bulk operations, indexes, integrity policies, raw SQL
• 07. Export/Import
  CSV, JSON, JSONL data export and import
• 08. Full-Text Search
  FTS5 indexing, boolean queries, ranking, highlights
• 09. Change Tracking
  Built-in dirty checking, change detection
• 10. Database Operations
  Health checks, statistics, vacuum, pagination, logging
• 11. Metrics & Caching
  Prometheus metrics, query caching, connection pools

Full Tours (Pydantic)

Complete tours using SQLerModel (Pydantic). These require a local Python environment.

• 01. Fundamentals
  Setup, models, CRUD operations, queries, and aggregations
• 02. Relationships
  Model relationships, automatic hydration, querying across models
• 03. Safe Models
  Optimistic locking, StaleVersionError, conflict resolution
• 04. Transactions
  Atomic operations, rollback, nested transactions
• 05. Mixins
  Timestamps, soft delete, lifecycle hooks
• 06. Advanced Features
  Bulk operations, indexes, integrity policies, raw SQL
• 07. Export/Import
  CSV, JSON, JSONL data export and import
• 08. Full-Text Search
  FTS5 indexing, boolean queries, ranking, highlights
• 09. Change Tracking
  TrackedModel, dirty checking, partial updates, diff
• 10. Database Operations
  Health checks, statistics, vacuum, pagination, logging
• 11. Metrics & Caching
  Prometheus metrics, query caching, connection pools

Built with marimo • View on GitHub