drizzle-team / drizzle-team/drizzle-orm

Activating WAL mode for sqlite

Open
#4,968 1 comment 1 reaction 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.