*** 19,25 **** Change SQLite so that it understands a new fundamental type for dates. There are two spare typecodes left - this would use one. Dates would be stored as 64-bit floating point values - the julian ! day number. The incompatibility arises from the fact that a table column with a declared type of DATE would now undergo type coercion --- 19,28 ---- Change SQLite so that it understands a new fundamental type for dates. There are two spare typecodes left - this would use one. Dates would be stored as 64-bit floating point values - the julian ! day number. This would have the added benefit of using only 8 bytes ! per date instead of 19 bytes for the current TEXT-based date. The ! 64-bit date would provide more precision, take up less disk space ! and this would ultimately make date comparisons faster. The incompatibility arises from the fact that a table column with a declared type of DATE would now undergo type coercion
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|