#18 – James Arthur: ElectricSQL, Read-path Syncing, PGLite Localfirst.fm podcast

1:29:46

The guest of this episode is Seph Gentle, a prolific software researcher who is behind projects such as the new eg-walker paper and ShareJS, one of the oldest local-first open source projects. Before, Seph also co-created Google Wave over 10 years ago which will be explored in-depth in this episode. Mentioned in podcast: Seph Gentle: Website + X CRDTs are the future Collaborative Text Editing with Eg-Walker Hammock Driven Development - Rich Hickey Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to ElectricSQL for supporting the podcast.…

1
#20 – Adam Wulf: Muse 1:33:18

5 weeks fa1:33:18

1:33:18

The guest of this episode is Adam Wulf, the engineer and solopreneur behind Muse, a local-first canvas-based tool for thought. This conversation will get trough the evolution of Muse as a product, company and people who made it, reflecting on the joys and struggles of building software as a team of one. Later, the conversation will dive deep into topics such as analytics and distribution of a local-first app. Mentioned in podcast: Adam Wulf: Website + Bluesky + Mastodon + GitHub Muse + Bluesky + X Muse Discord community Download Muse Setapp Muse Setapp launch Rebuilt iPhone app Adam Wiggins' Retrospective Muse Sync at Programming Local First Workshop – ECOOP’22 Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to Convex and ElectricSQL for supporting the podcast.…

1
#19 – Brooklyn Zelenka: UCAN, Beehive, Beelay 1:11:10

8 weeks fa1:11:10

1:11:10

The guest of this episode is Brooklyn Zelenka, a local-first researcher and creator of various projects including UCAN and Beehive. This conversation, will go deep on authorization and access control in a decentralized, local-first environment and explore this topic by learning about UCAN and Beehive. Later, the conversation will also diving into Beelay, a new generic sync server implementation developed by Ink & Switch. Mentioned in podcast: Brooklyn Zelenka: Website + GitHub + Bluesky + Mastodon Messaging Layer Security (MLS) Messaging layer security: Encrypting a group chat TreeKEM Group Messaging for Secure Asynchronous Collaboration by Matthew A. Weidner Beehive lab notebook UCAN Working Group UCAN - Be in control of your auth: Brooklyn Zelenka (Local-First Conf) Automerge WNFS Working Group Robust Composition: Towards a Unified Approach to Access Control and Concurrency Control by Mark Samuel Miller SPKI Certificate Theory Edwards-Curve Digital Signature Algorithm (EdDSA) Comparison of Symmetric Encryption Methods Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to Convex and ElectricSQL for supporting the podcast.…

1
Special episode: Apps vs Files with Gordon Brander, Peter van Hardenberg & Jess Martin. 1:09:10

10 weeks fa1:09:10

1:09:10

This is a special episode which was recorded as a Twitter space conversation between Gordon Brander, Peter Van Hardenberg, and Jess Martin. This conversation explores the ideas and trade offs of apps versus files. Mentioned in podcast Gordon Brander Peter van Hardenberg Jess Martin Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm…

1
#18 – James Arthur: ElectricSQL, read-path syncing, PGLite 1:06:33

14 weeks fa1:06:33

1:06:33

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.…

1
#17 – Kyle Simpson: Local-first identity 1:32:10

17 weeks fa1:32:10

1:32:10

The guest of this episode is Kyle Simpson, a prolific JavaScript engineer and author of the book You Don’t Know JS. Over the past years, Kyle has been researching user identity and encryption in a local-first context which we explore in depth in this episode. This conversation will dive into the story that led Kyle to local-first including what he calls Web 2.5 and Zero Servers. Editor's Note: when Kyle speaks about SilentJS, is actually referring to QuiteJS (link below) Mentioned in podcast Kyle Simpson: x.com/getifyX / me.getify.com Local-peer-to-peer Webauthn-local-client Local-data-lock Local-vault Storage Qr-data-sync Vella.ai Socket Supply You-Dont-Know-JS LoFi.so QuietJS Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to PowerSync and Rocicorp for supporting the podcast.…

1
#16 – Anselm Eickhoff: Jazz 1:13:33

20 weeks fa1:13:33

1:13:33

The guest of this episode is Anselm Eickhoff, creator of Jazz and founder of Garden Computing. This conversation will dive deep into Jazz to learn how it works and which use cases it’s a good fit for by exploring various apps already built on top of Jazz. Mentioned in podcast Anselm Eickhoff: x.com/anselm_io / anselm.io jazz.tools Garden Computing Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to PowerSync and Rocicorp for supporting the podcast.…

1
#15 – Tuomas Artman: Linear, sync engines, rethought startup MVP 1:01:18

23 weeks fa1:01:18

1:01:18

The guest of this episode is Tuomas Artman, co-founder and CTO of Linear. Prior to Linear, Tuomas had already built sync engines for over a decade at companies like Groupon and Uber. This conversation will explore how local-first and software quality was crucial for Linear’s success and how the concept of a startup MVP should be rethought. Mentioned in podcast Tuomas Artman: x.com/artman / github.com/artman Linear Scaling the Linear Sync Engine Rethinking the startup Mvp: Building a competitive product Unexpected benefits of going local-first - Tuomas Artman (Local-First Conf) Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to PowerSync and Rocicorp for supporting the podcast.…

1
#14 – Matthew Weidner: Architectures for Central Server Collaboration 57:26

27 weeks fa57:26

57:26

The guest of this episode is Matthew Weidner, a computer science PhD student at Carnegie Mellon University focussing on distributed systems and local-first software. Matthew has recently published an extensive blog post about architectures for central server collaboration which is explored in depth in this conversation comparing different approaches such as CRDTs and event sourcing. Mentioned in podcast Matthew Weidner: x.com/MatthewWeidner3 / mattweidner.com Architectures for Central Server Collaboration TRVE Data project Shapiro 2011 paper Carlos Baquero papers CRDT paper (the "very theoretical" one) Collabs: Docs / Paper Jupiter collaboration system from the 90s Building on Quicksand Immutability Changes Everything Ink & Switch's Upwelling list-positions Fractional indexing Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to Expo and Rocicorp for supporting the podcast.…

1
#13 – Maggie Appleton: Barefoot Developers, AI, end-user programming 1:05:07

30 weeks fa1:05:07

1:05:07

The guest of this episode is Maggie Appleton, a designer, anthropologist and developer who has recently explored the world of local-first by giving the closing keynote at the last local-first conf. This conversation will dive into the topics of her talk including home cooked software, the idea behind barefoot developers and how AI complements local-first software development. Mentioned in podcast Maggie Appleton: x.com/Mappletons + maggieappleton.com Home-cooked Software and Barefoot Programmers: Maggie Appleton (Local-First Conf) Home-Cooked Software and Barefoot Developers Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Thank you to Expo and Rocicorp for supporting the podcast.…

1
#12 – James Pearce: Tinybase 1:12:22

33 weeks fa1:12:22

1:12:22

The guest of this episode is James Pearce, the author of Tinybase, a reactive data store library for local-first apps. This conversation will explore how Tinybase works including its custom query system, the various persistence and syncing integrations as well as James’ plans for the future. Mentioned in podcast James Pearce: x.com/jamespearce + scoutsailing.com TinyBase TinyHub Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Local-First Conf 2024 Thank you to Expo and Rocicorp for supporting the podcast.…

1
#11 – Adam Wiggins: Local-first Conf 2024 1:02:26

36 weeks fa1:02:26

1:02:26

The guest of this episode is Adam Wiggins, who is the founder of Heroku and one of the co-authors of the local-first essay by Ink & Switch. As Adam is also a co-organizer of the first local-first conference, this conversation will reflect on the event, share our learnings and discuss a couple of key topics such as a new definition of local-first software. Mentioned in podcast Adam Wiggins: x.com/_adamwiggins_ + adamwiggins.com Browsertech Digest Trip Report: Local First Conf Alice and Bob in wonderland. Bootstrapping identity and authority in a world without servers. Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Local-First Conf 2024 Thank you to Expo and Rocicorp for supporting the podcast.…

1
#10 – Matt Wonlaw: cr-sqlite, syncing strategies and incremental view maintenance 1:03:36

39 weeks fa1:03:36

1:03:36

The guest of this episode is Matt Wonlaw, a prolific local-first tool builder who’s behind projects such as Vlcn, cr-sqlite and Materialite. Most recently Matt also joined Rocicorp to work on their new product. This conversation will go deep on his projects covering CRDTs, SQLite and incremental view maintenance. Mentioned in podcast Matt Wonlaw: x.com/tantaman + github.com/tantaman RemoteStorage ownCloud The Virtual Table Mechanism Of SQLite Towards a General Database Management System of Conflict-Free Replicated Relations Materialite benchmark Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Local-First Conf 2024 Thank you to Expo and Rocicorp for supporting the podcast.…

1
#9 – Dax Raad: Local-First SaaS 1:02:55

42 weeks fa1:02:55

1:02:55

The guest of this episode is Dax Raad, who is using local-first in multiple projects including the serverless deployment tool SST.dev, a healthcare app and an upcoming personal finance app. This conversation will explore how local-first simplifies app development, the UX and data patterns he used on and how self-hosting could empower local-first apps. Mentioned in podcast Dax Raad: x.com/thdxr + thdxr.com SST.dev Rethinking the startup MVP: Building a competitive product. Links: Website: localfirst.fm X/Twitter: x.com/localfirstfm YouTube: youtube.com/@localfirstfm Local-First Conf 2024 Thank you to Expo and CrabNebula for supporting the podcast.…

1
#8 – Pirijan Ketheswaran: Kinopio, Canvas-based tools, being a solo developer 56:42

45 weeks fa56:42