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