psycopg Row Factories - ORM-free area!

#mathbyteacademy #python

This is Part 2 of 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 looked 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 this second 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...