Cannot create sqlite file with SQLite.swift "cannot open file at line..."

Question

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

No more in the error message than that?

Joakim Danielson
– Joakim Danielson

2021-11-10 16:29:24 +00:00
Commented Nov 10, 2021 at 16:29 — Joakim Danielson
– Joakim Danielson, Commented Nov 10, 2021 at 16:29
Added the last few lines!

Paul
– Paul

2021-11-10 19:01:44 +00:00
Commented Nov 10, 2021 at 19:01 — Paul
– Paul, Commented Nov 10, 2021 at 19:01

wye · Accepted Answer · 2022-07-18 04:42:04Z

2

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)
}

answered Jul 18, 2022 at 4:42

wye

3564 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot create sqlite file with SQLite.swift "cannot open file at line..."

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related