CS257 Software Design
Monday, 28 April 2025

+ Questions

+ API design feedback [about 30-40 minutes]
Observations/lessons/questions/etc.
- Search functions that depend on you knowing the names of things are potentially a problem (in some cases, a drop-down list or a table or something can help)
- 

+ Messy data
- See my post in #announcements after class today

=====

+ More database stuff
- psql directives vs. SQL queries
- normalization
    - what and why
    - joins
    - primary keys
    - foreign keys
    - ...
- populating your database
    - repeatability of the data conversion
    - would an LLM be good at this? how would you know?
    - pandas and similar libraries

+ Coming up
- Assignment due 5/7: API implementation
    which includes 2nd draft endpoints, 2nd draft
    database schema, and implementations of both
- In-class topics 4/30 and 5/2
    - accessing a remote API from a python program
    - accessing a postgres database from a python program
    - more intro to SQL