James Arthur - ElectricSQL, A local first sync engine

This week we talk to James Arthur, co-founder ElectricSQL, a local first sync engine for Postgres. ElectricSQL wants to make it easy to build local first apps with Postgres. Instead of worring about how to sync data between devices, ElectricSQL lets you reason about your database as local and running on your device.

https://electric-sql.com/
https://x.com/thruflo
  / thruflo  

Episode sponsored By Clerk (https://clerk.com)

Become a paid subscriber our patreon, spotify, or apple podcasts for the full episode.

  / devtoolsfm  
https://podcasters.spotify.com/pod/sh...
https://podcasts.apple.com/us/podcast...
   / @devtoolsfm  

00:00:21 Introduction
00:02:12 Local First Conf and Little Elephants Everywhere
00:05:06 Understanding ElectricSQL
00:10:17 Ad
00:12:03 Technical Deep Dive: Partial Replication and Sync Engine
00:16:09 Cost Savings and Operational Benefits
00:18:51 Implementing ElectricSQL in Production
00:31:44 CRDTs and Rich CRDTs Explained
00:39:21 PG Lite: Postgres in the Client
00:47:48 Future of ElectricSQL and Monetization
00:58:01 Conclusion and Final Thoughts