I would like to better understand which data types in SQLite take up more disk space. I've looked through official documentation but could not find anything in context of storage space.
Any guide link or a quick explanation will do.
SQLite Data Types In Context of Disk Space
datatypesdisk-spacesqlite
Related Question
- Disk I/O error in SQLite
- SQL Server – Understanding 1000 MB vs. 1024 MB
- Transaction Log Backups – Disk Space Usage Comparison
- SQLite Default Timeout Value in Connection String – Explanation
- Looping over column names in SQLite and running a command for each column name
- MS SQL – Using FileGroups to Free Up Disk Space
- SQLite Affinity – Hash Values with Certain Size
Best Answer
I searched for "SQLite storage space" and this was the second link:
https://www.sqlite.org/fileformat2.html
All the information you could possibly want there.
You cannot exactly work out how much storage space a given data set will use because it depends on how it was created (deletes tend to cause fragmentation for example, which means more space than would be optimal). It does explain the row format though.
SQLite is not strongly typed though. So getting a row size is out of the question. Also most databases created in the last 30 years don't use a packed row format.