How do I get sqlite3 to use relative path when connecting to a db?

Question

My flask app is unable to open a db when I use it's relative path:

conn = sqlite3.connect("down.db")

It works fine I use the absolute path:

conn = sqlite3.connect("C:\\Users\\Lenovo\\PycharmProjects\\spacedonline\\down.db")

I've tried using .\ as well. Any help would be appreciated.

What is the output of `os.getcwd()`, and does this match the directory of the database? That aside, explicit paths are a safe bet. — S3DEV, Dec 23 '21 at 14:18

Patrick Nasser · Answer 1 · 2021-12-23T14:35:15.523

1

Assuming the file is in the same directory as the app, you could do something like

import os

path = os.path.dirname(os.path.realpath(__file__)) # directory path of the app
conn = sqlite3.connect(path+"/down.db")

# or - after @S3DEV comment
conn = sqlite3.connect(os.path.join(path, "down.db"))

edited Dec 23 '21 at 14:35

answered Dec 23 '21 at 14:21

Patrick Nasser

13
4

Would recommend using `os.path.join`, not `+`. – S3DEV Dec 23 '21 at 14:24
Thanks Patrick. Needed to add a "\" but other than that, worked perfectly! – D Wojciechowski Dec 23 '21 at 14:26
... hence one reason (among others) for the comment above. – S3DEV Dec 23 '21 at 14:29
I agree @S3DEV, its more pythonic – Patrick Nasser Dec 23 '21 at 14:31

How do I get sqlite3 to use relative path when connecting to a db?

1 Answers1