News for hackers. Stuff that matters.

A comment on SQLite Release 3.37.0. Parent comment

Re:SQLite Release 3.37.0 by dkjaudyeqooe on Monday November 29, 2021 @05:02AM (#29378066)
That's how I've always used SQLite, with no column type information, then I use the API to populate the column with type information as well as the value, thus implying the Any type. This is now explicit in strict tables.

As an embedded SQL engine I think this is the most rational way to use it, making it very predictable and very flexible.

[ Parent | on HN ]
Re:SQLite Release 3.37.0 by brigandish on Wednesday December 01, 2021 @02:19AM (#29401521)
Today I decided to take a leaf out of your book and use this feature, it does seem appropriate in this case.

As they say, if you can't beat 'em, join 'em!

[ Parent | on HN ]