<https://sqlite.org/fileformat.html> You can do a "very rough" calculation as follows: one byte for the count of fields one byte for each field to indicate the type additional bytes for text/blob fields for the max length (that is, if it is a text field of length 3000 then that will take 3 byes, lets say) and then for each field + 8 bytes for a integer or float + N bytes for each text/blob field (max) four bytes for the length of all the above this is the "record size" (more or less) Compute the number of "records" that will fit on a page Divide the number of records by the number records per page This will give you the "fully packed" size (min data size) The size of the table will be somewhere between the above size and the size yielded if each record occupies one page (assuming that the record size is less than the page size). If you keep updating the table, eventually it will reach a "stable size" that is somewhere between the two aforestated extremes.