[DB-SIG] Improved support for prepared SQL statements
SF Markus Elfring
elfring at users.sourceforge.net
Wed Dec 17 14:50:47 CET 2014
> How about:
>
> """
> The prepared operation is only available until the next call to
> one of the .execute*() methods or another call to the .prepare()
> method using a different command string than the one used for
> preparing the previous operation.
> """
Can the prepare() method return a handle for a SQL statement?
Will prepared SQL statements be mapped to a specific class hierarchy
in Python?
> It is possible to open a few cursors, prepare frequently
> used statements on them and them make them accessible via
> a cursor pool. This works well (I know since I've implemented
> such a logic some 14-15 years ago in a large application).
How should the application programming interface look like
in Python for this use case?
> The DB-API standard extensions were added to address proliferation
> of such additions. If possible, the database modules should try
> to standardize on these extensions, which is why discussions such
> as these are useful.
Are there more software improvements in a waiting queue?
Regards,
Markus
More information about the DB-SIG
mailing list