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.

linux_prompt% sqlite3 dbName.db



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.