Local-First State Management at Local-First Meetup #13
Local-First State Management at Local-First Meetup #13
Using SQLite local-first state management:
State is automatically persisted across page reloads
The database handles change detection for us
We can use plain SQL queries and views to filter and transform the state
We can use fast local queries to load any data from any component
Local-First WebDev: https://localfirstweb.dev/
PowerSync: https://www.powersync.com
Chapters:
00:00 Intro
00:48 PowerSync background
03:22 Local-first state management using a SQLite database
05:21 The lightbulb moment
06:54 The PowerSync 'useQuery'
08:50 Typed Queries Using Kysely
09:16 Where to use queries for state
10:14 Loading states and waterfalls
12:09 Synchronizing with server-side state
12:39 Synchronizing with server-side state using PowerSync
16:08 Conclusion