I became obsessed with local-first software in 2020 when the popular product management tool Linear was released to the public. Interactions in Linear feel instant with no loading states, and the interface is streamlined and intuitive. Writes are written to a local database instantly then changes are synchronized in the background. The result is a tool that is super responsive and delightful to use.
In implementing the core building blocks of our software offering, we built a local first sync engine that works much like Linear’s. In both our desktop and web apps, changes are written to a complete local copy of the workspace data. That means updating a record doesn’t need to wait on a round trip to the server—the app updates immediately using the data it already has. Changes are propagated via a central server to all other subscribed workspaces instantly.
For our web apps, we build on top of the Origin Private File System which allows us to run and persist a full featured SQLite database in the users browser. OPFS gives us a private, sandboxed filesystem that’s exclusive to our origin, with synchronous, low-level file access that’s fast enough to back a real database engine rather than a simple key-value store. We run SQLite compiled to WebAssembly directly against this filesystem, so queries execute locally with none of the overhead or storage limits you’d hit with IndexedDB alone. Because the database lives inside a dedicated Web Worker, all of this heavy lifting happens off the main thread, keeping the UI smooth and responsive even while large writes or complex queries are running in the background.
The year is 2026. What used to take a team of five talented software developers three months to implement can be generated in 8 minutes with a single prompt. There is no longer an excuse for slow, buggy software that sort of gets the job done. You should accept nothing less than excellence when it comes to your businesses software stack.