3 ms·
A comment will do more than a nonsensical type which is not enforced: it won’t have the wrong affinity, it will spell out what the concrete type is, and there’s
by masklinn 3mo ago
A comment will do more than a nonsensical type which is not enforced: it won’t have the wrong affinity, it will spell out what the concrete type is, and there’s no limit to what it can specify.
Domain types would be the best fix, but I do not think legacy tables are the second best.
- ncruces 3mo agoA comment is not something I can get programmatically through `sqlite3_column_decltype` or `sqlite3_table_column_metadata`. I can use either API to trigger bool and time handling in my Go driver. https://github.com/ncruces/go-sqlite3/blob/main/driver/driver.go https://github.com/ncruces/go-sqlite3/blob/main/driver/drive...