localfirst.fm

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 [https://x.com/thruflo] / bsky.app/profile/thruflo [https://bsky.app/profile/thruflo.com] * ElectricSQL [https://electric-sql.com] * ElectricSQL - Quickstart [https://electric-sql.com/docs/quickstart] * ElectricSQL - Github [https://github.com/electric-sql/electric] * Discord - ElectricSQL [https://discord.electric-sql.com] * PGlite [https://pglite.dev] * PGlite - Github [https://github.com/electric-sql/pglite] * database.build [https://database.build] * trigger.dev [https://trigger.dev] Links: *  Website: localfirst.fm [https://localfirst.fm/] * X/Twitter: x.com/localfirstfm [https://x.com/localfirstfm] * YouTube: youtube.com/@localfirstfm [https://www.youtube.com/@localfirstfm] Thank you to PowerSync [https://www.powersync.com/] and Rocicorp [https://rocicorp.dev/] for supporting the podcast.

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 [https://x.com/getifyX] / me.getify.com [https://me.getify.com] * Local-peer-to-peer [https://github.com/WICG/local-peer-to-peer] * Webauthn-local-client [https://github.com/mylofi/webauthn-local-client] * Local-data-lock [https://github.com/mylofi/local-data-lock] * Local-vault [https://github.com/mylofi/local-vault] * Storage [https://github.com/BYOJS/storage] * Qr-data-sync [https://github.com/mylofi/qr-data-sync] * Vella.ai [https://www.vella.ai] * Socket Supply [https://socketsupply.co] * You-Dont-Know-JS [https://github.com/getify/You-Dont-Know-JS] * LoFi.so [https://github.com/mylofi] * QuietJS [https://quiet.github.io/quiet-js] Links: *  Website: localfirst.fm [https://localfirst.fm/] * X/Twitter: x.com/localfirstfm [https://x.com/localfirstfm] * YouTube: youtube.com/@localfirstfm [https://www.youtube.com/@localfirstfm] Thank you to PowerSync [https://www.powersync.com/] and Rocicorp [https://rocicorp.dev/] for supporting the podcast.

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 [https://x.com/anselm_io] / anselm.io [https://aeplay.org/] * jazz.tools [https://jazz.tools/] * Garden Computing [https://gcmp.io/] Links: *  Website: localfirst.fm [https://localfirst.fm/] * X/Twitter: x.com/localfirstfm [https://x.com/localfirstfm] * YouTube: youtube.com/@localfirstfm [https://www.youtube.com/@localfirstfm] Thank you to PowerSync [https://www.powersync.com/] and Rocicorp [https://rocicorp.dev/] for supporting the podcast.

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 [https://x.com/artman] / github.com/artman [https://github.com/artman] * Linear [https://linear.app] * Scaling the Linear Sync Engine [https://www.youtube.com/watch?v=Wo2m3jaJixU&t=10s] * Rethinking the startup Mvp: Building a competitive product [https://linear.app/blog/rethinking-the-startup-mvp-building-a-competitive-product] * Unexpected benefits of going local-first - Tuomas Artman (Local-First Conf) [https://www.youtube.com/watch?v=VLgmjzERT08] Links: *  Website: localfirst.fm [https://localfirst.fm/] * X/Twitter: x.com/localfirstfm [https://x.com/localfirstfm] * YouTube: youtube.com/@localfirstfm [https://www.youtube.com/@localfirstfm] Thank you to PowerSync [https://www.powersync.com] and Rocicorp [https://rocicorp.dev/] for supporting the podcast.

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 [https://twitter.com/MatthewWeidner3] / mattweidner.com [https://mattweidner.com/] * Architectures for Central Server Collaboration [https://mattweidner.com/2024/06/04/server-architectures.html] * TRVE Data project [https://martin.kleppmann.com/2016/04/15/announcing-trve-data.html] * Shapiro 2011 paper [http://hal.inria.fr/inria-00555588/] * Carlos Baquero papers [https://cbaquero.github.io/web/] * CRDT paper (the "very theoretical" one) [https://doi.org/10.1145/3408976] * Collabs: Docs [https://collabs.readthedocs.io/en/latest/] / Paper [https://arxiv.org/abs/2212.02618] * Jupiter collaboration system from the 90s [https://dl.acm.org/doi/10.1145/215585.215706] * Building on Quicksand [https://arxiv.org/abs/0909.1788] * Immutability Changes Everything [https://queue.acm.org/detail.cfm?id=2884038] * Ink & Switch's Upwelling [https://www.inkandswitch.com/upwelling/] * list-positions [https://github.com/mweidner037/list-positions] * Fractional indexing [https://www.figma.com/blog/realtime-editing-of-ordered-sequences/] Links: *  Website: localfirst.fm [https://localfirst.fm/] * X/Twitter: x.com/localfirstfm [https://x.com/localfirstfm] * YouTube: youtube.com/@localfirstfm [https://www.youtube.com/@localfirstfm] Thank you to Expo [https://expo.dev/] and Rocicorp [https://rocicorp.dev/] for supporting the podcast.