TKYT #60 Build a Linear clone that works offline with React & ElectricSQL
In this TKYT session #60 I interviewed Kevin from Electric SQL about the concept of local first and its application in web development.
We discussed the importance of data ownership, collaboration, and real-time functionality in modern applications.
Kevin explains how Electric SQL works by syncing data between clients and the cloud, allowing for instant reactivity, real-time multi-user collaboration, and conflict-free offline functionality.
We also explore the benefits of using CRDTs (Conflict-Free Replicated Data Types) and how Electric SQL leverages technologies like IndexedDB and WebAssembly SQLite to achieve these features.
LINKS 🔗
Kevin on X
/ kevindp55
ElectricSQL Website
https://electric-sql.com/
ElectricSQL on X
/ electricsql
Offline Linear clone
https://linear-lite.electric-sql.com/
Chapters
00:00 Introduction to Local First and Electric SQL
08:18 Understanding the Concept of Local First
15:36 Enabling Instant Reactivity and Real-Time Collaboration with Electric SQL
34:04 Syncing Data When Coming Back Online
40:31 Local-First AI Applications
50:43 Setting up the Infrastructure
58:22 The Real-Time Sync Mechanism
01:07:52 Deploying Electric
STAY IN TOUCH 👋
Follow me on Twitter 🐦 - / dominus_kelvin
Subscribe to my newsletter 📧 - https://newsletter.dominuskelvin.dev
QUESTIONS...?
Join the Discord Server 💬 - https://sailscasts.com/community
Learn Web Development 📖 - https://sailscasts.com/courses
The Boring JavaScript Stack 🥱 - https://sailscasts.com/boring
Ship less JavaScript™️ consultation - https://shiplessjavascript.com
CHAPTERS
00:00 Introduction to Local First and Electric SQL
08:18 Understanding the Concept of Local First
15:36 Enabling Instant Reactivity and Real-Time Collaboration with Electric SQL
34:04 Syncing Data When Coming Back Online
40:31 Local-First AI Applications
50:43 Setting up the Infrastructure
58:22 The Real-Time Sync Mechanism
01:07:52 Deploying Electric
#javascript #webdevelopment #coding #programming #vim #vscode #softwareengineering #codinglife #webdesign #webdevelopment #webdev #javascript #programmerhumor #codinghumor #software #softwareengineer #softwaredeveloper #softwaredevelopment