CSE 344: Section 1

Introductions & SQLite

March 27th, 2023

Administrivia

• HW1 is due on April 4th at 10:00 pm (next Tuesday)
• Start soon! You’ll want to save late days for HW6
• Refer to schedule on course website for office hours and reach out on Ed if you have any other questions

​

2

Icebreakers

• What is your name, year, major, and fun fact about yourself?
• What are you looking forward to this quarter?
• Would you rather be the smartest or the funniest person in the room? Why?

​

Review: Database and DBMS

• What is a database?

​

• What is a DBMS?

​

• What is a Data Model?

​

4

Review: Database and DBMS

• What is a database?
• Collection of organized files containing related data persisting over a long period of time
• What is a DBMS?
• Program that allows for efficient management of large databases
• What is a Data Model?
• It is how we can talk about data conceptually without having to think about implementation.

​

5

SQLite: What is it?

• A standalone program that can run programs and manage a SQLite database
• This might sounds confusing and scary but it will be covered in lecture very soon. Our goal right now is to make sure you have all your tech setup to do homework 1

​

6

SQLite Installation

Note: As a staff we have decided to support only attu and Mac this quarter due to some complications with windows and uncertainty with other linux machines. We are not stopping you from using these machines and OS types but can only provide concrete support if you use attu or Mac. This is a little different from other quarters but should save a lot of headaches down the line. Thanks for understanding.

7

SQLite Installation (Linux and Mac)

Linux -

• Already installed on attu
• Open a terminal, then run the command if not using attu:

sudo apt-get install sqlite3

Mac -

1. Download Homebrew: instructions @ https://brew.sh/
2. Open a terminal, then run the command:

brew install sqlite3

8

SQLite Installation (con’t)

Windows - NOT SUPPORTED by CSE 344

1. Go to https://www.sqlite.org/download.html and download the third option down (sqlite-tools-win32-x86-3360000.zip) under “Precompiled Binaries for Windows”
2. Extract files into directory of your choice
3. Add that directory to the environment variable “path”
4. More information -> How to Install and Use SQLite on Windows

​

9

Recommended Text Editors/IDEs

• For a simple, lightweight experience we would recommend using atom or sublime
• Colors help you notice if you are coding properly in SQL
• If you want to use an IDE (will be more helpful later in the quarter), we recommend using VSCode. Also useful, when connecting via ssh. Reach out on ED if you need help with this.
• Remote SSH through VSCode: https://courses.cs.washington.edu/courses/cse333/22au/resources/VSCode.pdf
• If you run into issues connecting to attu, try reconnecting using the Husky OnNet VPN

Running SQLite

Linux/Mac - Open a terminal, then run the command:

sqlite3 [database]

where “database” is the name of the database

Windows -

1. In cmd, go to directory where you extracted sqlite3.exe files
2. Run the command: sqlite3 [database]

11

SQLite Installation Demo!

12

14

Questions on installation �or running SQLite? �Post on Ed Board or visit us during OH!