2 ms·
SQLite has check constraints - and recent versions can have STRICT tables: https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html It
by simonw 4y ago
SQLite has check constraints - and recent versions can have STRICT tables: https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html
It also has excellent JSON features - JSON maybe stored as text rather than a binary format like JSONB in PostgreSQL, but the SQLite JSON functions crunch through it at multiple GBs per second so it doesn't seem to matter.
- deleted 4y ago[deleted]
- scrollaway 4y agoDidn't know about strict tables, very cool!