Syntax - Tasty Web Development Treats cover image

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

Syntax - Tasty Web Development Treats

Optimizing Performance with SQLite in Web Development

1min Snip

00:00

Play full episode

Summary

Transcript

Episode notes

Carefully managing rendering canvas and state in web development is crucial. Embedding SQLite in the main thread allows running multiple queries per frame without blocking the main thread, ensuring fast and synchronous operation. Heavy tasks like cover art and media transcoding are handled on worker threads. The SQLite library used performs like actual SQLite, enabling high performance in a browser environment by compiling some code to WebAssembly.

In this episode, Scott and Wes dive into the world of local-first apps with Johannes Schickling, the mastermind behind Prisma. From databases, WASM for non-JS, to authentication challenges, they explore the ins and outs of crafting apps that prioritize local functionality.

Show Notes

00:00 Welcome to Syntax!
01:10 Brought to you by Sentry.io.
01:28 What is Overtone?
03:45 Can you explain the experience you’re trying to achieve?
06:43 What makes the best music app? Is it local first?
08:03 Is it best to create a local first app from the ground up?
10:31 What are the considerations when making a local first app?
13:04 What database are you using?
Riffle.
16:12 How do you handle authentication?
19:15 Pick the tech based on the problem.
20:40 WASM for Non-JS or heavy lifting tasks.
24:39 How did you get SQLite running in the browser?
27:58 What about WA-SQLite, how does it compare to Riffle?
TLDraw Make-real.
29:24 The backstory of Effect for TypeScript.
34:04 What actually is Effect?
39:32 Consolidating tools.
42:30 What’s a cool aspect of Effect that is often overlooked?
45:47 Building a web server with this.
EffectTS RPC.
48:16 Will this ever get “Bluebirded”?
50:29 What about promises?
Zio World
52:19 Sick Picks + Shameless Plugs.

Sick Picks

Johannes: Open Telemetry, Sentry Open Telemetry.

Shameless Plugs

Johannes: localfirst.fm.

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

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.

App store banner

Play 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