5 ms·
Since 3.3 you can use check constraints to enforce things, but I don't know what kind of performance impact that has.
by simcop2387 10y ago
Since 3.3 you can use check constraints to enforce things, but I don't know what kind of performance impact that has.
- mvc 10y agoYou also need to enable them each time you connect.
- simcop2387 10y agoReally? dang that's terrible. I thought they'd stay that way as part of the table schema. Glad I normally use an ORM that'll take care of the type checking ahead of time.
- qwertyuiop924 10y agoApparently, they actually do stay around.
- SQLite 10y agoNo you don't. CHECK constraints always work. Maybe you are thinking about foreign key constraints, which for backwards compatibility are off by default, unless you use a compile-time option to make then on by default.
- mvc 10y agoYou also need to enable them each time you connect.