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 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: genserver.social/codesync

[@timothyshiu2263]

Love to see how electricSQL implemented one app with react.

[@kp8752]

MeteorJS is so back

[@BenjaminScherrey]

Where can one find the "New Directions in Cloud Computing" paper? Doesn't pop up in my search results.

[@StingSting844]

I still don't get how we'll handle larger data? Will it sync all the db data or will there be a limit that is configurable

[@ewe-studios]

It means thoughtful consideration goes into deciding which table is synced, potentially filtering only data related to that user. It has trade offs so you will need to consider your use case.

[@ewe-studios]

See the sync control portion

[@interests3279]

SQL high throuput on elixir, sheeit nnnngguh!