Goal: Achieve instant UI responsiveness and eliminate complex frontend cache management (TanStack/RTK Query) by using a sync engine (PowerSync + SQLite), without the complexity and risks associated with full offline-mode capabilities.
The application leverages a local-first architecture for extreme performance but retains a server-first logic for conflict resolution. Instead of supporting long-term offline work (e.g., working on an airplane), the app expects an active internet connection, shrinking the conflict window to the exact same size as a standard REST API.
.png)