A deep dive into building resilient offline-first apps. Based on six months in production, we analyze sync strategies, ULID implementation, and conflict resolution using SQLite and PostgreSQL.