Scott and Wes dive into the world of local data storage, breaking down the pros and cons of Sqlite, LocalStorage, SessionStorage, Cookies, and IndexedDB. They cover real-world use cases like user settings, offline data, and auth tokens, while sharing their favorite tools and strategies for keeping your data fast and secure.
Show Notes 00:00 Welcome to Syntax!
00:30 Brought to you by Sentry.io.
01:43 Why store data locally. 01:55 User preferences and settings.
02:50 Not logged in state (shopping carts, etc).
03:30 Data for faster loading.
03:51 Privacy concerns.
04:25 Large files or drafts.
05:50 Auth tokens.
07:08 Where to store data. 07:11 Cookies.
07:48 Local storage.
09:15 Session storage.
10:35 IndexedDB.
12:15 BYOJS Storage.
13:41 SQlite via WASM.
14:12 Penalties of SQLite in browser via WASM.
15:29 PGLite.
16:23 Dealing with migrations.
16:55 The advantages of the approach.
18:42 Dexie.
19:59 Patch messages.
21:25 A few options. TinyBase Docs.
Local First Web.
Hit us up on Socials! Syntax: X Instagram Tiktok LinkedIn Threads
Wes: X Instagram Tiktok LinkedIn Threads
Scott: X Instagram Tiktok LinkedIn Threads
Randy: X Instagram YouTube Threads