pymonetdb

pymonetdb copied to clipboard

Properly handle multiple result sets

1

Pymonetdb cannot handle it when you send multiple SQL statements in a single call to `Cursor.execute()`. For example, ``` q = """ SELECT value FROM sys.generate_series(0,5); SELECT value from sys.generate_series(10,15);...

joerivanruth

Add support for prepared statements

4

Using prepared statements can be more efficient but [PEP 249](https://peps.python.org/pep-0249/) does not provide an API for it. Instead, [it mentions](https://peps.python.org/pep-0249/#execute) that > A reference to the operation will be retained...

joerivanruth

at the moment we are not thread safe when sharing connections or cursors. This is okay, the DBAPI allowes it, as long as as the `.threadsafety` parameter is set correctly:...

gijzelaerr