I am sure most know about this resource, I am always late to the party :) But if you don't know about it, have a look here. Basically videos of different pycon event talks. Excellent stuff. I have known about this resource for a little while, I think I heard about it from the 'Talk Python to me' podcast. Anyway, I thought I would share in case some have not heard about it.
I watched one talk today that I really liked The dictionary even mightier. Really an eye opener. I particularly liked the part on shared keys in dictionaries. But seeing under the hood really helps to understand some decisions that are made. Also shows how to work with python vrs against it to keep your performance up.
This is another cool video from the same site. Python 3 metaprogramming. Only half way through. I am just watching it on tv via my Apple TV, sorry I am not trying to work along with it. While I don't understand every part of it, a lot is familiar. Eg, I am starting to understand/recognise the way you describe the data in SqlAclemy and how they are more than likely using descriptor classes and metadata types.
The other thing this video helped me with is finally getting my head around a standard vanilla decorator. It's always seemed scary to me. Especially when I see the @wraps(function) and importation of the functools module. Sometimes seeing a talk can help demystify something's that you might otherwise have difficulty comprehending just reading about. The video goes way beyond the showing you the use of a vanilla decorator. But just getting to the point were I feel I can write the vanilla one, really starts to open it up for me to start playing with the more advanced type of wrapping.
The other great thing about watching these videos, even if your are not picking up everything in one go. You see a lot of patterns that you may have seen before that look like some expert magic stuff with some pretty logical explainations. When you come across these patterns in others code, it will not be as daunting.
I realise there are a lot of seasoned programmers here that know all this stuff, I am writing things like this for people like me who need to understand python more to go further and maybe respond to things like videos rather than just written material (I am old). Another reason, I like to help here on the forums if I can, it helps me also to learn.
Btw, one reason this talk might have a broader reach is in the title. For python 3. The speaker specifically says the tutorial is to leverage python 3 features. Well, from py 3.3 onwards I think.
Ok, hope it helps someone like it's helping me.
I like the Victor Stinner talk about why Python 3.6 is the fastest CPython ever... Still more reasons to move from Py2 to Py3.
@ccc , will take a look also. Some of these talks are lengthy. Takes a while to get through them. But from everything I see, the momentum is there now for everything to move to py3. I only got interested in Python just went I met you here in the forums. It's amazing how things have changed such a relative short time