Reading 14

Mar 7, 2012

What is "special" about SQLite's type system, compared to other RDBMSes?

How can we perform basic administration of SQLite databases?

Requirements

Read SQLite chapter 4, pages 101 - 104, "Storage Classes."

Read SQLite chapter 11, pages 311 - 318, "Manifest Typing, Storage Classes, and Affinity."

Read Dataypes in SQLite Version 3, paying attention to "Storage Classes" and "Type Affinity," and "Comparison Expressions."

Read SQLite chatper 4, pages 118 - 124, "Database Administration."

Read SQLite is a Zero-Configuration Database.

Read PRAGMA statments and skim the list of commands and note their functionality.

Grading Criteria

You must print, complete, and hand in Quiz 14.

This is due by 3PM on Friday, Mar 9.