Hello devs
I have a compressed database with
sqlite_zstd which i would like to use in an android app with room database.
knowing the shipped version of sqlite in android doesn't support extensions,
requery/sqlite_android was used to load the extension for sqlite_zstd.
the challenge
the database tables do not remain the same after compression and the column types do not match when i use it as a pre-packaged database for room
hence the error
Pre-packaged database has an invalid schema:
I have the full question over on stackoverflow at
https://stackoverflow.com/questions/77493447/using-compressed-prepopulated-database-with-room