CSE 403: Software Engineering, Autumn 2013

Teams

See the project proposals page for information about each project.

See the strategies page for information about dealing with various team and process issues.

GitHub

GitHub has educational accounts that allow for private respositories.

cse403 staff GitHub accounts

• Nat Guy (NattyBumppo)
• Calvin Loncaric (Calvin-L)
• Laura Campbell (campbl4)

Cubist

Software

See the Notes on Cubist page for information about the cubist server and software installed there (web server, database, python, ruby, PHP).

Information on mySQL on cubist

Using phpMyAdmin on cubist to administer mySQL

Using phpMyAdmin on cubist with mySQL

Postgres on Cubist (outdated, some links may be broken as this document was removed from its home dir)

Examples

A simple PHP script (hosted on cubist.cs) that opens a connection to a mySQL database and dumps the contents of a simple table to an HTML table.

source

output Note 10/25, IT staff gave instructor ability to flush mySQL connections, and also may have set up a cron job to do this. Let the instructor know if your project uses mySQL and gets error messages saying excess connections need to be flushed.

Example PHP and Postgres (may be outdated, some links may be broken as this document was removed from its home dir)

The JDBC driver for MySQL is installed in $JAVA_HOME/jre/lib/ext/.

A simple Java program (hosted on cubist.cs) that opens a connection to a mySQL database and dumps the contents of a simple table to standard output. As noted in class, this simplistic approach may be vulnerable to SQL injection attacks.

Project Directories

Cubist project directory change of approx 11:45am 10/23

OLD project directories are on cubist at /projects/instr/13au/cse403

NEW project directories are on cubist at /projects/instr/cubist/13au/cse403

If you put an index.html file in your directory, it should serve the page. The URL is http://cubist.cs.washington.edu/projects/13au/cse403/

As of 10/24, all directories are rwx by everyone, so use caution. Unix groups have been established, but course staff have been unable to chgrp on directories. Working on it.

Team Name (unix group and subdirectory name on cubist)

Swapr (cse403f)

Deployed Project on cubist
Deployed Project on Heroku
GitHub Links (private repo1 -- client) (private repo2 -- server) (wiki1 -- on client repo1)

• Eding, A
• Coufal, T
• Eastes, B
• Hao, C
• Chien, E

Course Explorer (cse403b)

Deployed Project on Amazon Web Services
GitHub Links (private repo) Google Links(Documents on Google Drive)

• Roberts, J
• Van Hofwegen, J
• Campbell, B
• Reynolds, I
• Wang, K
• Park, M

Psych Assistant (cse403d)

Deployed Project on cubist, (may require different port number after the colon)
GitHub Links (private repo) (wiki)

• Huber, T
• Quinn, K
• Porter, R
• Hess, A
• Crown, A
• Alfino, C

Whiteboard Interviewer (cse403g)

Deployed Project on cubist
GitHub Links (public repo) (wiki)

• Namara, Y
• Vo, T
• Christanto, D
• Bing, R
• Moore, C
• Tjong, C

CommissionMe (cse403a)

Deployed Project on Heroku
GitHub Links (public repo) (wiki)

• Apacible, J
• Kokila, R
• Corman, K
• Hedeen, A
• Brodhacker, J
• Quan, C

FreeTime (cse403c)

Deployed Project on cubist
GitHub Links (private repo) (wiki)

• Moseley, C
• Wagner, A
• Reiter, N
• Edgren, B
• Wang, S
• Fukuhara, C

ReBook (cse403e)

Deployed Project on Heroku
GitHub (public repo) (wiki)

• Stoddard, J
• Chen, Y
• Fu, A
• Mou, Y
• Brender, S