2min snip

Syntax - Tasty Web Development Treats cover image

767: Local First and TypeScript’s Missing Library with Johannes Schickling

Syntax - Tasty Web Development Treats

NOTE

Complexities of Running SQLite in the Browser

Running SQLite in the browser involves multiple components such as getting SQLite to run in the browser, running it in memory for speed or persisting it to a storage layer. There have been developments like SQL.js and compiling SQLite to WebAssembly for browser execution. Persistence can occur in various ways like in an Electron app or in mobile apps. In-memory SQLite runs fast but isn't persistent, while persisting it in the browser has limited options like IndexedDB or the new option, opfs origin.

00:00

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode