Recent searches
Search options
It's probably nice that `psycopg2` decided to go with `%s` as the interpolator for prepared statements (even when one would expect other types like `%d`), but I have to wonder why it only supports those and not `?` like many other db interfaces, including the builtin `sqlite`. Does anyone know?
@mdione Because they are all valid options in the DB API standard - https://peps.python.org/pep-0249/ - although a standard would be better I think
Python Enhancement Proposals (PEPs)PEP 249 – Python Database API Specification v2.0 | peps.python.orgThis API has been defined to encourage similarity between the Python modules that are used to access databases. By doing this, we hope to achieve a consistency leading to more easily understood modules, code that is generally more portable across datab...
@andy47 you mean the `paramstyle` attribute in https://peps.python.org/pep-0249/#globals ?
Python Enhancement Proposals (PEPs)PEP 249 – Python Database API Specification v2.0 | peps.python.orgThis API has been defined to encourage similarity between the Python modules that are used to access databases. By doing this, we hope to achieve a consistency leading to more easily understood modules, code that is generally more portable across datab...
@mdione yes indeed