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 ">00:00 Welcome to Syntax!
• 00:30 ">00:30 Brought to you by Sentry.io.
• 01:43 ">01:43 Why store data locally.
  • 01:55 ">01:55 User preferences and settings.
  • 02:50 ">02:50 Not logged in state (shopping carts, etc).
  • 03:30 ">03:30 Data for faster loading.
  • 03:51 ">03:51 Privacy concerns.
  • 04:25 ">04:25 Large files or drafts.
  • 05:50 ">05:50 Auth tokens.
• 07:08 ">07:08 Where to store data.
  • 07:11 ">07:11 Cookies.
  • 07:48 ">07:48 Local storage.
  • 09:15 ">09:15 Session storage.
  • 10:35 ">10:35 IndexedDB.
• 12:15 ">12:15 BYOJS Storage.
• 13:41 ">13:41 SQlite via WASM.
• 14:12 ">14:12 Penalties of SQLite in browser via WASM.
• 15:29 ">15:29 PGLite.
• 16:23 ">16:23 Dealing with migrations.
• 16:55 ">16:55 The advantages of the approach.
• 18:42 ">18:42 Dexie.
• 19:59 ">19:59 Patch messages.
• 21:25 ">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