set &mode=ro for read-only sqlite connectionsset-sqlite-readonly

1 files changed, 2 insertions, 0 deletions

diff --git a/util/db/dbutil.go b/util/db/dbutil.go
index 123f4e00d..a791b8119 100644
--- a/util/db/dbutil.go
+++ b/util/db/dbutil.go
@@ -358,6 +358,8 @@ func URI(filename string, readOnly bool, memory bool) string {
 	if memory {
 		uri += "&mode=memory"
 		uri += "&cache=shared"
+	} else if readOnly {
+		uri += "&mode=ro" // mode can be one of ro, rw, rwc, or memory
 	}
 	return uri
 }