ElectricSQL - Local first SQL with Elixir by James Arthur | Lambda Days 2023

✨This talk was recorded at Lambda Days 2023. If you're curious about our upcoming event, check https://lambdadays.org ✨

Local-first is a new paradigm for developing apps, where you code against an embedded database in the client and have reactive, real-time, multi-user sync in the background.

ElectricSQL is a new, open-source, platform for local-first development that works with standard Postgres and SQLite. This talk introduces the ElectricSQL system and dives into its core replication technology, developed in Elixir.

OBJECTIVES

Introduce local-first software. Introduce the ElectricSQL system.
Outline the challenges developing local-first software, including replication model, concurrency and consistency issues. Show how the ElectricSQL system addresses them and how to build apps with ElectricSQL.
Discuss the trade-offs with the development model and the role of Erlang and Elixir in the core replication layer.

Let's keep in touch! Follow us on:
💥Twitter:   / lambdadays  
💥LinkedIn:   / lambda-days  
💥Facebook:   / lambdadays  
💥Mastodon: https://genserver.social/codesync