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 Jul 03 2024 05:25 am	7.0K
	create.sql	Wed Jul 03 2024 05:25 am	415B
	populate.sql	Wed Jul 03 2024 05:25 am	1.3K