HackWashU Databases Workshop

This repository contains the materials for a hands-on databases workshop designed and facilitated at Washington University in St. Louis, aimed at beginner-to-intermediate developers and taught through two complete projects rather than abstract lectures.

In the first part, participants build a Python application that queries the iTunes Search API and constructs a normalized SQLite database with related artists, albums, and songs tables connected by foreign keys, covering schema design, deduplication, and CSV export. In the second part, participants build a full-stack Todo app on Supabase (managed PostgreSQL) with sign-up/login/logout authentication and Row Level Security policies that ensure each user can only access their own data.

Highlights

• SQLite schema design with foreign-key relationships using real iTunes API data
• Data deduplication strategies and CSV export
• Full-stack Supabase Todo app with authentication and Row Level Security
• End-to-end coverage of relational databases, APIs, cloud Postgres, and access control