Johannes Schickling, known for founding Prisma, has explored moving beyond the conventional three-tier web stack. His current focus is on a local-first development approach, which he implemented in his music curation application, Overtone. This shift involves leveraging client-side event sourcing and SQLite.
Local-First development aims to move the data bottleneck from the server to the client, enabling high-performance and responsive user experiences. This approach prioritizes offline support and user data ownership, contrasting with server-centric models. Schickling's work with Overtone exemplifies this architectural change.
The discussion covered the trade-offs between event sourcing and Conflict-free Replicated Data Types (CRDTs) in local-first contexts. Event sourcing provides a robust history of changes, while CRDTs are designed for collaborative conflict resolution. The choice between these depends on specific application requirements and the need for historical data versus real-time collaboration.
Adopting a local-first architecture requires significant upfront planning, particularly in breaking down monolithic data structures into smaller, manageable units. Not every application is suitable for this paradigm; developers must assess if the benefits, such as offline capability and data ownership, justify the increased architectural complexity. Modern frameworks like LiveStore offer solutions for data portability and security within local-first systems.
✨ This summary was generated by AI from the outlets' reporting listed below. It is not independently verified and may contain errors — check the original sources. How BrevFeed works →
One email each morning: the day's tech stories, clustered across outlets and summarized. No account needed.
One email a day. Unsubscribe in one click, any time.
Spend a few minutes, get the whole day. Every topic's top stories in one hands-free rundown — listen, watch, or read the transcript.
▶ Play today's briefNew every morning, and the back catalogue is archived by date.
Johannes Schickling, founder of Prisma, discussed his shift from traditional three-tier web stacks to a local-first approach using client-side event sourcing and SQLite for his music curation app, Overtone. This transition highlights the architectural considerations and trade-offs involved in moving data bottlenecks from servers to clients for improved performance and responsiveness.