Postgres SQL Migrations using YoYo
843 بار بازدید -
4 هفته پیش
-
#mathbyteacademy
#mathbyteacademy #python
This is a two-part set of videos that looks into how to hook up Pydantic models to data returned by queries run against a Postgres database using the `psycopg` library.
In Part 1, we'll look at how to run Postgres locally using docker compose, and at what SQL migrations are, and how to implement them using the YoYo library. In the next part, we'll see how we can load data query results from Postgres directly into Pydantic classes (or dataclasses, dictionaries, namedtuples or just plain tuples).
This set of videos is, by design, completely ORM-free!! If you're looking for content on ORMs such SQLAlchemy, then this channel is not for you!
Code for this Video
================
Available in GitHub blog repo: https://github.com/fbaptiste/python-blog
My Python Courses
=================
- Python 3 Fundamentals (introduction to Python)
https://www.udemy.com/course/python3-...
- Pydantic V2: Essentials
https://www.udemy.com/course/pydantic...
- Python 3 Deep Dive (Part 1 - Functional)
https://www.udemy.com/course/python-3...
- Python 3 Deep Dive (Part 2 - Iteration, Generators)
https://www.udemy.com/course/python-3...
- Python 3 Deep Dive (Part 3 - Hash Maps)
https://www.udemy.com/course/python-3...
- Python 3 Deep Dive (Part 4 - OOP)
https://www.udemy.com/course/python-3...
This is a two-part set of videos that looks into how to hook up Pydantic models to data returned by queries run against a Postgres database using the `psycopg` library.
In Part 1, we'll look at how to run Postgres locally using docker compose, and at what SQL migrations are, and how to implement them using the YoYo library. In the next part, we'll see how we can load data query results from Postgres directly into Pydantic classes (or dataclasses, dictionaries, namedtuples or just plain tuples).
This set of videos is, by design, completely ORM-free!! If you're looking for content on ORMs such SQLAlchemy, then this channel is not for you!
Code for this Video
================
Available in GitHub blog repo: https://github.com/fbaptiste/python-blog
My Python Courses
=================
- Python 3 Fundamentals (introduction to Python)
https://www.udemy.com/course/python3-...
- Pydantic V2: Essentials
https://www.udemy.com/course/pydantic...
- Python 3 Deep Dive (Part 1 - Functional)
https://www.udemy.com/course/python-3...
- Python 3 Deep Dive (Part 2 - Iteration, Generators)
https://www.udemy.com/course/python-3...
- Python 3 Deep Dive (Part 3 - Hash Maps)
https://www.udemy.com/course/python-3...
- Python 3 Deep Dive (Part 4 - OOP)
https://www.udemy.com/course/python-3...
4 هفته پیش
در تاریخ 1403/03/28 منتشر شده
است.
843
بـار بازدید شده