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
There are currently edge cases for highly concurrent database usage where the WAL file can grow indefinitely if you rely on the concurrent automatic checkpoints not blocking other usage. WAL2 fixes it and will hopefully be merged and released as stable in the next year or so.