CS257 Software Design
Wednesday, 7 May 2025

+ How did the SQL lab go? Questions?

+ SQL notes
- It's a *much* bigger topic than we can touch this term
- I'm not much of an expert
- I should really teach you JOIN ON instead of using WHERE for everything
    (let's see how that goes)
- Pedagogy: which way (JOIN or WHERE) is easier to understand?
- Performance is a huge issue; "indexes", understanding joins in detail, etc.
- Object-relational models (ORMs)
    e.g., SQLAlchemy for Python
- ...

SELECT books.title, authors.surname
FROM books
JOIN books_authors ON books.id=books_authors.book_id
JOIN authors ON authors.id=books_authors.author_id;

SELECT books.title, authors.surname
FROM books
JOIN books_authors ON books.id=books_authors.book_id
JOIN authors ON authors.id=books_authors.author_id
WHERE books.title LIKE 'The%'
ORDER BY authors.surname;

+ How are the APIs going?

+ Readings

+ Security
- Walkthrough of the sql injection sample.
- Video is available. I will definitely expect you to handle this stuff properly for your project.

+ Getting started on HTML
- Walkthrough of a few basics.
- Video is available.
- If time: work on the lab.