Get the latest tech news
Lessons learned from building a sync-engine and reactivity system with SQLite
Welcome to my personal blog! I use it to share what I'm currently learning or thinking about, usually on topics related to technology, business, and health.
Over the last couple of months, I've been trying to build the dream: A local-first, end-to-end encrypted and reactive app, with all of the user's data in a local SQL database but continually synced to a remote server. I started getting memory leaks and huge slowdowns with live queries and ended up losing faith that this approach would work in the long term.So does this mean you should stay away from Electric? Therefore, I could set up a very minimal solution where (to simplify): The user's data is fetched initially from the server: We iterate over all the content using the updated_at attribute until we are all caught up.
Or read this on Hacker News