Install and run SQLite, open your first SQLite database.
Read SQLite pages 17 - 18 ("Where to Get SQLite").
Windows users: also read chapter 2 pages 18 - 20.
POSIX users: also read chapter 2 pages 30 - 32.
Download and install SQLite on your workstation. Configure your PATH (POSIX users, create an alias) so you can run SQLite from any directory.
Verify your path settings:
Open a console window. Type sqlite3. Did it work? Change to another directory ( eg, cd ..). Type sqlite3. Did it work?
Create a dedicated working directory for our projects called cs403
. Where you put this directory is up to you.
Download this SQLite database, save it to your cs403
directory, and open it with the SQLite CLP.
From the SQLite CLP prompt, execute the following:
And also:
To exit the SQLite CLP, enter .quit
(or even just .q
, isn't that charming).
Create a README
file inside your cs403
directory that contains your name, a short description of what this directory is, and the installation location of sqlite
on your machine (eg, "/usr/local/bin/sqlite" or "C:\Program Files\SQLite\bin").
An example README might look like this:
Via Blackboard, submit the contents of your README file (copy and paste, do not attach) and the output of the SELECT statement and .schema command mentioned above.