starred/vaultwarden

Fork 0

mirror of https://github.com/dani-garcia/vaultwarden.git synced 2026-04-26 01:35:54 +03:00

[GH-ISSUE #842] How to specify connection string to Sqlite as an environment variable? #591

New issue

Closed

opened 2026-03-03 02:01:06 +03:00 by kerem · 6 comments

kerem commented

2026-03-03 02:01:06 +03:00

Owner

Originally created by @tynor88 on GitHub (Jan 31, 2020).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/842

Subject of the issue

Is it possible to specify the SQLite connectionstring, to mitgate WAL issues when hosting with Azure Files? It is possible with e.g. grafana, as specified here:
https://github.com/grafana/grafana/issues/20549#issuecomment-580743349

Originally created by @tynor88 on GitHub (Jan 31, 2020). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/842 ### Subject of the issue Is it possible to specify the SQLite connectionstring, to mitgate WAL issues when hosting with Azure Files? It is possible with e.g. grafana, as specified here: https://github.com/grafana/grafana/issues/20549#issuecomment-580743349

kerem closed this issue

2026-03-03 02:01:06 +03:00

kerem commented

2026-03-03 02:01:07 +03:00

Author

Owner

@dani-garcia commented on GitHub (Feb 4, 2020):

If you mean adding the ?cache=private&mode=rwc bits, you could try adding it to the DATABASE_URL parameter, you shouldn't need the journal_mode=WAL because that's already set by code.

@dani-garcia commented on GitHub (Feb 4, 2020): If you mean adding the `?cache=private&mode=rwc` bits, you could try adding it to the DATABASE_URL parameter, you shouldn't need the journal_mode=WAL because that's already set by code.

kerem commented

2026-03-03 02:01:07 +03:00

Author

Owner

@yggdrasil-tynor commented on GitHub (Feb 11, 2020):

@dani-garcia Thanks for the reply. However it does not work. It tries to create a file named db.sqlite3?cache=private&mode=rwc which obviously doesnt pass the settings to sqlite.
Any idea why it would do that?

@yggdrasil-tynor commented on GitHub (Feb 11, 2020): @dani-garcia Thanks for the reply. However it does not work. It tries to create a file named db.sqlite3?cache=private&mode=rwc which obviously doesnt pass the settings to sqlite. Any idea why it would do that?

kerem commented

2026-03-03 02:01:07 +03:00

Author

Owner

@yggdrasil-tynor commented on GitHub (Feb 19, 2020):

@dani-garcia Sorry to disturb you. Do you have any idea how to circumvent this?

@yggdrasil-tynor commented on GitHub (Feb 19, 2020): @dani-garcia Sorry to disturb you. Do you have any idea how to circumvent this?

kerem commented

2026-03-03 02:01:08 +03:00

Author

Owner

@BlackDex commented on GitHub (Oct 8, 2020):

@TynThordin you can't.
If you want to change the settings of the sqlite database you need to do that afterwards using the sqlite3 tool it self.
Please see: https://www.sqlite.org/pragma.html

@BlackDex commented on GitHub (Oct 8, 2020): @TynThordin you can't. If you want to change the settings of the sqlite database you need to do that afterwards using the sqlite3 tool it self. Please see: https://www.sqlite.org/pragma.html

kerem commented

2026-03-03 02:01:08 +03:00

Author

Owner

@voslucas commented on GitHub (Mar 20, 2022):

@yggdrasil-tynor @tynor88 did you find a solution for sqlite3 hosting on Azure Files?

@voslucas commented on GitHub (Mar 20, 2022): @yggdrasil-tynor @tynor88 did you find a solution for sqlite3 hosting on Azure Files?

kerem commented

2026-03-03 02:01:08 +03:00

Author

Owner

@yggdrasil-tynor commented on GitHub (Mar 21, 2022):

@yggdrasil-tynor @tynor88 did you find a solution for sqlite3 hosting on Azure Files?

Download the sqlitedb file and change the PRAGMA. See what @BlackDex linked to.

We are running it stable for a year now with azure files.

@yggdrasil-tynor commented on GitHub (Mar 21, 2022): > @yggdrasil-tynor @tynor88 did you find a solution for sqlite3 hosting on Azure Files? Download the sqlitedb file and change the PRAGMA. See what @BlackDex linked to. We are running it stable for a year now with azure files.