Paul Barry's Website - Web Development and Databases

3rd Year Module on the B.Sc. Hons. Degree in Computer Games Development

Games: Web Development and Databases

Academic Year 2018/19 - Class Log.

Thurs 13 Sep 2018: Welcome! Installed Anaconda for Windows (Python 3.6) and played with our first Jupyter Notebook. We also downloaded MariaDB and MongoDB (but have yet to install these - no rush on these). Paul talked quite a bit... he appears to really like Python.

Tues 18 Sep 2018: Started down the road of learning Python, with the help of Jupyter Notebook and the program. Learned a bit about for, while, if, and in, as well as a very quick introduction to Python's lists.

Thurs 20 Sep 2018: Learned all about range() as well as the slice notation for lists (using START, STOP, and STEP). Then we talked about a very important topic: beer.

Tues 25 Sep 2018: We reviewed the beer submissions, then introduced Python's built-in data structures: lists, tuples, dictionaries, and sets.

Thurs 27 Sep 2018: Started our tour of data structures with lists, which lead into the 'on tap' exercise. Solutions to Paul before the start of next Tuesday's class.

Tues 2 Oct 2018: Although they are great, we learned today that lists shouldn't be used for everything. Sometimes, something else is needed, which lead into a discussion of dictionaries.

Thurs 04 Oct 2018: Looked at more dictionaries, frequency counters, tuples, sets, and functions. We are now dangerous when it comes to Python.

Thurs 11 Oct 2018: All about superheroes - using the Python built-in data technologies to do useful stuff.

Tues 16 Oct 2018: Quickly reviewed HTML, then created our first Flask-based web server application.

Thurs 18 Oct 2018: Extended our webapp to include static files, Jinja2 templates, and POSTed data.

Tues 23, Thurs 25, Tues 30 Oct 2018 and Tues 6, Thurs 8 Nov 2018: WordGame was the surprise hit of the day (on Tues 23rd). Assignment #1 was distributed and is now active. Due date/time: Nov 9th, Friday, by 5:00pm.

Tues 13 Nov 2018: Worked through Paul's webapp code (which was then distributed after class).

Thurs 15 Oct 2018: Open Day.

Tues 20 Nov 2018: Started our travels with databases using MariaDB and SQL (as well as DBcm).

Thurs 22 Oct 2018: More databases, a bit of design, and more code.

Tues 27 Nov 2018: Learned about CRUD and played with the Sakila database.

Thurs 29 Oct 2018: Introduced the mycli tool, and played around more with the Sakila database - resulting in a multi-table query.

Tues 04 Dec 2018: Discussed the issues surrounding impedance mismatch, then had a lightening tour of MongoDB.

Thurs 06 Dec 2018: Installed the PyMongo library, then used it to integrate our Python code with MongoDB... effectively negating impedance mismatch.

Tues 11 Dec 2018: Short class with advice on preparation for the class exam this coming Thursday.

Thurs 13 Dec 2018: SQL class exam.

Fri 14 Dec 2018: Last day of term. Happy Holidays!

Tues 8 Jan 2019: Review of last year, discussion of "model answers" for the SQL exam, and a preview of the upcoming webapp development (dbreports).

Thurs 10 Jan 2019: Started building the dbreports webapp with and created.

Tues 15 Jan 2019: Extended the dbreports webapp to use sqlalchemy as well as pandas. Added in new templates, too. Now, all we have to do it make it look pretty.

Thurs 17 Jan 2019: We extended the dbreports system to use CSS as well as Jinja2 templates. It's looking a bit better, but still needs more work.

Tues 22 Jan 2019: One final version of dbreports, which added the odd/even styling to dataframe rows as well as turned URLs into clickable links.

Thurs 24 Jan 2019: Details of the final assignment were distributed, which is now active.

Tues 29 Jan through Tues 12 Feb 2019: Final assignment is ongoing.

Thurs 14 Jan 2019: Final class. Deadline for final CA is midnight tonight.

Return to the Courses page.