3 ms·
> SQLite doesn't do stored procedures Link: https://www.sqlite.org/gencol.html https://www.sqlite.org/gencol.html Example: CREATE TABLE t1( a INTEGER PRI
by dathinab 6y ago
> SQLite doesn't do stored procedures
Link: https://www.sqlite.org/gencol.html https://www.sqlite.org/gencol.html
Example:
CREATE TABLE t1(
a INTEGER PRIMARY KEY,
b INT,
c TEXT,
d INT GENERATED ALWAYS AS (a*abs(b)) VIRTUAL,
e TEXT GENERATED ALWAYS AS (substr(c,b,b+1)) STORED
);
Note how you can call functions in the columns. Thats one feature which a hardened sqlite for less trusted documents would need to not have.