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