Tutorials

Hands-on guides that walk through complete SQLiteNow workflows. The Mood Tracker series is a four-part Kotlin Multiplatform project that demonstrates SQL-first development from the very first schema file through a reactive Compose UI.

Browse the full sample project on GitHub.

Mood Tracker Series

  1. Part 0 – Series Overview
    • Why SQLiteNow is SQL-first, what the generator/runtime provide, and how the tutorial project is structured.
  2. Part 1 – Bootstrapping SQLiteNow in MoodTracker
    • Wire the Gradle plugin, configure dependencies, scaffold SQL directories, and generate the first Kotlin sources.
  3. Part 2 – Tags, Filters, and Richer Types
    • Extend the schema with tag tables, add column-level annotations for UUID/date types, and create repositories that operate on generated adapters.
  4. Part 3 – Reactive Mood Dashboard
    • Turn query results into StateFlow, surface them in Compose, and ship a cross-platform mood dashboard that reacts to database updates.

Looking for more? Check the Documentation hub for focused reference guides or the Recipes collection for targeted how-tos.