Do the databases you propone work offline too?
If they don't they're not a good match at all.
If they don't they're not a good match at all.
0. https://tanstack.com/query/latest/docs/framework/react/quick...
Having a complete query engine on the client makes this a lot easier to deal with. It's why most popular messaging apps will use SQLite on the client to render the UI and build their own sync engine to keep it up to date with the backend.