Meetup: Tuesday April 25, 2023 @2PM ET<p>Community Discord Link: <a href="https://discord.gg/lfwdev" rel="nofollow">https://discord.gg/lfwdev</a><p>Talk Details:<p>At <a href="https://electric-sql.com/" rel="nofollow">https://electric-sql.com/</a> we're working on a local-first software platform that syncs between Postgres in the cloud and SQLite on local devices. As part of this, we've dug into different models for controlling what data syncs on and off device, from pinned queries to whole database sync and various options in between. Through this we've explored a bunch of interesting challenges, like how to do discovery queries when you don't have the whole dataset and the integrity challenges with partial replication boundaries.<p>In this talk, I'm proposing to:<p>o Introduce the types of application patterns/architecture we've been looking into<p>o walk through the range of different sync models we've explored;<p>o discuss their implementation challenges<p>o discuss their impact on user experience and data integrity