SQLite is a row-oriented store, not a column-oriented store, ie, there are fundamental tradeoffs between the two.

But sqlite has no compression by default.