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..
|