Can I add custom metadata to an SQLite column? Or do I need to save it in a separate column or table?
I am working on a database where I would like to store the units of a column in one form or another, i.e. temperature column in Kelvin units. Is it possible to save this as a row or some form of custom metadata attached to a column?
I believe not. You can add another column. You can also encode metadata into a value in some way (["fruit: apple", "fruit: pear", "mineral: bauxite", ...]), but this makes big data more difficult and less efficient to process.
, , , .