Documentation
Documentation
Comprehensive documentation for SQLiteNow, covering everything from basic setup to advanced features.
Getting Started
If you’re new to SQLiteNow, start with our Getting Started guide to set up your first project.
Core Concepts
Schema Definition
Learn how to define your database schema using SQL files with SQLiteNow annotations.
Querying Data
Learn how to write SELECT queries and retrieve data from your database.
Managing Data
Understand how to INSERT, UPDATE, and DELETE data in your database.
Dynamic Fields
Understand how to embed nested objects, collections, or existing entities in your result models.
Initializing Data
Learn how to populate your database with initial data during creation.
Migration
Understand how to manage database schema changes over time.
Platform Guides
Learn about platform-specific behavior and configuration tips.
Quick Navigation
📋 Create Schema
Define tables, indexes, and database structure with SQL and annotations
🔍 Query Data
Write SELECT queries to retrieve data as lists, single items, or reactive flows
✏️ Manage Data
INSERT, UPDATE, and DELETE operations to modify your database
🧩 Dynamic Fields
Map JOIN results to nested objects, collections, or embedded entities
🚀 Initialize Data
Populate your database with initial data during creation
🔄 Migration
Manage database schema changes and version upgrades
🌐 Kotlin/JS Integration
Understand persistence, snapshots, and configuration for browser builds
🛰️ Kotlin/Wasm Integration
Load sql.js from Wasm, wire IndexedDB snapshots, and run browser tests
🎓 Tutorials
Follow the Mood Tracker series for an end-to-end walkthrough
📖 Recipes
Explore patterns for serialization, reactive flows, and schema inspection