Local-first apps promise instant loading and privacy but remain uncommon due to synchronization challenges. Building offline-capable applications creates distributed systems where multiple devices modify data independently, requiring solutions for unreliable event ordering and data conflicts. Hybrid Logical Clocks (HLCs) solve ordering issues by combining physical and logical timestamps, while Conflict-Free Replicated Data Types (CRDTs) handle conflicts through strategies like Last-Write-Wins. SQLite serves as an ideal foundation for local-first architectures, enabling reliable offline functionality through message-based synchronization that guarantees eventual consistency across devices.