SQLite Write Ahead Logging

[zeeshanjan82]

How would I setup Write Ahead Logging when using Sequelize for SQLite, I would like to setup the WAL for a specific database which I am calling from Sequelize.

[mickhansen]

Would probably be a job for an after connection hook: #5246 which doesn't exist yet.

[damianobarbati]

any news on this? needed for same reason and other pragma statements

[renathoaz]

Although Sequelize does not offer it native, we can user raw query to achieve it: sequelize.query("PRAGMA journal_mode=WAL;")

[bradisbell]

For anyone else looking at this, it seems that the afterConnect hook exists now, but it doesn't seem to work with SQLite, unfortunately. Separate issue opened here: #12487