drizzle-team / drizzle-team/drizzle-orm
Activating WAL mode for sqlite
Open
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
I'm trying to activate WAL-mode by generating a[ custom migration file](https://orm.drizzle.team/docs/kit-custom-migrations), and adding this to it:
`PRAGMA journal_mode = WAL;`
Then, I'm running migrations as I usually do, programmatically. But when inspecting the .db file with the sqlite command-line tool, it says journal_mode is still 'delete'.
I'm using drizzle with better-sqlite3. Where am I going wrong?
A big thank you to everyone considering helping me out with this.
Contributor guide
Assessment
This issue has not been assessed yet.