mirror of
https://github.com/dani-garcia/vaultwarden.git
synced 2026-08-26 09:13:24 -05:00
How to specify connection string to Sqlite as an environment variable? #591
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/vaultwarden#591
Reference in New Issue
Block a user
Originally created by @tynor88 on GitHub (Jan 31, 2020).
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
@dani-garcia commented on GitHub (Feb 4, 2020):
If you mean adding the
?cache=private&mode=rwcbits, 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.@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 19, 2020):
@dani-garcia Sorry to disturb you. Do you have any idea how to circumvent this?
@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
@voslucas commented on GitHub (Mar 20, 2022):
@yggdrasil-tynor @tynor88 did you find a solution for sqlite3 hosting on Azure Files?
@yggdrasil-tynor commented on GitHub (Mar 21, 2022):
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.