I use pycharm daily and have nothing but praise for it. The free edition will probably take you very far, if you want the database features of the paid version there's always DBeaver
Same here, I'm typing that while having it running in the background along with CLion. Some of us benefit from a free license to their entire toolbox via the work on Colour (https://www.colour-science.org/). Their support has been helping us for over half a decade.