sqlite-utils
sqlite-utils copied to clipboard
In 4.0 change default floating point column type to REAL
This is a bug in 3.x but it only causes problems with strict tables. In 4.0 we should switch from FLOAT to REAL in the CREATE TABLE used for all floating point columns.
Split from https://github.com/simonw/sqlite-utils/issues/644#issuecomment-2495649100