[issue24887] Sqlite3 has no option to provide open flags

[Berker Peksag]

Changes by Berker Peksag :


--
resolution:  -> out of date
stage: patch review -> resolved
status: open -> closed

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue24887] Sqlite3 has no option to provide open flags

[Aviv Palivoda]

Aviv Palivoda added the comment:

IMO this issue can be closed as the URI filename interface can be used instead 
of the flags. The URI interface parameters can override the flags given as 
specified in:
https://www.sqlite.org/c3ref/open.html

--
nosy: +palaviv

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue24887] Sqlite3 has no option to provide open flags

[Berker Peksag]

Berker Peksag added the comment:

URI filename support has been added in f13bb1e40fbc (Python 3.4+).

db = sqlite3.connect('file:path/to/database?mode=ro', uri=True)

Here is a patch that adds a new flags parameter to sqlite3.connect().

--
dependencies:  -Migrate sqlite3 module to _v2 API to enhance performance
nosy: +berker.peksag
stage: needs patch -> patch review

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue24887] Sqlite3 has no option to provide open flags

[Berker Peksag]

Changes by Berker Peksag :


--
dependencies: +Migrate sqlite3 module to _v2 API to enhance performance
stage:  -> needs patch
type:  -> enhancement

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue24887] Sqlite3 has no option to provide open flags

[Gerhard Häring]

Gerhard Häring added the comment:

It requires switch to the v2 open function of the SQLite C API. While we're at 
it, we can also enable URI filenames.

--
assignee:  - ghaering
nosy: +ghaering
versions: +Python 3.6 -Python 3.4

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue24887
___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue24887] Sqlite3 has no option to provide open flags

[Cal Leeming]

New submission from Cal Leeming:

There are several flags which can be provided to Sqlite3 during connection [1]. 
Alternative libraries such as apsw provide the ability to use these flags [2], 
however it would be nice if `sqlite3` supported this out of the box.

Is there any reason why the wrapper for `sqlite3` does not allow flags to be 
passed in? If not, can we add it?

[1]: https://www.sqlite.org/c3ref/open.html
[2]: https://github.com/rogerbinns/apsw/blob/master/example-code.py#L466

--
components: Library (Lib)
messages: 248770
nosy: sleepycal
priority: normal
severity: normal
status: open
title: Sqlite3 has no option to provide open flags
versions: Python 3.4

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue24887
___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com