CSE 444 Project Support Page 

Autumn 2001

Getting started

    Getting started with cubist      Basics about cubist and your accounts, setting $PATH

    Getting started with PostgreSQL    Starting the psql client, creating a new database, entering data

Sample Code    

Note: all the sample code linked below is available on cubist from directory: /www/education/cse444/samples/

• Perl and CGI     first.pl  explanation

Sample Perl CGI program which posts a simple query to a database and displays results. 

• PHP Sample    first.php  (you need to use view-source to get this)

Personally, I think PHP is a little easier to work with than Perl, so check out this sample code.  

• C/C++ database interface and CGI    details

You can write your cgi programs in c, and connect to the PostgreSQL server using libpq++ libraries. 

• XML Parsing  xtest.pl  personal.xml  db2xml.pl

"xtest.pl" parses the XML content from "personal.xml", selects some nodes and prints their content.  "db2xml.pl" posts a query to the sample beers-bars-drinkers PostgreSQL database, and generates XML from the query results.  Both use the perl module XML::DOM to provide a tree-based interface to XML documents. 

• Sending Email    mailtest.pl 

Here is a simple perl script which sends the user who runs it a test email.

• User Authentication

Here is a helpful link on user authentication for web pages. 

Online Tutorials and Resources

This section will grow over time.  If you find an online resource helpful, let me know and I will post it here.

• More cubist details     UW support page about instructional use of cubist, including machine details.
• PHP on cubist     Technical details about PHP running on cubist.  Produced from running phpinfo( ) function on cubist.
• PostgreSQL Documentation      This will be helpful, including some decent documentation of SQL.
• SQL Reference    This is the SQL part of the PostgreSQL documentation.
• Perl FAQ Index page    Links to various Perl FAQs and resources.
• Perl DBI module     Details on the Perl DBI functions.        
• PHP Tutorial     The basics of PHP, plus links to other tutorials on PHP.