4 ms·
"Relational databases define schemas with fixed length fields" What is a varchar or a blob? Even a .csv allows for a variable length field (by default). I th
by gerdesj 2y ago
"Relational databases define schemas with fixed length fields"
What is a varchar or a blob? Even a .csv allows for a variable length field (by default). I think you missed out the word: "can".
Fixed field width is an optimisation strategy not a requirement.
- TZubiri 2y agoNot strong on db internals, but those are 100% the exception, late additions, and not recommended for performance. The table is stored as a fixed length structure and var length fields are pointers to some other place. In the same manner that a traditional table might point to some other book for more details. Csv is also exclusively variable length, and it's nevet fixed length. Another example of fixed length structures are arrays. I'm not postulating a novel breakthrough.
- panstromek 2y agoSqlite stores everything as variable length I believe. They have their own varint type for storing integers.