I am not sure if this works on my end: sqlite> PRAGMA journal_mode = delete; del... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		datadeft on April 13, 2023 \| parent \| context \| favorite \| on: SQLite performance tuning: concurrent reads, multi... I am not sure if this works on my end: `sqlite> PRAGMA journal_mode = delete; delete sqlite> PRAGMA journal_mode = wal2; delete` Does this mean wal2 is not available?

polyrand on April 13, 2023 [–]

wal2 mode is not part of the main development branch of SQLite, you need to compile SQLite yourself from that branch. Same with BEGIN CONCURRENT [0]

[0]: https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...

datadeft on April 13, 2023 | [–]

Thank you!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact