Show HN: Reduce SQLite database size by up to 80% with transparent compression
SQLite allows you to override the low-level paging routines, wonder if it won't work by just having a different pager (though maybe not that efficient compression, unless the pages are big (64kb)).