query('PRAGMA journal_mode = WAL;'); //multiple readers, https://sqlite.org/wal.html $db->query('PRAGMA busy_timeout = 60000;');//PRAGMA busy_timeout = milliseconds before retry; will it work on PDO vs SQLITE3? $db->query('PRAGMA cell_size_check = ON;'); //database corruption is detected earlier and is less likely to "spread" $db->query("PRAGMA encoding = 'UTF-8'"); //watch php WHERE clause will not work since ISO encoding vs UTF 8, $db->exec( 'CREATE TABLE IF NOT EXISTS session (session_id INTEGER PRIMARY KEY, session_hashid TEXT, user_id INTEGER, time_created INTEGER );'); $db->exec( 'CREATE TABLE IF NOT EXISTS accounts ( user_id INTEGER PRIMARY KEY, username TEXT NOT NULL UNIQUE COLLATE NOCASE, userpassword TEXT );');$db->exec( 'CREATE TABLE IF NOT EXISTS blog ( doc_id INTEGER PRIMARY KEY, doc_title TEXT, doc_text TEXT, doc_image BLOB, doc_created_time INTEGER, user_id INTEGER );'); ?>