Feature request: specify chunksize for read_sql · Issue #2908 · pandas-dev/pandas (original) (raw)

It would be helpful to iterate through rows returned from an sql query (sqlite specifically) chunk by chunk just as is done in the read_csv and text files function as described here: http://pandas.pydata.org/pandas-docs/stable/io.html#iterating-through-files-chunk-by-chunk

The return value should be an iterable object. This will prevent queries from returning too large an amount of data, (possibly) exceeding the system memory.