Add suitable pragmas for sqlite

diff --git a/.gitignore b/.gitignore
index 97571d1dec5e9769a5f4c304a26764d16f29d32b..c2f7731796782178df6737b516ecc6a74800019d 100644 (file)
--- a/.gitignore
+++ b/.gitignore
@@ -3,4 +3,4 @@ broadcaster-server
 broadcaster-radio
 test-server.conf
 test-radio.conf
 broadcaster-radio
 test-server.conf
 test-radio.conf

-test.db
+test.db*

diff --git a/server/database.go b/server/database.go
index e6ce752290c4d7bd8547abda54443ed6f11ccb9d..d6bbf920314e1c75ebeca8b2ba844bdf56f93124 100644 (file)
--- a/server/database.go
+++ b/server/database.go
@@ -21,10 +21,19 @@ func InitDatabase() {
        }
        db.sqldb = sqldb
 
        }
        db.sqldb = sqldb
 

+       _, err = db.sqldb.Exec("PRAGMA journal_mode = WAL")
+       if err != nil {
+               log.Fatal(err)
+       }
+

        _, err = db.sqldb.Exec("PRAGMA foreign_keys = ON")
        if err != nil {
        _, err = db.sqldb.Exec("PRAGMA foreign_keys = ON")
        if err != nil {

-               log.Printf("%q\n", err)
-               return
+               log.Fatal(err)
+       }
+
+       _, err = db.sqldb.Exec("PRAGMA busy_timeout = 5000")
+       if err != nil {
+               log.Fatal(err)

        }
 
        sqlStmt := `
        }
 
        sqlStmt := `