CS360

Welcome to CS360

This is going to be a busy, but hopefully exciting semester.  During this course, we will develop a web server to help you understand what is going on under the covers when you write a web application.  We will become familiar with low level operating system functionality that is necessary in any multithreaded networking application.  We will also develop web applications with increasing degrees of sophistication.  Our emphasis will be in giving you experience with real technologies that you will be using in the future in whatever career path you choose.

Comparing Web Technologies

Comparing Web Technologies

There are several things you should think about when selecting a technology for developing web applications:

• Performance – interpreted languages may seem slower, but since the database will be the bottleneck for many applications, the raw speed possible may be less important.
• Model View Controller Architecture – There are frameworks that will help you to use good design principles. It is worth it to use a system where it is difficult to write bad code.
• Library Availability – You dont want to write all of the code yourself
• Documentation – And more importantly, working examples are important
• Maturity – you dont want to pick something that is going to fade away as quickly as it appears, on the other hand, you shouldnt stick with bad technology just because it has been around for a while.
• Language Features – Object oriented, ORM database encapsulation
• Maintanence – Most of your effort will be spent here, so it should be easy to maintain and easy to have other people maintain.
• Culture – To some extend, the culture of the community is important. Are programmers willing to share, help each other? Is it an open source project?

Here are some comparisons of different technologies

• Php vs Rails vs Java
• PhP vs JSP vs ASP vs Coldfusion ..
• PhP vs Perl vs asp vs jsp
• Scripting Languages
• Overview
• Jobs

MYSQL Hints

Mysql installation notes

1. Copy the tar file from ~clement/mysql-5.0.24a.tar
2. untar it into a directory in /tmp so you dont fill up your disk space.
3. Configure and make

./configure --prefix=$HOME/mysqlbin --sysconfdir=$HOME/mysqlbin/mysqlconfig --localstatedir=$HOME/mysqlbin/mysqlstate --with-unix-socket-path=$HOME/mysqlbin/mysql/mysql.sock
make
make install

4. Install the database

~/mysqlbin/bin/mysql_install_db --basedir=$HOME/mysqlbin --datadir=$HOME/mysqlbin/mysqldata --pid-file=$HOME/mysqlbin/mysqlpid  --socket=$HOME/mysqlbin/mysql/mysql.sock

5. Create the configuration file in mysqlbin/my.cnf, it should look something like the following. You should put the port number in that you will be starting the daemon on.

(my.cnf file contents follow)

[mysqld]
datadir=/users/faculty/clement/mysqlbin/mysqldata
socket=/users/faculty/clement/mysqlbin/mysql/mysql.sock
skip-innodb

[mysql.server]
user=clement
basedir=/users/faculty/clement/mysqlbin

[safe_mysqld]
err-log=/users/faculty/clement/mysqlbin/mysql.errlog
pid-file=/users/faculty/clement/mysqlbin/mysqlpid
port=1236
[client]
socket=/users/faculty/clement/mysqlbin/mysql/mysql.sock
port=1236

6. You should put ~/mysqlbin/bin at the first of your search path
7. Add MYSQL_HOME to your environment

 MYSQL_HOME=$HOME/mysqlbin

8. You can start the daemon by running:

mysqld_safe --defaults-file=$HOME/mysqlbin/my.cnf

You can shut down the server using mysqladmin

mysqladmin -u root -p shutdown

If you have trouble with it complaining about permissions to the log file, try substituting your username into the following:

 bin/mysqld_safe --basedir=$HOME/mysqlbin --datadir=$HOME/mysqlbin/mysqldata --pid-file=$HOME/mysqlbin/mysqlpid  --socket=$HOME/mysqlbin/mysql/mysql.sock --port=1236 --log-error=$HOME/mysqlbin/mysql.errlog

9. You can set the root passwd:

mysqladmin -u root password yourpasswd

10. You can create users:
• First start up mysql

   mysql -u root -p 

• Then create a cs360 user

  create user cs360;
  

• Then grant permissions to this user

  grant all on *.* to 'cs360'@'%.cs.byu.edu';
  grant all on *.* to 'cs360'@'localhost';
  flush privileges;
  

• Now you can connect through mysql using this new user

   mysql -u cs360 
   If you want PHP to work, you will also have to recompile php with mysql enabled
  ./configure --prefix=$HOME/php --with-apxs2=$HOME/apache2/bin/apxs --with-pdo-mysql=$HOME/mysqlbin