# Unix/Mac - 4 initial slashes in total
engine = create_engine('sqlite:////absolute/path/to/foo.db')
# Windows
engine = create_engine('sqlite:///C:path ofoo.db')
# Windows alternative using raw string
engine = create_engine(r'sqlite:///C:path ofoo.db')