I am using the built-in sqlite library on Android platform.
I am considering adding a few general-purpose fields that users can use for their own applications, but these fields will in most cases be empty.
My question is how much overhead will these empty fields be added to my database? Are null fields even occupying write memory in sqlite? If so, how much? I do not quite understand the inner workings of the sqlite database.
source
share