"SQLAlchemy 2.0 - The One-Point-Four-Ening 2021" by: Mike Bayer
HTML-код
- Опубликовано: 17 июн 2021
- "SQLAlchemy 2.0 - The One-Point-Four-Ening 2021" by: Mike Bayer
SQLAlchemy enters the "Python 3 only" world with an all-new rethink of it's Core and ORM APIs known as SQLAlchemy 2.0. Right now, SQLAlchemy 2.0 is in its transitional "caterpillar to butterfly" state, which is the new SQLAlchemy 1.4 series, currently in beta releases.
This tutorial will be the premiere of the classic "from the ground up" tutorial of SQLAlchemy re-imagined for the new 2.0 way of working, featuring a much greater consistency between the "Core" and "ORM" experiences. There will be nary an "engine.execute()" nor a "session.query()" to be found. New ORM configurational patterns are presented a well.
Presented in terms of a four-layered model, which include "Engine and Connection Basics", "Table Metadata", "SQL Expression Language", and "ORM Usage", the tutorial is broken into two sections and API use is presented in terms of a console runner application which participants can install locally and follow along.
Recorded at the 2021 Python Web Conference (2021.pythonwebconf.com) - Наука
timeline
0:0 sqlalchemy basics and new version changes
13:50 sqlalchemy "Onion"
14:24 Engine/connection/transactions
37:08 Table Metadata/reflection/ddl
49:00 Core sql expression language
1:35:56 Object Relational Mapping (orm)
2:17:36 Advanced orm
2:36:17 eager loading
sqlalchemy async is not covered
saves me tons of time thank you!
9:11 Cole Rutledge's mental breakdown
2:14:53 Ben Brenner's mic goes loco.
1:05:28 a little burpy burp by the presenter
19:15 Santa Claus asking the relevant questions everybody was thinking of.
Regardless of the topic, this has been one of the best python videos I've ever watched. He's also a great narrator.
One of the best courses i've ever saw, before this video i always had a feeling that my database isnt safe and sound but now i know that I'm in the very good hands when i'm using sqlalchemy library, i wish the other courses out there had this much deep learning into them but to many of those videos aren't helpfull at all, many of them spreading wrong information and wrong ways to code , thanks a lot
This is a great talk and very helpful for someone just learning to use SQLAlchemy + starting with best practices
Great tutorial. The part about contains_eager was actually very useful to know, I was wondering myself how this would work right up until you explained it, I thought maybe .join would magically handle it somehow but I guessed wrong.
This explained so much to me. Thank you!
Awesome talk 👍Thanks Mike!
9:11 not very happy 😂
he did such a great job explaining.
Excellent !!
you know you can trust a guy when his slides are in terminal. and thanks, mike.
Cole Rutlege, what was happening?
hey thanks
Hi - when using inpect(engine), how do I pivot to a non-default schema - "dbo"?
2:04:20 ~ Does flask sqlalchemy handles "expire on commit" reasonably? (user.email in template does not emit extra query)?
1:12:33 - here Mike inserts `user_id` into the `user_table` but it does not exist. Apparently extra dictionary keys are not being taken into account, otherwise it would have complained with no such column exists. `id`s are being automatically inserted there. You can also see that from the generated sql statement.
1:05:28
i feel good if he done real word small project things get more clear instead explain only . i try to learn but not able to find right solution if any buudy help.
How is he able to show logs of SQL operations in REPL?
you can add `echo=True` inside create_engine() for getting logs
Is the code from the presentation posted anywhere?
Why is the documentation so poor?
Why don't you make som useful examples in the documentation, that takes databases with several schemas into consideration?
these meaningless black box 49:59 on the screen is annoying