filmov
tv
More ORM Than Good: Stop Not Writing SQL [PyOhio 2022]
Показать описание
Talk by Catherine Devlin at PyOhio 2022.
Description: You've spent too much time learning tool after tool to avoid writing SQL, when there's a really good way to interact with databases; it's called SQL. Just use it! But not alone; there's a class of simple tools that help you keep your SQL well-organized and tie it cleanly into your Python code:
* For database migrations, Agnostic
* Instead of an ORM, PugSQL
* For ETL transformations, dbt
Description: You've spent too much time learning tool after tool to avoid writing SQL, when there's a really good way to interact with databases; it's called SQL. Just use it! But not alone; there's a class of simple tools that help you keep your SQL well-organized and tie it cleanly into your Python code:
* For database migrations, Agnostic
* Instead of an ORM, PugSQL
* For ETL transformations, dbt