how2.sqlite3

-- strict tables
CREATE TABLE foo (name TEXT, age INT) STRICT;

-- Enable Write ahead log (just run this on the db file once and it is enabled)
PRAGMA journal_mode=WAL;

-- Lower synchronous level (with WAL, you should set it to 1. Default is 2)
PRAGMA synchronous=1;