Apollo State Management isn’t a cache. But you can use DBs well stabilized in applications like SQLite.
You wanna provide the whole DB? That sounds insecure. Give end-user access to the whole DB. He just needs the basics. A DB commonly used in smartphones is enough. But it requires a business logic to be built.
BTW, I’m pretty sure that others have been in your situation before. You may find better solutions out there. With the experience of others.
Well, for me this design looks like two sources of truth. You are basically having two clusters. One with the real source of truth and the other just a copy. I don’t see the difference. You have to create a way to sync the data between the two.
They are not two APIs. They are two ways of managing the same data. Nobody provides an MYSQL server on Android and sync it with the cloud one. There are different approaches to dealing with this.
Just prioritization.
No, cuz who “translates” the binary code is the Go compiler.
Yes.
Everything will be resolved, but with low priority.