CARNEGIE MELLON UNIVERSITY
15-826 - Multimedia databases and data mining
Fall 2012, C. Faloutsos

Steps to setup  SQLite.

We will support sqlite3 . Other  SQL engines are acceptable (mysql, postgress), but they have slight syntax differences, and need a more involved, client/server set up.

• Download the 'shell' version, for your OS (http://www.sqlite.org/download.html) - eg., for linux: http://www.sqlite.org/sqlite-shell-linux-x86-3071400.zip
• After you unzip it, at the shell prompt, type:

linux_prompt% sqlite3 dbName.db

• To import a 'csv' file, use the sqlite3 command .import (Notice that it starts with a 'dot').
• Try .help for sqlite3 documentation (again, it starts with a 'dot').

The above example will create a file ('dbName.db' in this case), which will store all tables/views/indices you create and populate.

---

Last modified: Sept. 9, 2012, by Antonio Juarez and Christos Faloutsos.