For compression and encryption, commercial SQLite extensions are available - https://sqlite.org/support.html https://sqlite.org/support.html ... I also recall c

For compression and encryption, commercial SQLite extensions are available - https://sqlite.org/support.html https://sqlite.org/support.html ... I also recall coming across some free open source projects that had implemented compression and encryption for SQLite databases though I have no idea if they were production ready.