5 ms·
Not the author of the article, but I think you are overthinking the issue. New database ⇒ use the proposed new magic PRAGMA, start with sane defaults. Existin
by Rygian 3mo ago
Not the author of the article, but I think you are overthinking the issue.
New database ⇒ use the proposed new magic PRAGMA, start with sane defaults.
Existing database ⇒ don't touch anything, keep legacy "suboptimal" defaults.
- ncruces 3mo agoThe forum post I linked to has a 3 line example: CREATE TABLE t1(a DATE, b JSON); PRAGMA strict=ON; INSERT INTO t1 VALUES(a,b) VALUES(?1,?2); You (or the author) can replace the non-existent `PRAGMA strict` with whatever editions thingy you're proposing. Just, you know, explain what should happens when you do this, because the creator of SQLite doesn't know. When doing so consider the file format, how schema is stored, and what happens when other versions of SQLite touch your file. Should be simple, given that I'm overthinking it. Thanks.
- Rygian 3mo agoI would go with something like "Syntax error: pragma strict must appear before any table creation. " and consider that db file unusable.