nice vid! here are some of my favs: alt + shift + left arrow: goes to previous cursor place alt + shift + right arrow: goes to next cursor place (after doing above) ctrl + w: marks whole word ctrl + w: (multiple times): marks whole expression (for example arguments in method call) ctrl + b == ctrl + mouse click (instead of switching hand to the mouse) ctrl + y: removes whole line ctrl + d: copies line above cursor (or marked word) alt+shift+insert: simultaneous multi-line editing (google it out!) this one seems complex but is simple really and handy: ctrl+shift+*+1 - collapses all code on level 1 (the * and number must be on numpad, sorry latptops) ctrl+shift+*+2 - collapses all code on level 2 ctrl+shift+*+3 - collapses all code on level 3 etc.
Use mouse scroll wheel click on a function and it takes you to the code for that function. If you have a mouse with forward / back buttons you can then go back again.
Got very nice helps from this video : ) But I have a problem: There are some languages after selecting Inject language or reference, but none of them are SQL-like. How to get as many languages as shown in this video? Do I need pycharm pro or just some plugins? Grateful from the bottom of my heart.
Yes, this requires pro version and it is actually PyCharm integration with DataGrip. And it is actually more powerful than author shows. For example notice that in addition to auto-completing the SQL keywords it also suggests table names and column names. So it actually works with your specific database (of course PyCharm needs to be connected to it to get the schema). This also allows me to verify the statement and making sure it returns what I need, I can also refactor the database etc. I don't understand why JetBrains doesn't advertise this more (I'm trying to find a good RU-vid video showing it but I'm failing, there's one from JetBrains, but they are showing EAP version which is still buggy, so it looks less impressive). For me it removes the reason for ORM or at least SQL builders. It basically solves (or at least minimizes) that impedance mismatch between code and SQL.
Its ashame that Pycharm never warn the developer when there is a mistake on the code. Eg. I call a function A from another funtion B. Where the function A was moved to a class or the not yet written yet. Rarely when our pointer enters function B, that time a tiny string, so called warning appears on the debug console. That too no red color. But the project runs... We will come to know this only after we release the project. Shame on pYCHARM.
Use type hints and Pycharm can help out more. Your complaint really is about Python, not Pycharm. With a typed language, Jetbrain IDEs catch all possible errors upfront.
@@falklumo One thing that does not work in the video is the the injected SQL is not checked for possible errors. The WHERE "email" is not null is a WHERE 1=1 clause, and at it's best a SQL linter would warn us about that (probably email shouldn't be in quotes) :-)
Just NO ... yes VSC is more lightweight but I honestly can't think of a single thing VSC is better at than Pycharm .... certainly Pycharm Professional. If you need to use databases for example .... which most prof devs do .... the VSC integration is not even in the same ballpark as Pycharm professional....but it obviously costs money.