I'm curious how people build local-first apps. I don't need full CRDT support, but more just syncing with a "parent" db (both pulling new data and pushing locally created records).
I see tinybase which feels maybe a bit more powerful than what I need (?).
I also see livestore which feels scary to build on something that new.
Is there a non-hack way to use sqllite and sync to a postgres db?
Basically my criteria in order of importance would be:
1. stays out of my way (easy to deploy, migrate, use)
2. has leverage with types (a standard linter tells me I'm blowing up the app with the code I just wrote)
3. stable (I would ideally just learn a "goto" tool and use that on all projects going forward)
I've used WatermelonDB for this exact setup works well with SQLite and syncs to a backend like Postgres.
This is exactly why local-first is hard. No perfect solution yet, but SQLite + periodic API sync has worked for me.