¡@

Home 

python Programming Glossary: dbapi

How can I profile a SQLAlchemy powered application?

http://stackoverflow.com/questions/1171166/how-can-i-profile-a-sqlalchemy-powered-application

sending results over the network being handled by the DBAPI and finally being received by SQLAlchemy's result set and or.. being spent within cursor.execute that's the low level DBAPI call to the database and it means your query should be optimized.. SQL capturing scheme which cuts out the overhead of the DBAPI from the equation although that technique isn't really necessary..

sqlalchemy cursor error during yield_per

http://stackoverflow.com/questions/12233115/sqlalchemy-cursor-error-during-yield-per

this question If you haven't fetched all rows from a DBAPI cursor then it's usually a bad idea to call commit on that cursor's.. In this case psycopg2 which I'm guessing that's the DBAPI you're on is not able to maintain the state of a named cursor.. UsageRecipes WindowedRangeQuery shows one way to do this. DBAPI's are not well suited to dealing with extremely large result..

Passing param to DB .execute for WHERE IN… INT list

http://stackoverflow.com/questions/2253494/passing-param-to-db-execute-for-where-in-int-list

edit fully tested and working example from pg8000 import DBAPI conn DBAPI.connect user a database d host localhost password.. tested and working example from pg8000 import DBAPI conn DBAPI.connect user a database d host localhost password p c conn.cursor..

python list in sql query as parameter

http://stackoverflow.com/questions/283645/python-list-in-sql-query-as-parameter

that would work for both placeholder ' ' # For SQLite. See DBAPI paramstyle. placeholders ' '.join placeholder for unused in..

memory-efficient built-in SqlAlchemy iterator/generator?

http://stackoverflow.com/questions/7389759/memory-efficient-built-in-sqlalchemy-iterator-generator

mysql sqlalchemy share improve this question Most DBAPI implementations fully buffer rows as they are fetched so usually.. really know what you're doing. And also if the underlying DBAPI pre buffers rows there will still be that memory overhead so..