On Tue, Jul 23, 2024 at 10:35 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > Just know that SQLite does not enforce types [...]
That's true, and applies to the OP's schema. But for the record, SQLite *can* enforce types these days, on an opt-in basis, with [STRICT tables][1]. Albeit with a limited type-system. --DD PS: and could be done manually even before, with CHECK (typeof(col)='blob') for example. [1]: https://www.sqlite.org/stricttables.html
