Exploring Electric Sync and PG Lite

The guest of this episode is James Arthur, founder and CEO of Electric SQL, a Postgres-centric sync engine for local-first apps. This conversation will dive deep into how Electric works and explore its design decisions such as read-path syncing and using HTTP as the network layer to improve scalability. Towards the end we are also covering PGLite, a new Postgres in WASM project by Electric. 

Mentioned in podcast

• James Arthur: x.com/thruflo / bsky.app/profile/thruflo
• ElectricSQL
• ElectricSQL - Quickstart
• ElectricSQL - Github
• Discord - ElectricSQL
• PGlite
• PGlite - Github
• database.build
• trigger.dev

Links:

•  Website: localfirst.fm
• X/Twitter: x.com/localfirstfm
• YouTube: youtube.com/@localfirstfm

Thank you to PowerSync and Rocicorp for supporting the podcast.