Does Python's SQLAlchemy support server side cursor (for MSSQL)?

Question

I would like to query a MSSQL database using Python's SQLAlchemy. There could be tens of millions of matched rows. In order to use less memory at the server side, I consider using server-side cursor (SSCursor) to slice the matched rows. However, I cannot find examples or resources about SSCursor with SQLAlchemy.

Is it possible to use SSCursor with SQLAlchemy? If this is do-able, can someone show me examples or point out references? If not, any suggested workarounds?

Thanks!

There currently isn't any MSSQL connector that supports server-side cursors. — Gabe
– Gabe, Commented Dec 6, 2022 at 20:39

Luke · Accepted Answer · 2015-07-14 17:15:34Z

1

Yes. You just specify the 'cursorclass' option in the connect_args argument. Here is an example with mysql. You'll need to use an MSSQL connector that implements server side cursors like MySQLdb does for mysql as shown below.

from sqlalchemy import create_engine, MetaData
import MySQLdb.cursors
engine = create_engine('mysql://your:details@go/here', connect_args={'cursorclass': MySQLdb.cursors.SSCursor})

answered Jul 14, 2015 at 17:15

Luke

7,18914 gold badges53 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user1036719 Over a year ago

I didn't accept the answer because I didn't find SSCursor for MSSQL. I googled for a while but got no luck :-(. However, I up-voted your answer since you point out the connect_args argument.

Luke Over a year ago

There may be a connector that lazily fetches rows for MSSQL. oursql is supposed to do that for mysql.

Georg Richter Over a year ago

SSCursor class isn't a cursor which supports server side cursors, it just reads the results in unbuffered mode.

Collectives™ on Stack Overflow

Does Python's SQLAlchemy support server side cursor (for MSSQL)?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related