[issue22956] Improved support for prepared SQL statements
Markus Elfring
report at bugs.python.org
Thu Nov 27 14:38:39 CET 2014
New submission from Markus Elfring:
An interface for parameterised SQL statements (working with placeholders) is provided by the execute() method from the Cursor class at the moment.
https://docs.python.org/3/library/sqlite3.html#sqlite3.Cursor.execute
I assume that the "SQL Statement Object" from the SQLite C interface is reused there already.
http://sqlite.org/c3ref/stmt.html
I imagine that it will be more efficient occasionally to offer also a base class like "prepared_statement" so that the parameter specification does not need to be parsed for every passed command.
I suggest to improve corresponding preparation and compilation possibilities.
----------
components: Extension Modules
messages: 231759
nosy: elfring
priority: normal
severity: normal
status: open
title: Improved support for prepared SQL statements
_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue22956>
_______________________________________
More information about the Python-bugs-list
mailing list