We are big fans of using SQLite for anything of even moderate complexity ... A compressed table has an uncompressed view and an underlying compressed table. The compression dictionary is loaded ...