Oct 11
Midterm projects are not yet graded - I'll take a close look over Hendricks.
Questions about relational databases and SQL from what we've done so
far and your readings?
Continue discussion from Tues by creating a database, inserting data,
and fetching information from it.
Here's a basic example :
Discuss the CRUD operations.
Depending on time, do this in MySQL as well as SQLite,
and with both command line and GUI interfaces. Perhaps
discuss privileges and access (local vs network, users, ...)
in class
We started in class to create a comparable .sql
database creation file for the invoices
example from Tuesdays notes.
You can find that file either via the web
or by ssh'ing to csmarlboro at
coming
Mention "active record pattern" vs "data mapper pattern" approaches to ORM.
I have installed SQLAlchemy and Elixir on csmarlboro.org .
- not (yet) installed on csmarlboro.org
