I'm attempting to create a sqlite DB file within my iOS project. I'm using the code as documented for R/W
let path = NSSearchPathForDirectoriesInDomains(
.documentDirectory, .userDomainMask, true
).first!
let db = try Connection("\(path)/db.sqlite3")
but I end up with a cannot open file at line 45340 of [d24547a13b]
.
The closest resource I've found is Why do I get Unable to Open Database file? but the code there seems to be the same as what I have.
edit: More logs
[logging-persist] os_unix.c:45340: (0) open
- Undefined error: 0
DB file needs to be created under the documents
directory. See Brando Flores' answer: https://stackoverflow.com/a/70514807/346676
do {
let path = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true)
let dbFile = "\(path.first ?? "")/db.sqlite3"
print(dbFile) // show full file path
db = try Connection(dbFile)
}
catch {
print(error)
}