Zero column space consumption in sqlite db

Question

Say I have a db column, which is rarely used rarely in the records in my sqlite db (for the rest of the records, the value is null), will these null columns consume as much space as possible if these columns do not exist

Answer 1

In my test program, NULL values ​​consumed one byte per line. If the average row size in your table is above 100 bytes, then yes, this is comparable to nonexistent.