Tue March 26

Discuss status of and timeline for the server-side project. Can you present something a week from today?

I'll do a bit more SQL, then let you use the time to work on the project.

I've attached the files we created and the sqlite3 dialog that we did in class.

sql join

Look at this wikipedia explanation .

Joins come in different flavors.

sql recursive

Another way to generate a "temporary" table : the sqlite docs

An example

Work through exercise 10 of SQL Exercises - the warehouse , looking at the intermediate results by hand.

asides

• The Ultimate Guide to JavaScript Fatigue: Realities of our industry | hn discussion

attachments

		last modified	size
	command_line_sqlite3.txt	Wed Jan 22 2025 04:33 am	7.0K
	create.sql	Wed Jan 22 2025 04:33 am	415B
	populate.sql	Wed Jan 22 2025 04:33 am	1.3K