0353cf2c90ac314d73eb584a57c7bf1790586ee8

Author
Ayman Bagabas <ayman.bagabas@gmail.com>
Committer
Ayman Bagabas <ayman.bagabas@gmail.com>
Date

Message

docs: add sqlite foreign key note

Diff

 1diff --git a/README.md b/README.md
 2index 9d7101df521c8fe9fe28f226c7eee7e1f448c26c..3eaaf80ace04eeaec62092d6355f49d2775b9978 100644
 3--- a/README.md
 4+++ b/README.md
 5@@ -200,7 +200,8 @@ db:
 6   driver: "sqlite"
 7   # The database data source name.
 8   # This is driver specific and can be a file path or connection string.
 9-  data_source: "soft-serve.db"
10+  # Make sure foreign key support is enabled when using SQLite.
11+  data_source: "soft-serve.db?_pragma=busy_timeout(5000)&_pragma=foreign_keys(1)"
12 
13 # Git LFS configuration.
14 lfs:
15diff --git a/server/config/file.go b/server/config/file.go
16index 7caa446f0719a8e1cc9685417dffb750d75c8e3a..6560dd15ca752dd80bcc3b1cb0a50559ae65aa51 100644
17--- a/server/config/file.go
18+++ b/server/config/file.go
19@@ -88,6 +88,7 @@ db:
20   driver: "{{ .DB.Driver }}"
21   # The database data source name.
22   # This is driver specific and can be a file path or connection string.
23+  # Make sure foreign key support is enabled when using SQLite.
24   data_source: "{{ .DB.DataSource }}"
25 
26 # Git LFS configuration.