Resources
Getting SQLite
- Mac OS X: It's already installed!
- Windows: You can download the precompiled binaries here. This blog post has a nice walkthrough of installing SQLite on a Windows computer (specifically the section "Getting Started - Using SQLite on Windows")
- The Macs in the computer labs in McGregor also have SQLite
Example SQL files
In SQLite, you can use .read and specify the filename to execute all SQL statements in the file.