SQL Alchemy SQLITE relative path

gistfile1.txt

#SQL Alchemy SQLITE relative path

# Relative path is the path 'raw' after the three initial slashses
e = create_engine('sqlite:///path/to/database.db')
e = create_engine('sqlite:///relative/path/here.db')

# Absolute path is a slash after the three initial slashses
e = create_engine('sqlite:////tmp/absolute_path_database.db')

If you need a step back do 'sqlite:///../tmp/absolute_path_database.db'

Had trouble with just a string, I had to do this:

db_dir = "../../database/db.sqlite"
print(f'os.path.abspath(db_dir): {str(os.path.abspath(db_dir))}')
SQLALCHEMY_DATABASE_URI = "sqlite:///" + os.path.abspath(db_dir)  # works
# SQLALCHEMY_DATABASE_URI = "sqlite:///" + db_dir  # fails

Thanks @valhuber