Interestingly, it's amazing to me that many SQLite libraries in the Go ecosystem don't support these mixed/flexible data types in tables.
If you read back a set of values and one of the fields in a row doesn't match the data type given by the column, the libraries will error out.
One library that works correctly is github.com/gwenn/gosqlite, which checks the data type of each field of the result set (per row), so handles things gracefully.
If you read back a set of values and one of the fields in a row doesn't match the data type given by the column, the libraries will error out.
One library that works correctly is github.com/gwenn/gosqlite, which checks the data type of each field of the result set (per row), so handles things gracefully.