Coding against databases - Revision history

WikiSysop: /* Exercises */

2026-09-30T13:16:51Z

Exercises

← Older revision		Revision as of 15:16, 30 September 2026
Line 21:		Line 21:
	'''1)'''<br>		'''1)'''<br>
	Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>		Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>
	You can look at it from a different angle: A child is born in wedlock when its biological father and mother is married to each other at the time of birth.<br>		You can look at it from a different angle: A child is born in wedlock when its biological father and mother is married to each other at the time of birth. However, the point remains that "out of wedlock" can not be claimed if nothing is known about the father/mother.<br>
	According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.<br>		According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.<br>
	Note that this exercise can be solved in two ways; one with a heavy focus on python coding and simple database access, and one with focus on complex database queries and simple python coding (and probably a mix). Both methods are valid (if you get the right result). Choose between them or do both for the experience.		Note that this exercise can be solved in two ways; one with a heavy focus on python coding and simple database access, and one with focus on complex database queries and simple python coding (and probably a mix). Both methods are valid (if you get the right result). Choose between them or do both for the experience.

WikiSysop: /* Exercises */

2026-09-30T13:14:22Z

Exercises

← Older revision		Revision as of 15:14, 30 September 2026
Line 21:		Line 21:
	'''1)'''<br>		'''1)'''<br>
	Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>		Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>
			You can look at it from a different angle: A child is born in wedlock when its biological father and mother is married to each other at the time of birth.<br>
	According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.<br>		According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.<br>
	Note that this exercise can be solved in two ways; one with a heavy focus on python coding and simple database access, and one with focus on complex database queries and simple python coding (and probably a mix). Both methods are valid (if you get the right result). Choose between them or do both for the experience.		Note that this exercise can be solved in two ways; one with a heavy focus on python coding and simple database access, and one with focus on complex database queries and simple python coding (and probably a mix). Both methods are valid (if you get the right result). Choose between them or do both for the experience.
Line 34:		Line 35:
	This is an interesting challenge, which can be solved by SSH tunneling the mysql port 3306 to the server. The requirements for solving the exercise is understanding and setting up proper SSH tunneling as taught in lesson 1, and that mysql.connector is locally installed in your python distribution.		This is an interesting challenge, which can be solved by SSH tunneling the mysql port 3306 to the server. The requirements for solving the exercise is understanding and setting up proper SSH tunneling as taught in lesson 1, and that mysql.connector is locally installed in your python distribution.
	In principle, this is done by 1 unix command setting up the SSH tunnel.		In principle, this is done by 1 unix command setting up the SSH tunnel.

	~~===Chatboard exercise moved to next lesson===~~

WikiSysop: /* Exercises */

2026-09-17T12:30:52Z

Exercises

← Older revision		Revision as of 14:30, 17 September 2026
Line 16:		Line 16:
	You can find your password in the .my.cnf file in your home.<br>		You can find your password in the .my.cnf file in your home.<br>
	You will mostly use python to solve the exercises. It is not intended that you use advanced mysql queries, but feel free.<br>		You will mostly use python to solve the exercises. It is not intended that you use advanced mysql queries, but feel free.<br>
	'''Note, use this python: /home/ctools/anaconda3-2024.10-1/bin/python3'''		'''Note, use this python: /home/ctools/anaconda3-2024.10-1/bin/python3'''<br>
	'''Warning:''' My results are based on the original database from last week, BEFORE any deletions of persons that happens in the last exercises last week. Perhaps you should redo your database (the loading of csv files).		'''Warning:''' My results are based on the original database from last week, BEFORE any deletions of persons that happens in the last exercises last week. Perhaps you should redo your database (the loading of csv files).

WikiSysop: /* Exercises */

2026-09-17T12:30:33Z

Exercises

← Older revision		Revision as of 14:30, 17 September 2026
Line 17:		Line 17:
	You will mostly use python to solve the exercises. It is not intended that you use advanced mysql queries, but feel free.<br>		You will mostly use python to solve the exercises. It is not intended that you use advanced mysql queries, but feel free.<br>
	'''Note, use this python: /home/ctools/anaconda3-2024.10-1/bin/python3'''		'''Note, use this python: /home/ctools/anaconda3-2024.10-1/bin/python3'''
			'''Warning:''' My results are based on the original database from last week, BEFORE any deletions of persons that happens in the last exercises last week. Perhaps you should redo your database (the loading of csv files).

	'''1)'''<br>		'''1)'''<br>

WikiSysop: /* Exercises */

2026-09-17T12:18:34Z

Exercises

← Older revision		Revision as of 14:18, 17 September 2026
Line 21:		Line 21:
	Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>		Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>
	According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.<br>		According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.<br>
	Note that this exercise can be solved in two ways; one with a heavy focus on python coding and simple database access, and one with focus complex database queries and simple python coding (and probably a mix). Both ~~method~~ are valid (if you get the right result). Choose between them or do both.		Note that this exercise can be solved in two ways; one with a heavy focus on python coding and simple database access, and one with focus on complex database queries and simple python coding (and probably a mix). Both methods are valid (if you get the right result). Choose between them or do both for the experience.

	'''2)'''<br>		'''2)'''<br>

WikiSysop: /* Exercises */

2026-09-17T12:17:39Z

Exercises

← Older revision		Revision as of 14:17, 17 September 2026
Line 20:		Line 20:
	'''1)'''<br>		'''1)'''<br>
	Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>		Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>
	According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.		According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.<br>
			Note that this exercise can be solved in two ways; one with a heavy focus on python coding and simple database access, and one with focus complex database queries and simple python coding (and probably a mix). Both method are valid (if you get the right result). Choose between them or do both.

	'''2)'''<br>		'''2)'''<br>

WikiSysop: /* Exercises */

2025-09-25T17:10:23Z

Exercises

@@ Line 28: / Line 28: @@
 If you look closely at your results, you will find some very interesting family patterns - such is the curse of (badly) generated data.
-'''3) Somewhat optional'''<br>
+'''3) Somewhat optional - really simple once it works'''<br>
 Run your programs again, but this time locally on your laptop, while you use the database on the server.<br>
 This is an interesting challenge, which can be solved by SSH tunneling the mysql port 3306 to the server. The requirements for solving the exercise is understanding and setting up proper SSH tunneling as taught in lesson 1, and that mysql.connector is locally installed in your python distribution.
 In principle, this is done by 1 unix command setting up the SSH tunnel.
-=== Totally optional extra exercise I invented in my dreams Sunday morning: The Chat Board ===
+===Chatboard exercise moved to next lesson===

WikiSysop: /* Totally optional extra exercise I invented in my dreams Sunday morning: The Chat Board */

2025-09-23T11:45:00Z

Totally optional extra exercise I invented in my dreams Sunday morning: The Chat Board

← Older revision		Revision as of 13:45, 23 September 2025
Line 36:		Line 36:
	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). 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-21T11:40:42Z

Exercises

← Older revision		Revision as of 13:40, 21 September 2025
Line 20:		Line 20:
	'''1)'''<br>		'''1)'''<br>
	Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>		Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>
	According to my results: 262 people are born out of wedlock.		According to my results: 262 people are born out of wedlock. That is amazing as it is out of 500 people.

	'''2)'''<br>		'''2)'''<br>

WikiSysop: /* Exercises */

2025-09-21T11:35:49Z

Exercises

← Older revision		Revision as of 13:35, 21 September 2025
Line 19:		Line 19:

	'''1)'''<br>		'''1)'''<br>
	Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).		Who are born out of wedlock? Definition: A child is born out of wedlock if the biological father and mother is not married when the child is born. In the absence of information, you can not claim a child is born out of wedlock (that means if you only know the mother from the database, you can not claim the child is a bastard).<br>
			According to my results: 262 people are born out of wedlock.

	'''2)'''<br>		'''2)'''<br>