Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow raw sql queries or setting journal_mode #1880

Open
TimTreurniet opened this issue Jan 24, 2025 · 0 comments
Open

Allow raw sql queries or setting journal_mode #1880

TimTreurniet opened this issue Jan 24, 2025 · 0 comments

Comments

@TimTreurniet
Copy link

I'm having the following issue in my use case: I want a user to be able to backup/restore a sqlite db to sd card (for a react native app using expo). The problem I'm having is that write ahead loggin (wal) seems to be enabled, which means I can't just only export/import the .db file. If I would be able to execute this query: 'PRAGMA journal_mode = DELETE;', I would be able to use a single db file for backing up and restoring. I don't think this is possible however.

Is there a way to set journal mode? Or should I be backup up/restoring in a different way?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant