Developer Tools

STRICT Tables

Last updated 2026-07-12 · benchmark measured 2026-08-11 — deterministic & reproducible

SQLite feature enabling per-table strict type enforcement, available since version 3.37.0.

Is STRICT Tables production-ready?

Legit.Show scores STRICT Tables 58 out of 100 — the simple average of its 7 measured frames. Legit.Show ran its deterministic 7-Frame production-readiness benchmark on STRICT Tables (public-surface assessment), measured from the public surface with no LLM in the scoring path. Its strongest frame is Reliability; its weakest is Discoverability. Every frame it averages is published with its evidence on the Legit.Show listing.

The 7 Frames

• Performance — 98/100
• Accessibility — 58/100
• Security — 25/100
• Privacy — 25/100
• Reliability — 100/100
• Standards — 82/100
• Discoverability — 15/100

What we measured

• No Content-Security-Policy and no HSTS.
• Served over HTTPS with a valid certificate.
• Real Lighthouse performance run — 494 ms to first byte.
• Returns a proper 404 for unknown routes.
• 2 of 2 sampled routes reachable.
• No privacy policy found.
• Sets cookies / loads scripts with no consent prompt.

Who it's for

Database developers · SQL purists · Applications requiring strict type safety

Visit STRICT Tables → · Alternatives to STRICT Tables → · How this was measured →