News for hackers. Stuff that matters.
Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by simonw on Wednesday July 29, 2026 @12:37PM (#49099725)
Correction to the above: it should use

  json_type(data, '$.name') IS 'text'
Using = fails because a missing key returns null and in SQLite null = 'text' is null: https://latest.datasette.io/_memory/-/query?sql=select+null%...

A CHECK constraint only fails when the expression is false, NULL counts as passing.

There are no comments on this comment yet.