Offline-first Apps
Course Index
28 Lessons · 3 Sections
Master offline-first mobile development — local-first architecture, conflict resolution, WatermelonDB, Room, SQLite, Realm & sync engines. Covers background sync, optimistic UI & network-aware patterns. Includes 4 production builds: offline notes, sync engine, conflict resolution demo & full local-first app.
28Lessons
3Sections
4Projects
FreeAccess
Section 1Local-First Fundamentals & DatabasesLessons 1–10
Lesson 1
What is Offline-First Architecture?
Lesson 2
Offline-First vs Cache-Then-Network
Lesson 3
Local Database Options: SQLite & Alternatives
Lesson 4
SQLite + Drizzle ORM Setup
Lesson 5
WatermelonDB: Reactive Offline Database
Lesson 6
Room (Android) for Offline Persistence
Lesson 7
Core Data / SwiftData for Offline Persistence
Lesson 8
Optimistic UI Updates
Lesson 9
Mutation Queues & Sync Triggers
Lesson 10
Network Detection & Connectivity Handling
Section 2Sync Engines, Conflict Resolution & CRDTsLessons 11–22
Lesson 11
Delta Sync & Incremental Updates
Lesson 12
Conflict Resolution: Last-Write-Wins
Lesson 13
Conflict Resolution: Field-Level Merge
Lesson 14
CRDTs: Conflict-Free Replicated Data Types
Lesson 15
Yjs & Automerge for Collaborative Sync
Lesson 16
PowerSync: Managed Sync Engine
Lesson 17
Turso Offline Sync
Lesson 18
TinyBase: Reactive Local-First Store
Lesson 19
Firestore & Realtime Database Offline Persistence
Lesson 20
Background Sync: WorkManager & BGTaskScheduler
Lesson 21
Idempotency & Retry Logic
Lesson 22
Performance: Lazy Loading & Pagination Offline
Section 3Field Operations, 2026 Stack & ProjectsLessons 23–28