Computer design - Revision history

WikiSysop: /* Exercises */

2025-09-25T17:52:36Z

Exercises

← Older revision		Revision as of 19:52, 25 September 2025
Line 94:		Line 94:
	msgID = cursor.lastrowid		msgID = cursor.lastrowid
	</pre>		</pre>
			The fun part of this exercise is you can use the Chat Board for the rest of the course, once you made the client. You can even develop your client and/or bot more in the progress of the course. Once you get the the SSH tunneling set up, you just run your client from home/your laptop. How can it get any better?

	'''Extra optional fun:''' ChatBots<br>		'''Extra optional fun:''' ChatBots<br>
Line 110:		Line 111:

	I think that was enough ideas for bots.		I think that was enough ideas for bots.

	The fun part of this exercise is you can use the Chat Board for the rest of the course, once you made the client. You can even develop your client and/or bot more in the progress of the course. Once you get the the SSH tunneling set up, you just run your client from home/your laptop. How can it get any better?

WikiSysop: /* Material for the lesson */

2025-09-25T17:51:05Z

Material for the lesson

← Older revision		Revision as of 19:51, 25 September 2025
Line 10:		Line 10:

	Note that the videos are no longer completely aligned with the powerpoints due to a shift in focus.		Note that the videos are no longer completely aligned with the powerpoints due to a shift in focus.

	<!--		<!--
	== Tasks to do ==		== Tasks to do ==

WikiSysop: /* Exercises */

2025-09-25T17:50:30Z

Exercises

← Older revision		Revision as of 19:50, 25 September 2025
Line 28:		Line 28:

	== Exercises ==		== Exercises ==
			Motto: Less fear - more fun

	'''1) Measuring IO speed'''<br>		'''1) Measuring IO speed'''<br>
	Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.		Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.

WikiSysop: /* Exercises */

2025-09-25T17:48:57Z

Exercises

← Older revision		Revision as of 19:48, 25 September 2025
Line 97:		Line 97:
	When you have done your ChatClient you have accumulated enough experience to create a ChatBot. What should the bot do?<br>		When you have done your ChatClient you have accumulated enough experience to create a ChatBot. What should the bot do?<br>
	''Your dream, pal, your vision.''<br>		''Your dream, pal, your vision.''<br>
	~~It could~~ behave like a dog; search for a random or specific user, and bark at them or pee on them.<br>
	~~It could~~ find the latest message and add 'That is what she said yesterday'.<br>		* behave like a dog; search for a random or specific user, and bark at them or pee on them.<br>
	~~It could~~ be more clever and consult external AI and generate a one-line answer/comment.<br>		* find the latest message and add 'That is what she said yesterday'.<br>
	~~It could~~ find the quote of the day and post on the common channel.<br>		* be more clever and consult external AI and generate a one-line answer/comment.<br>
	~~It could~~ camp on the 'Dreams' channel and say to every new poster: "Tell me about your dreams!"<br>		* find the quote of the day and post on the common channel.<br>
	~~It could~~ copy other posters - simply repeating their message.<br>		* camp on the 'Dreams' channel and say to every new poster: "Tell me about your dreams!"<br>
	~~It could~~ advertise an event across all channels.<br>		* copy other posters - simply repeating their message.<br>
	~~It could~~ have a list of people's birthdays, and when the day came about, post "Today is X's birthday" on the common channel.<br>		* advertise an event across all channels.<br>
	If anybody posted a calculation, it could compute the result and post it - just like google.		* have a list of people's birthdays, and when the day came about, post "Today is X's birthday" on the common channel.<br>
			* If anybody posted a calculation, it could compute the result and post it - just like google.

	I think that was enough ideas for bots.		I think that was enough ideas for bots.

	The fun part of this exercise is you can use the Chat Board for the rest of the course, once you made the client. You can even develop your client and/or bot more in the progress of the course. Once you get the the SSH tunneling set up, you just run your client from home/your laptop. How can it get any better?		The fun part of this exercise is you can use the Chat Board for the rest of the course, once you made the client. You can even develop your client and/or bot more in the progress of the course. Once you get the the SSH tunneling set up, you just run your client from home/your laptop. How can it get any better?

WikiSysop: /* Exercises */

2025-09-25T17:46:55Z

Exercises

← Older revision		Revision as of 19:46, 25 September 2025
Line 87:		Line 87:
	You can implement your own commands, like ''/search <name>'', which would search for messages by the person. ''/who'', which would show who has messages. ''/dance'', which displays a message "<yourname> is dancing for you", ''/trueid'', which sets your name to your login name, ''/activity'', which shows when the channels had the latest messages.<br>		You can implement your own commands, like ''/search <name>'', which would search for messages by the person. ''/who'', which would show who has messages. ''/dance'', which displays a message "<yourname> is dancing for you", ''/trueid'', which sets your name to your login name, ''/activity'', which shows when the channels had the latest messages.<br>
	You dream it up - it is your chat client and the more powerful and funny it is, the better chances of you being the next Mark Zuckerberg.		You dream it up - it is your chat client and the more powerful and funny it is, the better chances of you being the next Mark Zuckerberg.

			Hint: Something I found useful is that you can get the ''id'', i.e. the auto incremented primary key of you last inserted message like this:
			<pre>
			cursor.execute("""INSERT INTO messages SET mesg=%s, name=%s, channel=%s""", (chat, nick, channel))
			msgID = cursor.lastrowid
			</pre>

	'''Extra optional fun:''' ChatBots<br>		'''Extra optional fun:''' ChatBots<br>

WikiSysop: /* Exercises */

2025-09-25T17:39:24Z

Exercises

← Older revision		Revision as of 19:39, 25 September 2025
Line 43:		Line 43:
	This is a fun cooperative exercise with databases. You should all make your own Chat client, where you can communicate with the other course participants. The exercise utilizes the concurrent features of databases - the easy update without worry if somebody else is accessing the database at the same time.		This is a fun cooperative exercise with databases. You should all make your own Chat client, where you can communicate with the other course participants. The exercise utilizes the concurrent features of databases - the easy update without worry if somebody else is accessing the database at the same time.

	You use a database called '''chatboard''' that is common to you all. In that database there will be just one table, ''messages'' with the fields;		You use a database called '''chatboard''' that is common to you all. In that database there will be just one table, '''messages''' with the fields;
	<pre>		<pre>
	id primary key auto_increment		id primary key auto_increment
Line 73:		Line 73:
	close database connection		close database connection
	</pre>		</pre>
	As you hopefully can see, this structure makes it easy to start small with simple things and build up with new expanded functionality.		As you hopefully can see, this structure makes it easy to start small with simple things and build up with new expanded functionality. You are to make a python program that runs in the terminal and interacts with you (your commands). If confused, start with making a program that simply pulls all messages from the database and show them. Build up with selecting a channel to show, then the ability to post a message.<br>
			Something that I found to be a challenge was to figure out when to pull new messages from the database and which messages. If you are overwhelmed, then just auto pull the last 5-10 messages every time - but you get a lot redundant information that way. You could rely on the ''/last'' command - you command the pull yourself. I made a pull for only new messages when I pressed <enter> without any command/message.

	A command is an input where the first word starts with slash possibly followed by a parameter. Anything else is just a message to be posted on the selected channel.<br>		A command is an input where the first word starts with slash possibly followed by a parameter. Anything else is just a message to be posted on the selected channel.<br>
	<b>List of commands:</b><br>		<b>List of commands:</b> This is minimum useful functionality/requirement.<br>
	<pre>		<pre>
	/quit Quits the program, possibly leaving a message.		/quit Quits the program, possibly leaving a message.
Line 87:		Line 88:
	You dream it up - it is your chat client and the more powerful and funny it is, the better chances of you being the next Mark Zuckerberg.		You dream it up - it is your chat client and the more powerful and funny it is, the better chances of you being the next Mark Zuckerberg.

			'''Extra optional fun:''' ChatBots<br>
	When you have done your ChatClient you have accumulated enough experience to create a ChatBot. What should the bot do?<br>		When you have done your ChatClient you have accumulated enough experience to create a ChatBot. What should the bot do?<br>
	''Your dream, pal, your vision.''<br>		''Your dream, pal, your vision.''<br>

WikiSysop: /* Exercises */

2025-09-25T17:21:10Z

Exercises

← Older revision		Revision as of 19:21, 25 September 2025
Line 51:		Line 51:
	stamp timestamp default CURRENT_TIMESTAMP		stamp timestamp default CURRENT_TIMESTAMP
	</pre>		</pre>
	The last field, stamp, is automatically updated to the current time when the message is inserted. You only have to insert mesg, name and channel. You can only read the table and insert new rows in the table - that is - create new messages. Only the moderator can delete messages.<br>		The last field, stamp, is automatically updated to the current time when the message is inserted. You only have to insert mesg, name and channel when inserting a row. You can only read the table and insert new rows in the table - that is - create new messages. Only the moderator can delete messages.<br>
	''mesg'' is the message on the chat.<br>		''mesg'' is the message on the chat.<br>
	''name'' is name of the message sender. If NULL, then it is anonymous.<br>		''name'' is name of the message sender. If NULL, then it is anonymous.<br>
Line 81:		Line 81:
	/channel <channelname> Selects/creates the channel for your messages.		/channel <channelname> Selects/creates the channel for your messages.
	/showchannels Shows possible channels.		/showchannels Shows possible channels.
	~~/trueid Sets your name to your login name.~~
	/nick <nickname> Sets your name to <nickname>.		/nick <nickname> Sets your name to <nickname>.
	~~/activity Which channels had the latest messages, and when.~~
	/last <X> Pull last X messages from the chosen channel and display.		/last <X> Pull last X messages from the chosen channel and display.
	</pre>		</pre>
	You can implement your own commands, like ''/search <name>'', which would search for messages by the person. ''/who'', which would show who has messages. ''/dance'', which displays a message "<yourname> is dancing for you". You dream it up - it is your chat client and the more powerful and funny it is, the better chances of you being the next Mark Zuckerberg.		You can implement your own commands, like ''/search <name>'', which would search for messages by the person. ''/who'', which would show who has messages. ''/dance'', which displays a message "<yourname> is dancing for you", ''/trueid'', which sets your name to your login name, ''/activity'', which shows when the channels had the latest messages.<br>
			You dream it up - it is your chat client and the more powerful and funny it is, the better chances of you being the next Mark Zuckerberg.

	When you have done your ChatClient you have accumulated enough experience to create a ChatBot. What should the bot do?<br>		When you have done your ChatClient you have accumulated enough experience to create a ChatBot. What should the bot do?<br>

WikiSysop: /* Exercises */

2025-09-25T17:17:57Z

Exercises

← Older revision		Revision as of 19:17, 25 September 2025
Line 28:		Line 28:

	== Exercises ==		== Exercises ==
	'''1)''' ~~Measuring IO speed~~<br>		'''1) Measuring IO speed'''<br>
	Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.		Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.
	time python mycopy1.py		time python mycopy1.py
Line 40:		Line 40:
	Try to run the scripts on different machines. As minimum you have your laptop and pupil1. DTU's HPC system is also an option.		Try to run the scripts on different machines. As minimum you have your laptop and pupil1. DTU's HPC system is also an option.

	'''2)''' ~~The Chat Board~~<br>		'''2) The Chat Board'''<br>
	This is a fun cooperative exercise with databases. You should all make your own Chat client, where you can communicate with the other course participants. The exercise utilizes the concurrent features of databases - the easy update without worry if somebody else is accessing the database at the same time.		This is a fun cooperative exercise with databases. You should all make your own Chat client, where you can communicate with the other course participants. The exercise utilizes the concurrent features of databases - the easy update without worry if somebody else is accessing the database at the same time.

	You use a database called '''chatboard''' that is common to you all. In that database there will be just one table, ''messages'' with the fields; id (primary key auto_increment), mesg (varchar(500)), name (varchar(15), default NULL), channel (varchar(12), default 'common'), stamp (timestamp) default CURRENT_TIMESTAMP, ~~which means the timestamp~~ is automatically ~~created~~ when the message is inserted. You only have ~~the ability~~ to read the table and insert new rows in the table - that is - create new messages. Only the moderator can delete messages.<br>		You use a database called '''chatboard''' that is common to you all. In that database there will be just one table, ''messages'' with the fields;
			<pre>
			id primary key auto_increment
			mesg varchar(500)
			name varchar(15) default NULL
			channel varchar(12) default 'common'
			stamp timestamp default CURRENT_TIMESTAMP
			</pre>
			The last field, stamp, is automatically updated to the current time when the message is inserted. You only have to insert mesg, name and channel. You can only read the table and insert new rows in the table - that is - create new messages. Only the moderator can delete messages.<br>
	''mesg'' is the message on the chat.<br>		''mesg'' is the message on the chat.<br>
	''name'' is name of the message sender. If NULL, then it is anonymous.<br>		''name'' is name of the message sender. If NULL, then it is anonymous.<br>

WikiSysop: /* Exercises */

2025-09-25T17:12:47Z

Exercises

← Older revision		Revision as of 19:12, 25 September 2025
Line 28:		Line 28:

	== Exercises ==		== Exercises ==
	'''1)''' Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.		'''1)''' Measuring IO speed<br>
			Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.
	time python mycopy1.py		time python mycopy1.py
	Also time the simple Unix cp doing the same task. Delete your copy afterwards.<br>		Also time the simple Unix cp doing the same task. Delete your copy afterwards.<br>
Line 42:		Line 43:
	This is a fun cooperative exercise with databases. You should all make your own Chat client, where you can communicate with the other course participants. The exercise utilizes the concurrent features of databases - the easy update without worry if somebody else is accessing the database at the same time.		This is a fun cooperative exercise with databases. You should all make your own Chat client, where you can communicate with the other course participants. The exercise utilizes the concurrent features of databases - the easy update without worry if somebody else is accessing the database at the same time.

	You use a database called ''chatboard'' that is common to you all. In that database there will be just one table, ''messages'' with the fields; id (primary key auto_increment), mesg (varchar(500)), name (varchar(15), default NULL), channel (varchar(12), default 'common'), stamp (timestamp) default CURRENT_TIMESTAMP, which means the timestamp is automatically created when the message is inserted. You only have the ability to read the table and insert new rows in the table - that is - create new messages. Only the moderator can delete messages.<br>		You use a database called '''chatboard''' that is common to you all. In that database there will be just one table, ''messages'' with the fields; id (primary key auto_increment), mesg (varchar(500)), name (varchar(15), default NULL), channel (varchar(12), default 'common'), stamp (timestamp) default CURRENT_TIMESTAMP, which means the timestamp is automatically created when the message is inserted. You only have the ability to read the table and insert new rows in the table - that is - create new messages. Only the moderator can delete messages.<br>
	''mesg'' is the message on the chat.<br>		''mesg'' is the message on the chat.<br>
	''name'' is name of the message sender. If NULL, then it is anonymous.<br>		''name'' is name of the message sender. If NULL, then it is anonymous.<br>

WikiSysop: /* Exercises */

2025-09-25T17:12:03Z

Exercises

@@ Line 28: / Line 28: @@
 == Exercises ==
-Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.
+'''1)''' Create four python scripts which copies the file human.fsa to your own home, using the four different methods mentioned in the powerpoint. Time the programs using ’time’, e.g.
   time python mycopy1.py
 Also time the simple Unix cp doing the same task. Delete your copy afterwards.<br>
@@ Line 38: / Line 38: @@
 A way around this problem is simply to use a computer with so little memory, that the file buffer system does not come into play. That is your laptop.<br>
 Try to run the scripts on different machines. As minimum you have your laptop and pupil1. DTU's HPC system is also an option.