Part of the Introduction to Database class at ISC
Three progressive exercises demonstrating different approaches to database interaction with Python and PostgreSQL.
- 1_raw_interaction: Direct SQL queries with low-level psycopg2 library (CRUD operations)
- 2_with_entities: Pydantic entities for type-safe database mapping
- 3_with_orm: Full ORM with Tortoise (relationships and aggregations)
Basically:
- scan the README.md
- implement the
TODOs in the code
Don't forget to check the final questions at the end of the 3_with_orm/README.md!