2 ms·
As I interpret the record format (https://www.sqlite.org/fileformat.html#record_format https://www.sqlite.org/fileformat.html#record_format) then new native dat
by silvestrov 2y ago
As I interpret the record format (https://www.sqlite.org/fileformat.html#record_format https://www.sqlite.org/fileformat.html#record_format) then new native datatypes (datetime, jsonb) cannot be added without breaking the file format.
When file format is no longer backwards compatible, it makes sense to make a new major (semantic) version, so you don't have a situation where version 3.50 can read a file but version 3.43 cannot.