From 61697e616eb2fadcd8b10f070225bfadc2af615a Mon Sep 17 00:00:00 2001 From: Jacob Casper Date: Thu, 16 Apr 2020 18:28:38 -0500 Subject: [PATCH] Enable WAL to allow concurrent reads This journaling mode means that we won't have to lock for reads and can manage DB locking only around writes. --- db/db.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/db.go b/db/db.go index 1697648..3c04e68 100644 --- a/db/db.go +++ b/db/db.go @@ -12,7 +12,7 @@ type DB struct { } func New() (*DB, error) { - db, err := sql.Open("sqlite3", "brackets.sqlite") + db, err := sql.Open("sqlite3", "brackets.sqlite?_journal_mode=WAL&_foreign_keys=on") if err != nil { return nil, err } -- 2.20.1