Fun for Tuesday, February 28, 2006

<h3>Bureaucracy</h3>

I don't know these people, but they want to know you.  Non-profit orgs
and foundations have generally been uninterested in software development
and open source.  These guys claim to be.

<p>

<a href="http://www.openplans.org/projects/topp-the-organization/careers">http://www.openplans.org/projects/topp-the-organization/careers</a>

<p>

Tomorrow from  from noon to 1:30 in the Stata Center, 4th Floor, 32-G451.

<h3>Cascading Style Sheets</h3>

Julie Melton:  with us this term as the design and CSS coach.

<p>

Six years of experience figuring out how Web services should work and
look.

<ul>
<li><a href="http://philip.greenspun.com/photography/slide-show?size=small&spec_file=/photography/exhibits/hawaii.ss">Philip</a>
<li><a href="http://www.jemelton.com/jemelton/slideshow/index.html?size=small&html_file=http://www.jemelton.com/jemelton/slideshow/photos.html">Julie</a>

</ul>

<p>

<a href="http://www.juliemelton.com/csslecture/">http://www.juliemelton.com/csslecture/</a>

<h3>Normalizing a Data Model</h3>

<pre>
create table mp3s (
	mp3_id			integer primary key,
	the_music		blob,
	submitting_user_id	references users,
	playing_minutes		number,
	musicians		varchar(4000),
	composers		varchar(4000),
	date_recorded		date,
	-- user IDs separated by spaces
	-- (these are users who clicked "add to my personal list"
	personal_list_ids	clob,
	-- user IDs separated by spaces
	-- (these are all the users who've played a song 
	downloading_user_ids	clob,
	-- ratings, separated by spaces
	-- each rating is a user ID,integer (between 1 and 10)
	ratings			clob,
	original_lyrics		clob,
	-- what language are the lyrics in (use codes)
	original_lyric_lang	char(2),
	-- let users upload translations into other languages
	lyric_translation1	clob,
	lyric_translation1_lang	clob,
	lyric_translation2	clob,
	lyric_translation2_lang	clob,
	lyric_translation3	clob,
	lyric_translation3_lang	clob,
	-- if this came from a Compact Disc, store disc info
	-- is this disc on file at cddb.com?  If so, record key.
	cddb_key		varchar(200),
	barcode_on_disc		varchar(100),
	record_label		varchar(200),
	catalog_number		varchar(200),
	total_playing_minutes	number

);
</pre>

<h3>Back to User Registration</h3>



Let's go back to user registration...

<p>

First, let's visit

<a href="http://philip.greenspun.com/seia/user-registration-and-management">http://philip.greenspun.com/seia/user-registration-and-management</a>

and look at the page flow figure.  A lot of people seem to have gotten
confused about the big database block on this page.  It does not
represent Oracle.  It represents a Web page, with its own URL, that
sends a SQL UPDATE command to the RDBMS and then issues a 302 Redirect
back to some other page in the flow.

<ul>
<li><a href="http://ug.mit.edu/">http://ug.mit.edu/</a> (HKN Guide; a
3-person team that didn't have to write any of the email/password code,
but did have to figure out certificates) -- let's hear how this
certificate stuff worked out and also let's look at admin interface

<li>let's look at page flow diagrams that contain the huge block
"database"?  (from the East Asian team site?)

</ul>


<h3>Planning</h3>

Let's hear from the teams...
(new team URL:
<a
href="/teaching/6171/2006-spring/teams">http://philip.greenspun.com/teaching/6171/2006-spring/teams</a> )

<ul>
<li>Ravi and Abdul (atMyPad)

<li>Lev and Brian (ECAC) -- what's the most important content on the
site?  Did they figure out a data model for the ratings and certificates yet?

<li>Mo and Zak/Solidworks

<li>Brian, John, and Kevin (HKN Underground Guide)

<li>David and Pamela (iCompact)

<li>Marios and Fivos (East Asian)


</ul>