Save SQLite cache database to platform's cache directory

[cvb941]

Right now, as far as I understand, the SqlNormalizedCacheFactory creates the cache file in the default database locations as decided by SQLDelight.

On Android this means that the .sqlite file is saved in the more permanent databases directory. I think it would be better to save it in the cache directory by default. That way, Clear Cache will delete the Apollo cache too.

This stands for other platforms too, the database could be saved in the respective platform's cache directories. Like these here: https://github.com/psuzn/multiplatform-paths

[BoD]

That's a good point! I agree the default should probably be the cache directory.

In the meantime you should already be able to do this manually by constructing a AndroidSqliteDriver with the desired path, and pass that to the constructor of SqlNormalizedCacheFactory.

[cvb941]

Yes I'm aware. It is not a major issue now so I'll just wait for whenever the change will be made in the library :)

[BoD]

Done in #242