functional scratch dockerfile

1 files changed, 12 insertions, 2 deletions

diff --git a/internal/db/setup.go b/internal/db/setup.go
index 038334a..ff56233 100644
--- a/internal/db/setup.go
+++ b/internal/db/setup.go
@@ -10,7 +10,7 @@ import (
 	"strings"
 	"time"
 
-	_ "github.com/mattn/go-sqlite3"
+	_ "modernc.org/sqlite"
 )
 
 var (
@@ -73,7 +73,7 @@ func Setup(ctx context.Context, path string) (*Store, error) {
 		return new(db)
 	}
 
-	db, err := sql.Open("sqlite3", path+opts())
+	db, err := sql.Open("sqlite", path+opts())
 	if err != nil {
 		slog.ErrorContext(ctx, "failed to open DB", "error", err)
 		backupFile(ctx, path)
@@ -84,6 +84,16 @@ func Setup(ctx context.Context, path string) (*Store, error) {
 		return new(db)
 	}
 
+	_, err = db.Exec("PRAGMA foreign_keys = ON")
+	if err != nil {
+		return nil, err
+	}
+
+	_, err = db.Exec("PRAGMA journal_mode=WAL")
+	if err != nil {
+		return nil, err
+	}
+
 	// Run integrity check.
 	var integrity string
 	if err = db.QueryRow("PRAGMA integrity_check;").Scan(&integrity); err != nil || integrity != "ok" {