Node-sqlite3: Setting WAL mode in sqlite

Created on 2 Dec 2016 · 2Comments · Source: mapbox/node-sqlite3

Is there a way to configure WAL mode like we do for busyTimeout?

Source

vivekdaramwalwy

Most helpful comment

Yeah, it's pretty straightforward

const sqlite3 = require( 'sqlite3' );

const path = 'my/db/path.sqlite';
const database = new sqlite3.Database( path );

database.run( 'PRAGMA journal_mode = WAL;' );

kokarn on 6 Jan 2017

❤3

All 2 comments

Yeah, it's pretty straightforward

const sqlite3 = require( 'sqlite3' );

const path = 'my/db/path.sqlite';
const database = new sqlite3.Database( path );

database.run( 'PRAGMA journal_mode = WAL;' );

kokarn on 6 Jan 2017

❤3

Thanks for the example @kokarn - yep, that's how one would set WAL.