Johannes Schickling, Prisma's original founder, discusses his new project LiveStore, a local-first data layer built around SQLite and event sourcing. LiveStore aims to solve distributed state management by keeping data local on devices and syncing events rather than state changes. The architecture uses immutable events as the source of truth, which are materialized into SQLite databases through pure functions, enabling features like time travel debugging, simplified schema migrations, and offline-first applications. The system supports cross-device syncing through simple push/pull mechanisms similar to Git, making it suitable for tenant-based applications where data boundaries are clear.
•1h 12m watch time
Sort: