sqlite.org/releaselog/3_3
> STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing.
github.com/GrapheneOS/Att
Finally. It was possible to use CHECK constraints for data storage type checks but it was verbose and a bit slow.
Conversation
SQLite's feature set and performance have gotten so much better in the past few years.
WAL2 and BEGIN CONCURRENT will zap almost any reason I'd consider something else:
* sqlite.org/cgi/src/doc/wa
* sqlite.org/src/doc/begin-
Already so much faster than db servers in most cases...
3
1
13
Replying to
They're documentation for upcoming features so it will likely improve a lot before they're released.