Edge PG with neon is awesome. But I feel like there's still a some holes in the edge/ts/nextjs ecosystem broadly when it comes to data and offline apps. Basically
- Offline through periodic polling
Periodically pushing a list of changes and pulling a list of changes
- Offline/collaborative through subscriptions
Through a long lived connection
And I think the former is an issue maybe drizzle could have some stake in.
- Periodically push a list of changes
- Through a long lived connection
- Redux (with redux-offline and redux-persist)
react-native-offline only supports transient network outage I think and doesn't seem very active
- Apollo client (fully offline first with a lot of links)
- Relay (haven't looked into offline specifically)
- WatermelonDB (sqlite)
- Brick (sqlite)