https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html
https://news.ycombinator.com/item?id=17383364
Postgres has a relatively high minimum per-row cost of about 40 bytes 2, and representing a small number like 280 as a number rather than a string is actually more storage intensive (in exchange, query-time arithmetic will be faster).
This is because enumerated types are much cheaper to compare than strings.
the SQLite database is very compressible, since it still has all the repetitive data. Since this is for a read-only webapp, let's try using SquashFS to transparently compress it.
Talks about project-apache-arrow