You're looking for "--persist-to" I believe
You're looking for "--persist-to" I believe
timestamp / datetime fields work in UTC?





EXPLAIN QUERY PLAN <query> will show you what your queries are doing. Functions like random() and similar will cause writes.

timestampdatetimeinsert into table (expires_at) values (datetime('now', '+1 hour'));EXPLAIN QUERY PLAN <query>random()sqlite3_limit(db, SQLITE_LIMIT_COMPOUND_SELECT, 5);