SQL Lab 4: Database Programming and ORM

Part of the Introduction to Database class at ISC

Three progressive exercises demonstrating different approaches to database interaction with Python and PostgreSQL.

Structure

• 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:

1. scan the README.md
2. implement the TODOs in the code

Don't forget to check the final questions at the end of the 3_with_orm/README.md!