• Added HTML code throughout.
• Extraneous control characters (things like prompt string color changes and stuff like that) have been deleted.
• Added blank lines before each shell prompt and SQLite prompt.
• All commands and other input that I typed is underlined. (I tried making it bold-face, but that seems not to show up all that clearly in some browsers that I tried.)
• Added after-the-fact comment lines, shown in italics.

Nevertheless, I, Jay Jaeckel, hereby certify that this transcript, as shown here, substantially and correctly shows what actually happened.

Run the mkusers.sh shell script, which creates the database, the users table in the database, and inserts the data.
All the SQL to do this is written into this script:      Click here to view mkusers.sh

[jay@fizzle:~]$ ./mkusers.sh

Observe that the database file, cs210class.db, is there now:

[jay@fizzle:~]$ ls -l c*.db
-rw-r--r-- 1 jay jay 3072 Feb 17 19:11 cs210class.db

Now run sqlite3 interactively and view the data we just created:

[jay@fizzle:~]$ sqlite3 cs210class.db
SQLite version 3.6.23.1
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /home/jay/cs210class.db                                   

sqlite> .tables
users

The default output format may be hard to read, but is designed to be easy to use if we want to capture it and parse it with sed, awk, cut, etc.:

sqlite> select * from users;
profdkp|Phillips|Dale
anetp|Police|Anet
aquigley|Quigley|Andrew
brasudo|Hernandez|Octavio
brazils|Brazil|Sean
camery|Mery|Claudia
doggie|Jaeckel|Jay
ejamn|Jamnadas|Elesh
ericg|Greenberg|Eric
kewl|Burton|Andrew
javargas|Vargas|Jesus
jnicklas|Nicklas|Judson
mencinas|Encinas|Margarita
rrawers|Rawers|Robert
zerocnc|Neal|Richard

Note, settings like the following mode, header, and width settings, could be put into a start-up file called .sqliterc in the user’s home directory:

sqlite> .mode column

sqlite> .header on

sqlite> .width 20, 20, 20

This gives us a more easily human-readable print-out:

sqlite> select * from users;
username              lastname              firstname           
--------------------  --------------------  --------------------
profdkp               Phillips              Dale                
anetp                 Police                Anet                
aquigley              Quigley               Andrew              
brasudo               Hernandez             Octavio             
brazils               Brazil                Sean                
camery                Mery                  Claudia             
doggie                Jaeckel               Jay                 
ejamn                 Jamnadas              Elesh               
ericg                 Greenberg             Eric                
kewl                  Burton                Andrew              
javargas              Vargas                Jesus               
jnicklas              Nicklas               Judson              
mencinas              Encinas               Margarita           
rrawers               Rawers                Robert              
zerocnc               Neal                  Richard             

sqlite> .quit

[jay@fizzle:~]$

Work remaining to do (another day):

• Find, download, and install a GUI front-end for SQLite.
  (I plan to skip this until and unless I really really need it. We Unix/Linux system administrators don’t need no steenkin’ GUI interfaces.)
• Learn how to backup/restore SQLite databases, and write script to automate the back-up process.
• Set up a cron to run backup script according to some schedule.

End of transcript.        ◄ Home        ◄ Back to Fedora log