How to change max items to show on Pycharm

The debugger isn't really designed to efficiently show large amounts of data. If you're using PyCharm Professional, you can use the "Database" tool for that.

If not, I would suggest iterating in batches of several hundred and use debugger stepping to go forwards, batch at a time.

Thanks for your reply Paul.

Where can I read about Database tool on Pycharm Professional??

Here are some links:

• The documentation
• A tip tweet video and another tip tweet video and one more
• Everything about DataGrip, our "IDE for Databases" that PyCharm Professional embeds

Thanks very much Paul.

I see on this documentation that sql statements dont accept parameters on pycharm. Then cant I execute a sql execute procedure with parameters??

What about dinamic sql? Can I use it? 

I believe that parameterized queries might be possible. But I haven't tried myself.