Btw, I believe that last semester’s students still have all their stuff in the Redis instances you guys are now using. Feel free to flush their work (the command is “FLUSHDB” at the Redis command line) before adding your stuff.

Here’s today’s XP-bearing activity if you want to practice with it before the quiz. Btw, the full Bene Gesserit Litany Against Fear runs like this: “I must not fear. Fear is the mind-killer. Fear is the little-death that brings total obliteration. I will face my fear. I will permit it to pass over me and…

From today’s class, here’s our final version of the “Hobby Manager” app: The 12:30pm class’s git bundle The 3:30pm class’s git bundle (To unpack a git bundle on your system, type “git clone nameOfGitBundle.git“.)

Quiz #5 is a 60-minute, closed-Python and closed-Redis affair that is due on April 2nd at midnight. Good luck!

Remember that you’ll need to do two things to connect properly to Redis on cpsc: authenticate with the password I gave in class today, and select the correct instance. From the command line: $ redis-cli 127.0.0.1:6379> auth theClassPassword OK 127.0.0.1:6379> select yourInstanceNumber OK 127.0.0.1:6379[yourInstanceNumber]> From Python: import redis r = redis.Redis(password=”theClassPassword”, db=yourInstanceNumber, decode_responses=True, charset=’utf-8′)

From today’s class, the first cut at our “Hobby Manager” app: The 12:30pm class’s git bundle The 3:30pm class’s git bundle (To unpack a git bundle on your system, type “git clone nameOfGitBundle.git“.)

As promised, assignment #7 has arrived and is due next Friday. Good luck, and happy coding!

Madelyn Maddie would appreciate it if you would take the time to complete this survey that she’s using as part of an independent study.

This year’s CPSC Programming Contest will take place on April 11th at 6pm! It involves free pizza, snacks, music, and fun! You should definitely mark this on your calendar if you haven’t already, and be sure to sign up with or without teammates. (You can indicate on the form if you’d like to be paired…

no class or office hours today (mar 20) – send email

From today’s class, the “final” versions of our SQLite-backed ice cream database: The 12:30pm class’s git bundle The 3:30pm class’s git bundle (To unpack a git bundle on your system, type “git clone nameOfGitBundle.git“.)

Several people have asked me questions of the form “hey Stephen, have you graded my X yet?” Note that you can check this yourself by clicking on the “Details” tab of the scoreboard and entering your info. This will show you all the XP you’ve earned so far this semester, in all their glory.

The scoreboard has been updated with lots of stuff, including assignments 3 through 5, quiz #3, and the latest codingbat/leetcode points. Also, a sweet surprise for Stephen: nobody in the class managed to mess up the Honor pledge for quiz #3, which requires a clumsy email back and forth to correct! As a reward for…

Quiz #4 has been posted, and is due on March 18th at midnight. It contains no material from today (or even anything post-spring-break, actually) so fire away!

Okay, time to get excited!! The first milestone for your most excellent DB Tour project has been posted, and is due in little over a week. Get those creative juices flowing, and get cracking!!

From today’s class: The 12:30pm class’s git bundle The 3:30pm class’s git bundle (To unpack a git bundle on your system, type “git clone nameOfGitBundle.git“.)

Hmm. What I meant for you guys to turn in for your “assignment #4’s” was: A git repo, with these contents: Your customer_service.py program that allows the user to interactively purchase tickets Your SQLite database file that has all the stuff from galactic in it (and optionally, other rows left over from your assignment #3)…

We’ve been working on localhost so much that I think I forgot to ever tell you guys how to get your Flask app running on the actual internet on the cpsc server. Duh. The answer is, when you start Flask, do it this way: $ flask run -h 0.0.0.0 -p yourPortNumber The 0.0.0.0 is literal.…

From last week’s class: The 12:30pm class’s git bundle The 3:30pm class’s git bundle (To unpack a git bundle on your system, type “git clone nameOfGitBundle.git“.)

Quiz #3 has been posted to Canvas, and is due after spring break. It’s a short one, timed at 30 minutes.

In case you want to get ahead over spring break, assignment #5 has been posted and is beckoning to you. It is actually due the Thursday after we get back.

At least one student has reported that if they include the “–skip-ssl” at the end of their connnection command, like this: $ mariadb -u yourusername -pyourpassword -h cpsc.umw.edu -P 3306 galactic –skip-ssl that it worked for him. Give it a shot if nothing else is working.

Here are my solutions to the extra credit activity that was due today.

I’ve been having so much fun that I sorta forgot that next week is spring break. 😀 So, here’s some important news regarding assignments 3 and 4: Assignment 4 is now due the Sunday after spring break, not before. Organize your time however you wish. (Obviously I will still accept the assignment if it’s turned…

If you’re having trouble reaching the galactic database, read carefully. You already have a MariaDB account, but the question is what password you’re using. The password should still be the original one that Ian sent you when you got an account on the cpsc.umw.edu server at all. So if you’ve changed your cpsc password since…

No rest for the weary — get ready for the impedance mismatch of the century: a bulk import assignment from mine to yours. It’s due next Sunday, and is not for the faint of heart. Happy importing!

From last week: The final versions of our B&J console programs: 12:30pm version 3:30pm version The bulk import programs: 12:30pm version 3:30pm version

The “sample answer tables” I gave for each question in the extra credit activity are only intended to give the shape of the answer, not any actual answer on any particular database. Apparently I posted a previous version of my SQLite Ben & Jerry’s database at some point, and some students were entering their queries…

From yesterday’s class, the code that used transactions so that multiple copies of it simultaneously accessing the same SQLite database didn’t interfere with each other in a destructive way.

You can earn up to +5XP by legibly writing queries to answer this set of questions. You are allowed to work in groups of up to 4 on this activity. To claim these XP, turn in your legible solutions to my “350” manila envelope no later than 5pm, Monday 24. If you worked in a…

For those of you following the SQLite formatting hassle, here’s today’s ChatGPT debugging session, which ended ambiguously.

From today’s class: The additional practice queries (and sample solutions) The B&J console program: 12:30pm version 3:30pm version Taking the time to go through the rest of the questions on item #1 on your own would be an excellent and praiseworthy idea.

Assignment #3 has been posted, and is due next Sunday Feb. 23rd at midnight. Good luck!

A quick shout out to John Database and GoldCannon for being the first to reach the “Beet It” level! Trivia question for the masses: what’s different about “Beet it” than any of the other semester’s levels?

A couple students asked a question about Item 9 on the quiz: why is the answer 5, not 4? The tables in question were PETS: +———————-+———-+———-+ | owner | dog | numYears | +———————-+———-+———-+ | Laura Ingalls Wilder | Jack | 5 | | Veronica Mars | Backup | 3 | | Robert Barone |…

If you miss points on a quiz question that you clearly had correct, but simply entered in a different format than I was expecting, please don’t just accept the loss and sulk. Instead, tell me about it. For example, suppose the answer to some question was: stephen but for your answer you entered: “stephen” Depending…

I thought this would have been obvious, I guess, but in case not: no, you are not permitted to use the SQLite command line while taking the quiz. (If you think about it, the quiz would be pointless if you could do that, since anyone who knew how to type could get the questions right,…

Unfortunately, I won’t be able to make my usual 11:30am-12:30pm office hours on Tuesday, Feb. 18th. I will be there for the 2-3:30pm block, though.

For quizzes, you are allowed to use all handouts from class, any “cheat sheets” or other things posted on the class website, etc. Basically, anything written down that you want to use is okay. The only things that are not okay are programs (like the Python command line, or ChatGPT.)

From today’s class: Sample solutions to the first nine queries on the page I handed out the beginnings of the ice cream purchasing console app we started on

From today’s class, the queries against the B&J database that (1) reviewed selects, wheres, froms, Cartesian products, and joins, and (2) introduced group bys, havings, order bys, limits, and offsets. (Whew!)

At the usual time, at the same link we’ll be using for class (see Canvas announcement).

Will we have class tomorrow? Yes! See Zoom link in Canvas announcement. Is class mandatory? No, class is never mandatory. You are big boys and girls, and can come and go whenever you choose. If you don’t think you will benefit from being there, you are free to skip any class at all, including tomorrow’s.…

Quiz #2 has been posted, and is due Saturday, Feb 15th at midnight. It’s timed at 45 minutes, and covers all the material from class and readings up through and including Tuesday Feb 11th’s class. Good luck!

Really? Where I come from there at least have to be a few flakes falling first. Anyway, we’re holding to a good pace so far this semester, and I do not want to fall behind. And given past UMW history, my bet is that class is canceled for more than just tomorrow. So here’s the…

From today’s class, the SQL code to recreate our bootstrapped database: early class version late class version

From today’s classes: The SQL code (first section) The SQL code (second section) The handout for which I ran out of copies

Assignment #2 has been posted, and is due next Thursday at midnight. Note carefully: this assignment will probably take a medium amount of time if your assignment #1 was pretty clean, but a large amount of time if your assignment #1 had lots of mistakes. (This is because you’ll need to fix all those mistakes…

Here’s my solution to assignment #1. If you got less than 35XP or so for this assignment, I strongly suggest you carefully look over my solution, and perhaps use it instead of your own as a basis for assignment #2.

Quiz #1 has been posted to Canvas, and is due on Friday at midnight. It is open-book and open-notes, closed-other-humans and closed-AI-assistants-such-as-ChatGPT, and timed at 60 minutes. Good luck!

Abe, a pilot in our class, just now told me that there is in fact an “AID-type thing,” which is called a tail number, and it’s written on the fuselage. Call it what you wish on your homework!

Walk-in tutoring is available for this class (and others)! Kenzie: Wednesdays, 6-8pm, Farmer 025 Matt: Thursdays, 6-8pm, Farmer 026

This may seem inconsistent, but it’s the law in Stephenworld: your database does need to know who flew last October 29th’s United 277, but it does not need to know what runway United 277 might have had reserved on that date — all that it needs to know about runway reservations is what runways are…

Clarifications around crew members: Crew assignments are not normally the same from day to day. (If Charlie/Julie were the pilot/co-pilot on this morning’s United 678, they are very likely not going to be the pilot/co-pilot on tomorrow’s United 678.) All crew members who are certified to fly a type of plane can be either the…

I don’t know if there is something like this in reality (I’m sure there is, though) but we’re going to say that all physical airplanes have an “AID” (“airplane ID”) which is globally unique.

Clarification: when I say to “email me” (with questions, to turn in an assignment, etc.) I really do mean “email me” (to stephen _AT_ umw _DOT_ edu), not “send me a Canvas message” (which I normally do not see and do not read).

Assignment #1 has been posted, and is due a week from today at 5pm (not midnight) to the “350” manila folder hanging outside my office door. If you have any uncertainty about what any of the requirements mean, please be sure to ask! If you don’t ask, and misinterpret a requirement as a result, you’ll…

You can earn up to +2XP per week by spending 30 minutes (per week) completing codingbat.com problems. All you need to do to claim these points each week is send me an email on Friday of the given week with subject line “CPSC/DATA 350 codingbat XP“. In the body of the email, you should type…

Your first graded assignment of the semester — getting used to Python or brushing out the cobwebs — has been posted, and is due Tuesday, Jan 21st at midnight. Send questions!

Okay everybody, it’s time to earn your very first XP (experience point) of the semester, which is not only admirable in itself but is also required in order to earn any other XP at all! All you need to do is head over to the Scoreboard (see link at top of page) and add yourself…

Greetings, Earthlings, and welcome to the spring 2025 version of CPSC/DATA 350: Applications of Databases with Stephen! This site is gonna be hip-hoppin’ with all kinds of great stuff real soon, so stay tuned!