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.